Learning Resources


MySQL Architecture
  • Client/Server basics and communication protocols
  • The SQL parser and storage engine tiers
  • Disk space and memory requirements
  • Installation
Data Definition
  • Databases and tables
  • Data types
  • Constraints, indexes and views
  • Data types for character columns
Data Manipulation
  • Search, add, remove and update data
  • Grouping and aggregate functions
  • Expressions and joining
MySQL Service
  • MySQL distributions
  • Start and stop MySQL server and runtime configuration
  • Log and status files
  • Security-related configuration
Client Programs
  • mysql, mysqladmin, mysqlimport and mysqldump
  • Locking overview
  • Explicit table and advisory locking
Storage Engines
  • MySQL storage engines
  • InnoDB, merge, innodb, memory, federated, cluster storage and other storage engines
Integrity and Repair
  • Table maintenance
  • Repairing tables and auto-repair
Backup and Recovery
  • Binary and textual backups
  • Log and status files
  • Replication, data recovery and mysql cluster
  • User account management and client access control
  • File system, operating system, log files, network and federated table security
  • Using stored routines and triggers
  • Optimizing queries by explain, show warnings and index caching
  • Normalization and storage engine specific optimization for schema optimization
  • Server optimization by tuning memory parameters, using the query cache and stored routines
Error Handling
  • Error Log and Slow Query Log
  • Hardware, disk and network issues
  • Multiple Servers
  • Replication

Apply for Certification