Pluralsight MySQL Query Optimization and Performance Tuning With Pinal Dave

Pluralsight MySQL Query Optimization and Performance Tuning With Pinal Dave

Name	Pluralsight - MySQL Query Optimization and Performance Tuning With Pinal Dave	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	369.2 MB
Total Files	63
Hash	B2374807B03810E0C8E83B4E4804B6432B163448

/materials/
3-mysql-query-optimization-performance-tuning-m03-slides.pdf	747.3 KB
5-mysql-query-optimization-performance-tuning-m05-best-practices-slides.pdf	118.5 KB
2-mysql-query-optimization-performance-tuning-m02-optimizing-data-access-slides.pdf	127.7 KB
1-mysql-query-optimization-performance-tuning-m01-introduction-slides.pdf	5.9 MB
/01. Introduction/
01. Introduction.wmv	8.3 MB
/05. Best Practices/
01. Best Practices.wmv	13.8 MB
/02. Optimizing Data Access/
04. Understanding Data Needs.wmv	7.3 MB
02. Prerequisite.wmv	3.0 MB
01. Introduction.wmv	3.6 MB
03. Overheard.wmv	4.0 MB
05. Demo Setup.wmv	2.5 MB
07. Demo Why SELECT Star ( ) is Bad Idea.wmv	16.8 MB
06. Demo Best Practices for Data Access.wmv	9.3 MB
08. Summary in Sixty Seconds.wmv	1.6 MB
/03. Understanding MySQL Query Optimization/
15. Demo Show Full Processlist.wmv	8.6 MB
14. Understanding Query States.wmv	7.2 MB
16. Understanding Explain Command.wmv	2.0 MB
19. Summary in Sixty Seconds.wmv	1.8 MB
13. Maximizing Query Optimizer Performance.wmv	2.2 MB
18. Demo Explain Extended Command.wmv	7.7 MB
17. Demo Explain Command.wmv	14.5 MB
10. Query Execution Engine and Storage.wmv	5.4 MB
04. Query Cache.wmv	3.4 MB
12. Additional Notes on Query Optimizer.wmv	3.2 MB
03. Client Protocols.wmv	7.0 MB
02. Execution Path of a Query.wmv	2.2 MB
01. Introduction.wmv	3.3 MB
06. Preprocessor.wmv	2.1 MB
05. Parser.wmv	2.5 MB
07. Query Optimizer.wmv	5.0 MB
09. Query Optimizer Limitations.wmv	8.3 MB
11. Returning Result to Client.wmv	3.2 MB
08. Query Optimizer Responsibilities.wmv	5.2 MB
/04. Performance Optimization by Practical Query Tuning/
12. Demo Optimizing Paging with LIMIT Clause.wmv	11.3 MB
13. Demo Impact on Performance of UNION and UNION ALL.wmv	16.7 MB
15. Summary in Sixty Seconds.wmv	2.4 MB
11. Demo Optimizing Group By Clause.wmv	10.8 MB
14. Demo Index and Not Equal to Operator.wmv	9.6 MB
04. Demo One Complex Query vs Multiple Simple Queries - Part 2.wmv	18.2 MB
01. Introduction.wmv	5.1 MB
03. Demo One Complex Query vs Multiple Simple Queries.wmv	18.0 MB
10. Demo Tuning Aggregate Function.wmv	21.1 MB
05. Demo One Complex Query vs Multiple Simple Queries with Index.wmv	9.9 MB
06. Demo Table Order in Join Clause - INNER JOIN.wmv	10.9 MB
09. Demo Most Optimal Choice - Subquery vs Exists vs Joins - Part 2.wmv	16.4 MB
08. Demo Most Optimal Choice - Subquery vs Exists vs Joins.wmv	17.3 MB
07. Demo Table Order in Join Clause - OUTER JOIN.wmv	15.2 MB
02. Demo Index Used for SELECT clause.wmv	14.5 MB
/.../3-mysql-query-optimization-performance-tuning-m03-exercise-files/demo/before/
1-longquery.sql	0.4 KB
2-showprocesslist.sql	0.0 KB
/.../2-mysql-query-optimization-performance-tuning-m02-optimizing-data-access-exercise-files/before/
1-script.sql	1.8 KB
/.../4-mysql-query-optimization-performance-tuning-m04-performance-optimization-exercise-files/demo/before/
5-Join Order-Outer.sql	1.2 KB
6-Correlated.sql	3.6 KB
8-Min-Max.sql	0.9 KB
4-Join Order.sql	1.2 KB
7-Correlated-2.sql	2.6 KB
09-GroupBy.sql	1.4 KB
10-Limit-Offset.sql	0.3 KB
1-Index.sql	0.6 KB
11-Union-All-Union.sql	2.1 KB
12-NEQ-Index.sql	0.3 KB
2-Joins.sql	1.5 KB
3-MultipleQuery.sql	0.6 KB
Total files 63