MySQL Database Administration

Delegates:

Anyone who needs to administer, monitor and support MySQL databases and services. This course is suitable for delegates intending to sit the Certified MySQL DBA I and Certified MySQL DBA 2 examinations.

Objectives:

This course is designed to give administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of MySQL databases and services. Administrators will gain practical experience in setting up, administering and troubleshooting MySQL databases. They will gain an understanding of the architecture of a MySQL database. They will be able to ensure the integrity and availability of a company's data within the MySQL environment.

Note:

Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience.

Topics Covered:

• MySQL Architecture
• Starting, Stopping and Configuring MySQL
• Security-Related Configuration
• Database Creation
• Client Programs for DBA Work
• Character Set Support
• Locking
• Storage Engines
• Table Maintenance
• The Information_Schema Database
• Backup and Recovery
• Stored Procedures
• User Management
• Securing the Server
• Upgrade-Related Security Issues
• Optimizing Queries
• Optimizing Schemas
• Optimizing the Server
• Interpreting Error Messages
• Optimizing the Environment
• Scaling MySQL

Requirements:

A working knowledge of MySQL is required. This can be gained by attendance on the Introduction to MySQL course.