Section 1: MySQL Architecture (10%) Client/Server Overview
Communication Protocols
The SQL Parser and Storage Engine Tiers
How MySQL Uses Disk Space
How MySQL Uses Memory

Section 2: Starting, Stopping, and Configuring MySQL (20%) 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

Section 3: Client Programs for DBA Work (5%) Overview of Administrative Clients
mysql
mysqladmin
mysqlimport
mysqldump
Client Program Limitations

Section 4: Character Set Support (5%) Performance Issues
Choosing Data Types for Character Columns

Section 5: Locking (10%) Locking Concepts
Explicit Table Locking
Advisory Locking

Section 6: Storage Engines (20%) 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

Section 7: Data (Table) Maintenance (10%) Types of Table Maintenance Operations
SQL Statements for Table Maintenance
Client and Utility Programs for Table Maintenance
Repairing InnoDB Tables
Enabling MyISAM Auto-Repair

Section 8: The INFORMATION_SCHEMA Database (5%) INFORMATION_SCHEMA Access Syntax
INFORMATION_SCHEMA Versus SHOW
Limitations of INFORMATION_SCHEMA

Section 9: Data Backup and Recovery Methods (15%) 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