Module 1: Introduction to MySQL database

• MySql System Architecture
• Introduction, History and describe the client/server model
• Understand communication protocols
• Understand how the server supports storage engines

Module 2: MySQL Installation

• RPM Installation
• Generic Binaries Installation

Module 3: MySQL Installation Startup Programs

• How to start, stop and restart the server
• How to check the MySQL status
• How to set/update the MySQL root/user password
• Return Types (SCALAR, TABLE, VOID)

Module 4: MySQL User Management

• How to maintain the user privileges using DDL and DCL Commands
• How to maintain the user privileges using DML Commands
• Practical Examples of Triggers

Module 5: Storage Engines

• MYISAM
• INNODB
• MEMORY
• CSV
• ARCHIVE
• MERGE
• FEDERATED
• BLACKHOLE

Module 6: MySQL Server Performance Optimization/Tuning

• Basic settings in configuration file
• Tuning server parameters
• Optimization techniques

Module 7:MySQL Programs

• Server programs
• Client programs
• Utility programs

Module 8: Locks

• READ (Shared Locks)
• WRITE(Exclusive Locks)

Module 9: MySQL Server Logs

• Error Log
• General Log
• Binary Logs
• Slow Log

Module 10: Backup, Restore, and Recovery

• Physical backup(User Managed Backup)
• Logical backup(Dump Level Backup)
• Using GUI/Backup Tools

Module 11:Query Optimization

• EXPLAIN PLAN
• Optimization of GROUP BY/ORDER BY queries
• WHERE Clause Optimization
• Range Optimization
• Index Merge Optimization
• Engine Condition Pushdown Optimization
• Nested-Loop,Hash,Join Algorithms and Optimization
• Query optimization techniques

Module 12:Partitioning

• Range
• List
• Hash
• Key

Module 13: Replication

• Master-Slave Conjuration
• Master-Master Configuration
• Replication Troubleshooting

Module 14: Upgrading MySQL

• Upgrade Methods
• Upgrade Paths
• Before You Begin
• Performing an In-Place Upgrade
• Performing a Logical Upgrade
• Upgrade Troubleshooting

Module 15: Managing Multiple Instances

• Configure multiple instances in a single server

• How to maintain multiple instances

Module 16: MYSQL Workbench Tool

• Accessing Workbench logs for troubleshooting

• Common issues and error codes

Module 17: Advanced Topics

• MySQL 5.6 Futures
• GTID Replication
• Multi-threaded Slave
• Crash-safe Slave Configuration
• Delay Replication
• Multi-Source Replication
• No-SQL with MySQL