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: Deadlock Analysis and Prevention

Course Summary

Learn how to analyze and prevent troublesome deadlocks that can occur in SQL Server, applicable for developers, DBAs, and anyone who uses SQL Server from SQL Server 2005 onwards

  • +

    Course Syllabus

    - 6m 58s

    —Introduction 1m 50s
    —Misconceptions 2m 52s
    —Course Structure 2m 16s
    Locking Overview
    - 23m 21s

    —Introduction 2m 24s
    —Terminology 1m 43s
    —Lock Granularity 2m 48s
    —Lock Hierarchy 0m 56s
    —Shared and Update Locks 2m 34s
    —Exclusive and Intent Locks 2m 50s
    —Schema and Key-Range Locks 2m 19s
    —Lock Compatibility 2m 7s
    —Isolation Levels and Locking Hints 1m 52s
    —Lock Escalation 2m 6s
    —Summary 1m 42s
    Deadlock Detection
    - 11m 50s
    Collecting Deadlock Information
    - 25m 22s
    Deadlock Analysis
    - 20m 21s
    Example Deadlock Scenarios
    - 51m 56s
    Handling Deadlocks
    - 18m 17s

Course Fee:
USD 29

Course Type:


Course Status:



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
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