This course will provide students with the skills and tools for monitoring, analyzing and optimizing database performance.
Experience in the following areas is required:-General RDBMS and SQL knowledge and principles -Understanding of DDL objects - tables, Indexes, constraints and others -Understanding of database installation and deployment -Basic knowledge hardware and OS -Understands different methodologies for modeling database structures -Understanding of database installation and deployment -Basic knowledge hardware and OS
1 Day/Lecture & Lab
This course is designed for both Database Developers and Administrators, and anyone involved in monitoring and optimizing MySQL.
- Optimizing Databases and Their Objects
- Optimizing and Tuning Queries
- Tuning MySQL for Performance
- MySQL Table Types