MySQL Query Optimization and Performance Tuning

1. 04. Performance Optimization by Practical Query Tuning10. Demo Tuning Aggregate Function.wmv20.09 MB
2. 04. Performance Optimization by Practical Query Tuning04. Demo One Complex Query vs Multiple Simple Queries - Part 2.wmv17.39 MB
3. 04. Performance Optimization by Practical Query Tuning03. Demo One Complex Query vs Multiple Simple Queries.wmv17.17 MB
4. 04. Performance Optimization by Practical Query Tuning08. Demo Most Optimal Choice - Subquery vs Exists vs Joins.wmv16.48 MB
5. 02. Optimizing Data Access07. Demo Why SELECT Star ( ) is Bad Idea.wmv15.99 MB
6. 04. Performance Optimization by Practical Query Tuning13. Demo Impact on Performance of UNION and UNION ALL.wmv15.9 MB
7. 04. Performance Optimization by Practical Query Tuning09. Demo Most Optimal Choice - Subquery vs Exists vs Joins - Part 2.wmv15.64 MB
8. 04. Performance Optimization by Practical Query Tuning07. Demo Table Order in Join Clause - OUTER JOIN.wmv14.51 MB
9. 03. Understanding MySQL Query Optimization17. Demo Explain Command.wmv13.84 MB
10. 04. Performance Optimization by Practical Query Tuning02. Demo Index Used for SELECT clause.wmv13.83 MB
11. 05. Best Practices01. Best Practices.wmv13.12 MB
12. 04. Performance Optimization by Practical Query Tuning12. Demo Optimizing Paging with LIMIT Clause.wmv10.79 MB
13. 04. Performance Optimization by Practical Query Tuning06. Demo Table Order in Join Clause - INNER JOIN.wmv10.37 MB
14. 04. Performance Optimization by Practical Query Tuning11. Demo Optimizing Group By Clause.wmv10.3 MB
15. 04. Performance Optimization by Practical Query Tuning05. Demo One Complex Query vs Multiple Simple Queries with Index.wmv9.46 MB
16. 04. Performance Optimization by Practical Query Tuning14. Demo Index and Not Equal to Operator.wmv9.11 MB
17. 02. Optimizing Data Access06. Demo Best Practices for Data Access.wmv8.88 MB
18. 03. Understanding MySQL Query Optimization15. Demo Show Full Processlist.wmv8.17 MB
19. 03. Understanding MySQL Query Optimization09. Query Optimizer Limitations.wmv7.92 MB
20. 01. Introduction01. Introduction.wmv7.88 MB
21. 03. Understanding MySQL Query Optimization18. Demo Explain Extended Command.wmv7.37 MB
22. 02. Optimizing Data Access04. Understanding Data Needs.wmv6.94 MB
23. 03. Understanding MySQL Query Optimization14. Understanding Query States.wmv6.89 MB
24. 03. Understanding MySQL Query Optimization03. Client Protocols.wmv6.71 MB
25. mysql-query-optimization-performance-tuning.zip6.3 MB
26. 03. Understanding MySQL Query Optimization10. Query Execution Engine and Storage.wmv5.19 MB
27. 03. Understanding MySQL Query Optimization08. Query Optimizer Responsibilities.wmv4.98 MB
28. 04. Performance Optimization by Practical Query Tuning01. Introduction.wmv4.88 MB
29. 03. Understanding MySQL Query Optimization07. Query Optimizer.wmv4.76 MB
30. 02. Optimizing Data Access03. Overheard.wmv3.85 MB
31. 02. Optimizing Data Access01. Introduction.wmv3.46 MB
32. 03. Understanding MySQL Query Optimization04. Query Cache.wmv3.23 MB
33. 03. Understanding MySQL Query Optimization01. Introduction.wmv3.14 MB
34. 03. Understanding MySQL Query Optimization12. Additional Notes on Query Optimizer.wmv3.06 MB
35. 03. Understanding MySQL Query Optimization11. Returning Result to Client.wmv3.06 MB
36. 02. Optimizing Data Access02. Prerequisite.wmv2.82 MB
37. 03. Understanding MySQL Query Optimization05. Parser.wmv2.43 MB
38. 02. Optimizing Data Access05. Demo Setup.wmv2.37 MB
39. 04. Performance Optimization by Practical Query Tuning15. Summary in Sixty Seconds.wmv2.27 MB
40. 03. Understanding MySQL Query Optimization02. Execution Path of a Query.wmv2.12 MB
41. 03. Understanding MySQL Query Optimization13. Maximizing Query Optimizer Performance.wmv2.08 MB
42. 03. Understanding MySQL Query Optimization06. Preprocessor.wmv2.04 MB
43. 03. Understanding MySQL Query Optimization16. Understanding Explain Command.wmv1.88 MB
44. 03. Understanding MySQL Query Optimization19. Summary in Sixty Seconds.wmv1.7 MB
45. 02. Optimizing Data Access08. Summary in Sixty Seconds.wmv1.48 MB