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 Indexing for Performance

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. Indexes are the silver bullets for Performance. In this course we will gain an understanding of the basics of

  • +

    Course Syllabus

    ● MySQL Indexing for Performance
        ◦ Introduction
    ● Types of Indexes
        ◦ Introduction
        ◦ InnoDB vs MyISAM
        ◦ B-Tree Index
        ◦ Advantages of B-Tree Index
        ◦ Clustered Index
        ◦ Advantages of Clustered Index
        ◦ Disadvantages of Clustered Index
        ◦ Secondary Index
        ◦ Building Clustered B-Tree
        ◦ Building Secondary Index B-Tree
        ◦ InnoDB Clustered Table
        ◦ Hash Index
        ◦ Limitation of Hash Index
        ◦ Adaptive Hash Index
        ◦ Building Hash Index
        ◦ Other Indexes
        ◦ Summary in Sixty Seconds
    ● Indexing Strategies for High Performance
        ◦ Introduction
        ◦ Effectiveness of Index
        ◦ Demo: List Indexes
        ◦ Demo: Basics of Indexes
        ◦ Demo: Order of Columns in Index
        ◦ Demo: Optimize OR Conditions
        ◦ Demo: Optimize OR Conditions - Advanced
        ◦ Demo: Optimize AND Conditions
        ◦ Demo: Optimize AND Conditions - Advanced
        ◦ Demo: Cover Index
        ◦ Demo: Clustered Index
        ◦ Demo: Index Hints
        ◦ Summary in Sixty Seconds
    ● Index Maintenance
        ◦ Introduction
        ◦ MySQL Query Optimizer
        ◦ Statistics
        ◦ InnoDB Statistics
        ◦ Data and Index Fragmentation
        ◦ Index Maintenance
        ◦ Other Index Maintenance Tips
        ◦ Summary in Sixty Seconds
    ● Checklists
        ◦ Checklists


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Open Source , Development & Implementations and Data & Information Management Community

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
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