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: |
|
Before taking any exam, ensure you 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. |
