mysql admin training syllabus

• Introduction to MySQL
• Describe the features and benefits of MySQL.
• Install the MySQL server and client programs
• 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 and roles
• Protect your data from common security risks
• Troubleshoot server slowdowns and other common problems
• Identify and optimize poorly performing queries
• 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
• Troubleshoot common performance problems.
• Tune MySQL server settings.
• Investigate performance metrics with a range of system databases, command-line utilities, and graphical tools.
• Design your databases and queries for optimal performance.
• Diagnose and fix replication lag.
• Administer a replication topology
• Upgrade MySQL on a running server