MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

MySQL Query Optimization and Performance Tuning

Course Summary

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


  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
    ● Optimizing Data Access
        ◦ Introduction
        ◦ Prerequisite
        ◦ Overheard
        ◦ Understanding Data Needs
        ◦ Demo: Setup
        ◦ Demo: Best Practices for Data Access
        ◦ Demo: Why SELECT Star (*) is Bad Idea
        ◦ Summary in Sixty Seconds
    ● Understanding MySQL Query Optimization
        ◦ Introduction
        ◦ Execution Path of a Query
        ◦ Client Protocols
        ◦ Query Cache
        ◦ Parser
        ◦ Preprocessor
        ◦ Query Optimizer
        ◦ Query Optimizer Responsibilities
        ◦ Query Optimizer Limitations
        ◦ Query Execution Engine and Storage
        ◦ Returning Result to Client
        ◦ Additional Notes on Query Optimizer
        ◦ Maximizing Query Optimizer Performance
        ◦ Understanding Query States
        ◦ Demo: Show Full Processlist
        ◦ Understanding Explain Command
        ◦ Demo: Explain Command
        ◦ Demo: Explain Extended Command
        ◦ Summary in Sixty Seconds
    ● Performance Optimization by Practical Query Tuning
        ◦ Introduction
        ◦ Demo: Index Used for SELECT clause
        ◦ Demo: One Complex Query vs Multiple Simple Queries
        ◦ Demo: One Complex Query vs Multiple Simple Queries - Part 2
        ◦ Demo: One Complex Query vs Multiple Simple Queries with Index
        ◦ Demo: Table Order in Join Clause - INNER JOIN
        ◦ Demo: Table Order in Join Clause - OUTER JOIN
        ◦ Demo: Most Optimal Choice - Subquery vs Exists vs Joins
        ◦ Demo: Most Optimal Choice - Subquery vs Exists vs Joins - Part 2
        ◦ Demo: Tuning Aggregate Function
        ◦ Demo: Optimizing Group By Clause
        ◦ Demo: Optimizing Paging with LIMIT Clause
        ◦ Demo: Impact on Performance of UNION and UNION ALL
        ◦ Demo: Index and Not Equal to Operator
        ◦ Summary in Sixty Seconds
    ● Best Practices
        ◦ Best Practices

     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Open Source , Data & Information Management and IT Security & Architecture Community

Related Posts:

MySQL

 

Security, Trust and Assurance Registry (STAR)

 

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top