Getting the Best MySQL Performance in Your Products: Part III, Query Tuning

Part III of the four-part performance presentation, series, will show you how to tune queries in your product's MySQL embedded or bundled database.  Part III reviews the following elements of query tuning (below), building on the steps  covered in  Part 1, the Fundamentals and Part II, Beyond the Basics.
1) Monitoring your queries
2) Understanding query performance
3) Indexes
4) Using temporary tables
5) GROUP BY operations
6) Subqueries