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: Logging, Recovery, and the Transaction Log

Course Summary

Learn everything there is to know about how logging, recovery, and the transaction log work so you can avoid and recover from transaction log problems, applicable for anyone responsible for SQL Server, from SQL Server 2005 onwards


  • +

    Course Syllabus

    Introduction
    - 7m 39s

    —Introduction 2m 18s
    —Problems From Misconceptions 3m 17s
    —Course Structure 2m 2s
    Understanding Logging
    - 26m 21s

    —Introduction 0m 51s
    —Basic Terminology 2m 53s
    —Why is Logging Required? 2m 24s
    —Where are Logging and Recovery Used? 3m 21s
    —Where are Logging and Recovery Used? (2) 1m 52s
    —Write-Ahead Logging 2m 23s
    —Example Data Modification 1m 15s
    —First Steps: Reading and Initial Locking 2m 2s
    —What It Looks Like: Initial Locking 1m 12s
    —Next Steps: Changing and Logging 1m 6s
    —What It Looks Like: Modifications 0m 58s
    —Next Steps: Committing the Changes 1m 48s
    —What It Looks Like: Committing 0m 52s
    —The Transaction Has Committed - Now What? 1m 28s
    —Summary 1m 49s
    Transaction Log Architecture
    - 26m 48s
    Log Records
    - 1h 9m
    Checkpoints
    - 38m 16s
    Transaction Log Operations
    - 1h 24m
    Recovery and Crash Recovery
    - 44m 10s
    Recovery Models and Minimal Logging
    - 36m 35s
    Transaction Log Provisioning and Management
    - 40m 35s
    Transaction Log Backups
    - 48m 46s
    Corruption and Other HA/DR Topics
    - 42m 43s


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

Back to Top