MySQL Database Administration

5 Days

• DBAs and developers who want to administer MySQL 
• Students wishing to prepare for the MySQL Database Administrator Certification Exams 

Attend the MySQL for Beginners course or some experience with Relational Databases and SQL. 

• Install and Upgrade MySQL for the most common operating systems 
• Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server  
• Use the INFORMATION_SCHEMA database to access metadata  

• Perform the MySQL start and shutdown operations  
• Configure MySQL server options at runtime  
• Evaluate data types and character sets for performance issues  
• Understand data locking concepts and the different levels of locking in MySQL  
• Differentiate between the multiple storage engines available in MySQL  

• Perform backup and restore operations utilizing multiple MySQL tools  
• Maintain integrity of a MySQL installation utilizing security protocols  
• Use stored routines and triggers for administration tasks  
• Manage, apply and understand the reason for using views  
• Improve performance through query optimization  

• Optimize Schemas (Databases) utilizing multiple techniques  
• Utilize MySQL monitoring tools to improve server performance  
• Compare multiple environment options to improve server performance  

• Introduction 

• MySQL Architecture 
• The MySQL Server 
• Configuring the MySQL Server 
• MySQL Clients 
• Overview of Data Types 

• Metadata 
• Storage Engines 
• Partitioning 
• Transactions and Locking 
• Security and User Management 

• Table Maintenance 
• Exporting and Importing Data 
• Programming with MySQL 
• Views 
• Backup and Recovery 

• Introduction to Performance Tuning 
• Introduction to High Availability 
• Conclusion