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
