Optimizing SQL queries in MySQL

• The course is designed for database professionals who have experience with the development of database system and want to know how to write optimized SQL queries

• Use advanced techniques for optimizing SQL  
• Design and use indexes  
• Optimization procedure  
• Other optimization methods

• Basic knowledge of IT and PC  
• Knowledge of SQL in MySQL  
• Knowledge of database development

Recap advanced queries to optimize performance

• Integrity Constraints  
• Join techniques  
• Subqueries and Operators

Indexes

• Structure and types of indexes
• Design and development indexes
• Index usage with SELECT statement
• Explain
• FullText search

Performance optimization

• Restructuring query  
• Practical approach to optimizing

Other types of optimization

• Partitioning  
• Optimization tables  
• Cache  
• Configure MySQL  
• Important configuration parameters to optimize

Previous courses

Advanced SQL in MySQL [GOC663]