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: Introduction to Query Tuning

Course Summary

SQL Server performance tuning is an art to master - for developers and DBAs alike. This course takes a systematic approach to planning, analyzing, debugging and troubleshooting common query-related performance problems. This includes an introduction to understanding execution plans inside SQL Server.


  • +

    Course Syllabus

    Introduction
    - 10m 22s

    —Introduction 2m 58s
    —Query Tuning 2m 38s
    —Demo 4m 46s
    Execution Plan Basics
    - 45m 59s

    —Introduction 4m 1s
    —Demo 5m 58s
    —Various Execution Plan Types 3m 4s
    —Demo: Execution Plan Types 5m 24s
    —Clustered Index 4m 23s
    —Demo: Clustered Index 4m 8s
    —Non-clustered Index 1m 42s
    —Demo: Non-clustered Index 3m 50s
    —Key Lookup 0m 48s
    —Demo: Key Lookup 3m 19s
    —Index Seek vs Index Scan 1m 42s
    —Types of Joins 1m 54s
    —Demo: Types of Joins 4m 33s
    —Summary 1m 13s
    Essential Indexing Techniques
    - 20m 19s
    Query Design for Performance
    - 50m 16s
    Performance Tuning Tools
    - 1h 15m
    Tips and Tricks
    - 25m 53s
    Checklist: Performance Tuning
    - 7m 13s


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

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

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