MySQL For Database Administrators

This course is highly interactive and uses diverse teaching methods (lectures, self-assessments, group discussions, activities, and videos) to accommodate different learning styles This training will also leverage on participant’s personal life and work experiences.

Course Objectives:

• 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 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
• Administer a replication topology
• Configure and administer InnoDB Cluster

Outline:

• Module 1: Introduction To Mysql
• Module 2: Installing And Upgrading Mysql
• Module 3: Understanding Mysql Architecture
• Module 4: Configuring Mysql
• Module 5 : Monitoring Mysql
• Module 6: Managing Mysql Users
• Module 7: Securing Mysql
• Module 8: Maintaining A Stable System
• Module 9: Optimizing Query Performance
• Module 10: Choosing A Backup Strategy
• Module 11: Performing Backups
• Module 12: Configuring A Replication Topology
• Module 13: Administering A Replication Topology
• Module 14: Achieving High Availability With Mysql Innodb Cluster
• Module 15: Conclusion