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

SQL Server Performance: Indexing Basics

Course Summary

Indexes are the most crucial objects of the database. They are the first stop for any DBA and Developer when it is about performance tuning. There is good side as well evil side of the indexes. To master the art of performance tuning one has to understand

  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
    ● Fundamentals of Indexing
        ◦ Introduction
        ◦ Index Fundamentals
        ◦ Index Fundamentals - Visual Representation
        ◦ Demo
        ◦ Additional Information
        ◦ Summary
    ● Practical Indexing Implementation Techniques
        ◦ Introduction
        ◦ Primary Key
        ◦ Demo: Primary Key
        ◦ Over Indexing
        ◦ Demo: Over Indexing
        ◦ Duplicate Index
        ◦ Demo: Duplicate Index
        ◦ Clustered Index
        ◦ Demo: Clustered Index
        ◦ Unique Index
        ◦ Demo: Unique Index
        ◦ Included Columns
        ◦ Demo: Included Columns
        ◦ Filtered Index
        ◦ Demo: Filtered Index
        ◦ Disabled Index
        ◦ Demo: Disabled Index
        ◦ Summary
    ● Index Maintenance
        ◦ Introduction
        ◦ Demo: Index Maintenance
        ◦ Defragmentation
        ◦ Demo: Defragmentation
        ◦ Additional Information
        ◦ Summary
    ● Introduction to Columnstore Index
        ◦ Introduction
        ◦ Concepts
        ◦ Demo
        ◦ Additional Information
        ◦ Summary
    ● Indexing Practical Performance Tips and Tricks
        ◦ Index and Page Types
        ◦ Index and Non Deterministic Columns
        ◦ Index and SET Values
        ◦ Importance of Clustered Index
        ◦ Effect of Compression and Fillfactor
        ◦ Index and Functions
        ◦ Dynamic Management Views (DMV) - Fillfactor
        ◦ Table Scan, Index Scan and Index Seek
        ◦ Index and Order of Columns
    ● Checklist: Index and Performance
        ◦ Final Checklist


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

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

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