MySQL Optimization

PT6584
Summary
This course will provide students with the skills and tools for monitoring, analyzing and optimizing database performance.
Prerequisites
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
Duration
1 Day/Lecture & Lab
Audience
This course is designed for both Database Developers and Administrators, and anyone involved in monitoring and optimizing MySQL.
Topics
  • Optimizing Databases and Their Objects
  • Optimizing and Tuning Queries
  • Tuning MySQL for Performance
  • MySQL Table Types

Related Scheduled Courses