Pluralsight Com - MySQL Query Optimization and Performance Tuning (2013 ENG)
File List
| File | Size |
|---|---|
| 00. Introduction/00_01. Introduction.mp4 | 7.31 MB |
| 01. Optimizing Data Access/01_01. Introduction.mp4 | 1.36 MB |
| 01. Optimizing Data Access/01_02. Prerequisite.mp4 | 1.23 MB |
| 01. Optimizing Data Access/01_03. Overheard.mp4 | 1.57 MB |
| 01. Optimizing Data Access/01_04. Understanding Data Needs.mp4 | 3.43 MB |
| 01. Optimizing Data Access/01_05. Demo - Setup.mp4 | 2.12 MB |
| 01. Optimizing Data Access/01_06. Demo - Best Practices for Data Access.mp4 | 7.21 MB |
| 01. Optimizing Data Access/01_07. Demo - Why SELECT Star (x) is Bad Idea.mp4 | 19.37 MB |
| 01. Optimizing Data Access/01_08. Summary in Sixty Seconds.mp4 | 873.55 KB |
| 02. Understanding MySQL Query Optimization/02_01. Introduction.mp4 | 1.53 MB |
| 02. Understanding MySQL Query Optimization/02_02. Execution Path of a Query.mp4 | 1.34 MB |
| 02. Understanding MySQL Query Optimization/02_03. Client Protocols.mp4 | 2.81 MB |
| 02. Understanding MySQL Query Optimization/02_04. Query Cache.mp4 | 1.37 MB |
| 02. Understanding MySQL Query Optimization/02_05. Parser.mp4 | 1.11 MB |
| 02. Understanding MySQL Query Optimization/02_06. Preprocessor.mp4 | 999.76 KB |
| 02. Understanding MySQL Query Optimization/02_07. Query Optimizer.mp4 | 2.46 MB |
| 02. Understanding MySQL Query Optimization/02_08. Query Optimizer Responsibilities.mp4 | 2.39 MB |
| 02. Understanding MySQL Query Optimization/02_09. Query Optimizer Limitations.mp4 | 3.69 MB |
| 02. Understanding MySQL Query Optimization/02_10. Query Execution Engine and Storage.mp4 | 2.97 MB |
| 02. Understanding MySQL Query Optimization/02_11. Returning Result to Client.mp4 | 1.86 MB |
| 02. Understanding MySQL Query Optimization/02_12. Additional Notes on Query Optimizer.mp4 | 1.44 MB |
| 02. Understanding MySQL Query Optimization/02_13. Maximizing Query Optimizer Performance.mp4 | 885.15 KB |
| 02. Understanding MySQL Query Optimization/02_14. Understanding Query States.mp4 | 5.03 MB |
| 02. Understanding MySQL Query Optimization/02_15. Demo - Show Full Processlist.mp4 | 6.11 MB |
| 02. Understanding MySQL Query Optimization/02_16. Understanding Explain Command.mp4 | 771.46 KB |
| 02. Understanding MySQL Query Optimization/02_17. Demo - Explain Command.mp4 | 11.57 MB |
| 02. Understanding MySQL Query Optimization/02_18. Demo - Explain Extended Command.mp4 | 5.6 MB |
| 02. Understanding MySQL Query Optimization/02_19. Summary in Sixty Seconds.mp4 | 931.04 KB |
| 03. Performance Optimization by Practical Query Tuning/03_01. Introduction.mp4 | 2.28 MB |
| 03. Performance Optimization by Practical Query Tuning/03_02. Demo - Index Used for SELECT clause.mp4 | 30.28 MB |
| 03. Performance Optimization by Practical Query Tuning/03_03. Demo - One Complex Query vs Multiple Simple Queries.mp4 | 14.2 MB |
| 03. Performance Optimization by Practical Query Tuning/03_04. Demo - One Complex Query vs Multiple Simple Queries - Part 2.mp4 | 14.92 MB |
| 03. Performance Optimization by Practical Query Tuning/03_05. Demo - One Complex Query vs Multiple Simple Queries with Index.mp4 | 20.73 MB |
| 03. Performance Optimization by Practical Query Tuning/03_06. Demo - Table Order in Join Clause - INNER JOIN.mp4 | 23.52 MB |
| 03. Performance Optimization by Practical Query Tuning/03_07. Demo - Table Order in Join Clause - OUTER JOIN.mp4 | 13.22 MB |
| 03. Performance Optimization by Practical Query Tuning/03_08. Demo - Most Optimal Choice - Subquery vs Exists vs Joins.mp4 | 34.43 MB |
| 03. Performance Optimization by Practical Query Tuning/03_09. Demo - Most Optimal Choice - Subquery vs Exists vs Joins - Part 2.mp4 | 13.79 MB |
| 03. Performance Optimization by Practical Query Tuning/03_10. Demo - Tuning Aggregate Function.mp4 | 16.65 MB |
| 03. Performance Optimization by Practical Query Tuning/03_11. Demo - Optimizing Group By Clause.mp4 | 21.86 MB |
| 03. Performance Optimization by Practical Query Tuning/03_12. Demo - Optimizing Paging with LIMIT Clause.mp4 | 9.38 MB |
| 03. Performance Optimization by Practical Query Tuning/03_13. Demo - Impact on Performance of UNION and UNION ALL.mp4 | 13.07 MB |
| 03. Performance Optimization by Practical Query Tuning/03_14. Demo - Index and Not Equal to Operator.mp4 | 7.49 MB |
| 03. Performance Optimization by Practical Query Tuning/03_15. Summary in Sixty Seconds.mp4 | 1.21 MB |
| 04. Best Practices/04_01. Best Practices.mp4 | 6.85 MB |
| Exercise_Files/MySQL-Query-Optimization-Performance-Tuning.zip | 6.3 MB |
| Exercise_Files/subtitles_EN.zip | 75.24 KB |
Trackers
No trackers found.