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

What Every Developer Should Know About SQL Server Performance

Course Summary

This course is designed to teach developers the fundamentals of SQL Server performance, showing you the tools you will need to troubleshoot and resolve SQL Server performance problems.


  • +

    Course Syllabus

    Getting Started
    - 19m 47s

    —Course Introduction 3m 1s
    —Why Application Developers Should Understand SQL Performance 1m 44s
    —What You Will Learn 2m 3s
    —What Tools You Need 2m 26s
    —Installing the Sample Database 1m 59s
    —Table Concepts 4m 22s
    —Index Concepts 2m 57s
    —Summary 1m 12s
    Analyzing SQL Statements for Performance
    - 37m 5s

    —Introduction 2m 10s
    —Understanding How SQL Server Will Execute a SQL Statement 3m 20s
    —Reading and Interpreting an Execution Plan for a SQL Statement 8m 43s
    —Getting Execution Statistics for a SQL Statement 4m 18s
    —Improving Statement Performance by Adding an Index 4m 28s
    —Before and After Performance Comparison 1m 23s
    —Rewriting SQL Statements for Improved Performance 5m 6s
    —Common Execution Plan Operations 4m 32s
    —Summary 3m 1s
    Building Effective Indexes
    - 47m 13s
    Finding Performance Bottlenecks in SQL Server
    - 26m 21s
    Capturing What Your Application is Doing Inside SQL Server
    - 49m 43s
    Applying Common Performance Practices
    - 21m 37s


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under 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