TorBT - Torrents and Magnet Links Search Engine
Pluralsight.com - MySQL Query Optimization and Performance Tuning (2013 ENG)
- Date: 2025-12-23
- Size: 350 MB
- Files: 46
File Name
Size
00. Introduction/00_01. Introduction.mp4
7.3 MB
01. Optimizing Data Access/01_01. Introduction.mp4
1.4 MB
01. Optimizing Data Access/01_02. Prerequisite.mp4
1.2 MB
01. Optimizing Data Access/01_03. Overheard.mp4
1.6 MB
01. Optimizing Data Access/01_04. Understanding Data Needs.mp4
3.4 MB
01. Optimizing Data Access/01_05. Demo - Setup.mp4
2.1 MB
01. Optimizing Data Access/01_06. Demo - Best Practices for Data Access.mp4
7.2 MB
01. Optimizing Data Access/01_07. Demo - Why SELECT Star (x) is Bad Idea.mp4
19 MB
01. Optimizing Data Access/01_08. Summary in Sixty Seconds.mp4
874 kB
02. Understanding MySQL Query Optimization/02_01. Introduction.mp4
1.5 MB
02. Understanding MySQL Query Optimization/02_02. Execution Path of a Query.mp4
1.3 MB
02. Understanding MySQL Query Optimization/02_03. Client Protocols.mp4
2.8 MB
02. Understanding MySQL Query Optimization/02_04. Query Cache.mp4
1.4 MB
02. Understanding MySQL Query Optimization/02_05. Parser.mp4
1.1 MB
02. Understanding MySQL Query Optimization/02_06. Preprocessor.mp4
1000 kB
02. Understanding MySQL Query Optimization/02_07. Query Optimizer.mp4
2.5 MB
02. Understanding MySQL Query Optimization/02_08. Query Optimizer Responsibilities.mp4
2.4 MB
02. Understanding MySQL Query Optimization/02_09. Query Optimizer Limitations.mp4
3.7 MB
02. Understanding MySQL Query Optimization/02_10. Query Execution Engine and Storage.mp4
3.0 MB
02. Understanding MySQL Query Optimization/02_11. Returning Result to Client.mp4
1.9 MB
02. Understanding MySQL Query Optimization/02_12. Additional Notes on Query Optimizer.mp4
1.4 MB
02. Understanding MySQL Query Optimization/02_13. Maximizing Query Optimizer Performance.mp4
885 kB
02. Understanding MySQL Query Optimization/02_14. Understanding Query States.mp4
5.0 MB
02. Understanding MySQL Query Optimization/02_15. Demo - Show Full Processlist.mp4
6.1 MB
02. Understanding MySQL Query Optimization/02_16. Understanding Explain Command.mp4
772 kB
02. Understanding MySQL Query Optimization/02_17. Demo - Explain Command.mp4
12 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 kB
03. Performance Optimization by Practical Query Tuning/03_01. Introduction.mp4
2.3 MB
03. Performance Optimization by Practical Query Tuning/03_02. Demo - Index Used for SELECT clause.mp4
30 MB
03. Performance Optimization by Practical Query Tuning/03_03. Demo - One Complex Query vs Multiple Simple Queries.mp4
14 MB
03. Performance Optimization by Practical Query Tuning/03_04. Demo - One Complex Query vs Multiple Simple Queries - Part 2.mp4
15 MB
03. Performance Optimization by Practical Query Tuning/03_05. Demo - One Complex Query vs Multiple Simple Queries with Index.mp4
21 MB
03. Performance Optimization by Practical Query Tuning/03_06. Demo - Table Order in Join Clause - INNER JOIN.mp4
24 MB
03. Performance Optimization by Practical Query Tuning/03_07. Demo - Table Order in Join Clause - OUTER JOIN.mp4
13 MB
03. Performance Optimization by Practical Query Tuning/03_08. Demo - Most Optimal Choice - Subquery vs Exists vs Joins.mp4
34 MB
03. Performance Optimization by Practical Query Tuning/03_09. Demo - Most Optimal Choice - Subquery vs Exists vs Joins - Part 2.mp4
14 MB
03. Performance Optimization by Practical Query Tuning/03_10. Demo - Tuning Aggregate Function.mp4
17 MB
03. Performance Optimization by Practical Query Tuning/03_11. Demo - Optimizing Group By Clause.mp4
22 MB
03. Performance Optimization by Practical Query Tuning/03_12. Demo - Optimizing Paging with LIMIT Clause.mp4
9.4 MB
03. Performance Optimization by Practical Query Tuning/03_13. Demo - Impact on Performance of UNION and UNION ALL.mp4
13 MB
03. Performance Optimization by Practical Query Tuning/03_14. Demo - Index and Not Equal to Operator.mp4
7.5 MB
03. Performance Optimization by Practical Query Tuning/03_15. Summary in Sixty Seconds.mp4
1.2 MB
04. Best Practices/04_01. Best Practices.mp4
6.9 MB
Exercise_Files/MySQL-Query-Optimization-Performance-Tuning.zip
6.3 MB
Exercise_Files/subtitles_EN.zip
75 kB