2013
Pluralsight
Pinal Dave
1h 50m
English

Performance is one of the most essential aspects of any application. Everyone wants their server to perform optimally and at the best efficiency. In this course we will understand the basics of query optimization and look at practical tips and tricks for performance tuning.
01. Introduction
01. Introduction.wmv

02. Optimizing Data Access
01. Introduction.wmv
02. Prerequisite.wmv
03. Overheard.wmv
04. Understanding Data Needs.wmv
05. Demo Setup.wmv
06. Demo Best Practices for Data Access.wmv
07. Demo Why SELECT Star ( ) is Bad Idea.wmv
08. Summary in Sixty Seconds.wmv

03. Understanding MySQL Query Optimization
01. Introduction.wmv
02. Execution Path of a Query.wmv
03. Client Protocols.wmv
04. Query Cache.wmv
05. Parser.wmv
06. Preprocessor.wmv
07. Query Optimizer.wmv
08. Query Optimizer Responsibilities.wmv
09. Query Optimizer Limitations.wmv
10. Query Execution Engine and Storage.wmv
11. Returning Result to Client.wmv
12. Additional Notes on Query Optimizer.wmv
13. Maximizing Query Optimizer Performance.wmv
14. Understanding Query States.wmv
15. Demo Show Full Processlist.wmv
16. Understanding Explain Command.wmv
17. Demo Explain Command.wmv
18. Demo Explain Extended Command.wmv
19. Summary in Sixty Seconds.wmv

04. Performance Optimization by Practical Query Tuning
01. Introduction.wmv
02. Demo Index Used for SELECT clause.wmv
03. Demo One Complex Query vs Multiple Simple Queries.wmv
04. Demo One Complex Query vs Multiple Simple Queries - Part 2.wmv
05. Demo One Complex Query vs Multiple Simple Queries with Index.wmv
06. Demo Table Order in Join Clause - INNER JOIN.wmv
07. Demo Table Order in Join Clause - OUTER JOIN.wmv
08. Demo Most Optimal Choice - Subquery vs Exists vs Joins.wmv
09. Demo Most Optimal Choice - Subquery vs Exists vs Joins - Part 2.wmv
10. Demo Tuning Aggregate Function.wmv
11. Demo Optimizing Group By Clause.wmv
12. Demo Optimizing Paging with LIMIT Clause.wmv
13. Demo Impact on Performance of UNION and UNION ALL.wmv
14. Demo Index and Not Equal to Operator.wmv
15. Summary in Sixty Seconds.wmv

05. Best Practices
01. Best Practices.wmv

http://pluralsight.com/

Download File Size:287.18 MB

---