• Online, Self-Paced
Course 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.

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 Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.