Transactions and Isolation Levels from Skillsoft

Online, Self-Paced

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.

Learning Objectives

Transaction Statements

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

Isolation Levels

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

Practice: Administering Transactions

demonstrate how to administer transactions

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):