Course Description
The new version 8.0 of MySQL added a significant number of administrative features to the MySQL database including improved error logging, password policies, privileges, accounts, and backup and recovery. Students will perform these administration functions using the MySQL workbench and command line utilities during the course of training. The course may be taken by itself as a one day course of training or as a four day course which includes the topics from this course and the topics from the three day Querying MySQL course.
Objectives
Upon successful completion of this course, you will be able to:
• Approach basic database features and functions
• Cover SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions.
• Comprehensively cover important topics such as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.
Agenda
1. Introduction to MySQL.
2. Installing and Upgrading the MySQL Server.
3. Accessing MySQL.
4. How MySQL Extends and Deviates From SQL.
5. MySQL Data Types.
6. MySQL Index Types.
7. Stored Routines, Triggers and Events.
8. MySQL Views.
9. Transactions in MySQL.
10. MySQL Server Tuning.
11. Storage Engines.
12. Caching with MySQL.
13. Backups, Recovery and Disaster Planning.
14. User Management.
15. Partitioning.
16. Logging and Replication.
17. Measuring Performance.
18. Query Analysis and Index Tuning.
19. Monitoring Your Systems.
20. Securing MySQL.
21. MySQL Data Dictionary.
22. Scaling and High Availability Architectures.
Appendix A. MySQL Proxy.
Appendix B. Functions and Operators.
Appendix C. Resources.
Index.