The MySQL for Database Administrators enables DBAs and other database professionals to maximize their organization's investment in MySQL. Learn to configure the MySQL Server, set up replication and security, perform database backups and recoveries, optimize query performance, and configure for high availability.

• Define and implement a backup strategy
• Perform physical and logical backups of your data
• Describe MySQL replication and its role in high availability and scalability
• Configure simple and complex replication topologies
• Administer a replication topology
• Install the MySQL server and client programs
• Upgrade MySQL on a running server
• Describe MySQL architecture
• Explain how MySQL processes, stores, and transmits data
• Configure MySQL server and client programs
• Use server logs and other tools to monitor database activity
• Create and manage users
• Protect your data from common security risks
• Identify and optimize poorly-performing queries
• Troubleshoot server slowdowns and other common problems
• Gain an understanding of MySQL Cloud

• Module 1: Introduction to MySQL 
• Module 2: Install MySQL
• Module 3: Server Configuration
• Module 4: Client & Tools
• Module 5: Obtaining Metadata
• Module 6: Transaction & Locking
• Module 7: InnoDB Storage Engine
• Module 8: Other Storage Engine Information
• Module 9: Partition Table
• Module 10: User Management
• Module 11: MySQL Security
• Module 12: Table Maintenance
• Module 13: Import-Export Data
• Module 14: Programing inside MySQL
• Module 15: View
• Module 16: Backup & Recovery
• Module 17: Running multiple MySQL Server on the same host
• Module 18: Configuring Replication
• Module 19: Introduction to Performance Tuning Concept

• Database Administrator
• Database Developer

SQL Command