Pluralsight.com - MySQL Query Optimization and Performance Tuning (2013 ENG)
大小
349.55 MB
文件数
46
Info Hash:
7BE0CF915D32C04F1A77668A627CA84F9C096D70
收录时间
2025-12-17 02:32:47
更新时间
2025-12-17 02:32:47
文件列表 (46)
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