Install MySQL
Identify installed Files and Directories
Understand Initial Configuration
Start and Stop MySQL
Understand Server Options, Variables, and the Command Line
Define Option Files
Use System Variables
Identify MySQL Privilege System
Create and Modify User Accounts
Configure Passwords and Account Expiration
Understand Authentication Plug-Ins
Grant Permissions
Reset a Forgotten Root Password
Define Stability
Use Capacity Planning
Troubleshoot
Identify the Causes of Server Slowdowns
Describe InnoDB Recovery
Understand Backups
Create a Backup Strategy
Use MySQL Backup Tools
Define Raw Backup Methods
Explain Techniques that Use the Binary Log
Understand How MySQL Processes Requests
Explain How MySQL Stores Data
Use Tablespaces
Identify Redo and Undo Logs
Define How MySQL Uses Memory
Monitor MySQL with Log Files
Monitor MySQL with Status Variables
Monitor MySQL with Performance Schema
Identify Security Risks
Understand Network security
Use Password Security
Explain Operating System Security
Protect Against SQL Injections
Replicate Conflicts
Explain Replication
Configure Replication
Use MySQL Utilities
Identify Replication Threads
Monitor Replication
Troubleshoot Replication