MySQL is (as of July 2013) the world's second most widely used relational database management system (RDBMS) and most widely used open-source RDBMS. Browse through the contents of the program.
MYSQL Course Contents |
Client/Server Overview |
Communication Protocols |
The SQL Parser and Storage Engine Tiers |
How MySQL Uses Disk Space |
How MySQL Uses Memory |
Types of MySQL Distributions |
Starting and Stopping MySQL Server on Windows |
Starting and Stopping MySQL Server on Unix |
Runtime MySQL Configuration |
Log and Status Files |
Loading Time Zone Tables |
Security-Related Configuration |
Setting the Default SQL Mode |
Upgrading MySQL |
Overview of Administrative Clients |
mysql |
mysqladmin |
mysqlimport |
mysqldump |
Client Program Limitations |
Performance Issues |
Choosing Data Types for Character Columns |
Locking Concepts |
Explicit Table Locking |
Advisory Locking |
MySQL Storage Engines |
The MyISAM Engine |
The MERGE Engine |
The InnoDB Engine |
The MEMORY Engine |
The FEDERATED Engine |
The Cluster Storage Engine |
Other Storage Engines |
Types of Table Maintenance Operations |
SQL Statements for Table Maintenance |
Client and Utility Programs for Table Maintenance |
Repairing InnoDB Tables |
Enabling MyISAM Auto-Repair |
INFORMATION_SCHEMA Access Syntax |
INFORMATION_SCHEMA Versus SHOW |
Limitations of INFORMATION_SCHEMA |
Data Backup and Recovery Methods |
Introduction |
Binary Versus Textual Backups |
Making Binary Backups |
Making Text Backups |
Backing Up Log and Status Files |
Replication as an Aid to Backup |
MySQL Cluster as Disaster Prevention |
Data Recovery |
Using Stored Routines and Triggers for Security Purposes |
Using Stored Routines to Enhance Performance |
User Account Management |
Client Access Control |
Security Issues |
Operating System Security |
Filesystem Security |
Log Files and Security |
Network Security |
FEDERATED Table Security |
Upgrading the Privilege Tables |
Security-Related SQL Mode Values |
Identifying Candidates for Query Analysis |
Using EXPLAIN to Analyze Queries |
Using SHOW WARNINGS for Optimization |
MyISAM Index Caching |
General Table Optimizations |
Normalization |
MyISAM-Specific Optimizations |
InnoDB-Specific Optimizations |
MERGE-Specific Optimizations |
MEMORY-Specific Optimizations |
Interpreting mysqld Server Information |
Measuring Server Load |
Tuning Memory Parameters |
Using the Query Cache |
Sources of Diagnostic Information |
Using the Error Log for Diagnostic Purposes |
Using The Slow Query Log for Diagnostic Purposes |
Choosing Hardware for MySQL Use |
Configuring Disks for MySQL Use |
Network Issues |
Optimizing the Operating System for MySQL Use |
Scaling MySQL |
Using Multiple Servers |
Replication |