Transactions and Isolation Levels

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

---

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

Expertise Level
Intermediate