Course Details

Previous Page


Transactions and Isolation Levels


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
SQL Server transactions allow you to group together a number of statements to form a single logical unit of work. This course covers the various types of transactions, and explains how to implement them in SQL Server 2016. This course also covers isolation levels, a SQL Server 2016 feature that helps control the way locking works between transactions. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.

Target Audience
Database professionals responsible for implementing and maintaining SQL Server 2016

Prerequisites
None

Expected Duration (hours)
1.7

Lesson Objectives

Transactions and Isolation Levels

  • start the course
  • recognize when to use transactions
  • demonstrate how to use the BEGIN TRANSACTION statement
  • use the COMMIT TRANSACTION to mark the end of a successful implicit or explicit transaction
  • use the COMMIT WORK statement to mark the end of a transaction
  • use the ROLLBACK TRANSACTION to roll back an explicit or implicit transaction
  • use the ROLLBACK WORK statement to roll back a user-specified transaction
  • use the SAVE TRANSACTION statement to set a savepoint within a transaction
  • identify DML statement results based on transaction behavior
  • determine the role of transactions in high-concurrency SQL Server 2016 databases
  • describe explicit transactions
  • describe implicit transactions
  • describe snapshot isolation and row versioning
  • use the READ UNCOMMITTED isolation level
  • use the READ COMMITTED isolation level
  • use the REPEATABLE READ isolation level
  • use the SERIALIZED isolation level
  • use the SNAPSHOT isolation level
  • define the results of concurrent queries based on isolation levels
  • describe performance impact considerations of given isolation levels
  • demonstrate how to administer transactions
  • Course Number:
    df_sqld_a06_it_enus