Course details

Data Rollbacks: Transaction Rollbacks & Their Impact

Data Rollbacks: Transaction Rollbacks & Their Impact


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Explore the concepts of transactions, transaction management policies, and rollbacks. Discover how to implement transaction management and rollbacks using SQL Server.



Expected Duration (hours)
0.6

Lesson Objectives

Data Rollbacks: Transaction Rollbacks & Their Impact

  • describe the concept and characteristics of rollback process and its impact on transactions
  • recognize the various states of transactions
  • list the prominent types of transactions along with their essential features (distributed and compensating transactions)
  • implement SQL transaction management with commit, savepoint, and release savepoint
  • recall the various transaction log operations and their characteristics (transaction recovery and transaction replication)
  • recognize the deadlock management capabilities and features provided by SQL Server using Lock Monitor and Trace
  • list SQL Server rollback mechanisms
  • use SQL Server to rollback databases to a specific point in time
  • implement transaction management and rollbacks using SQL Server
  • Course Number:
    it_dsdrlldj_01_enus

    Expertise Level
    Intermediate