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