Overview

Introduction

The Design the Locking Granularity Level module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

  1. Implement Transactions and Isolation Levels

Exercise 1 - Implement Transactions and Isolation Levels

In this exercise, you will learn the following in Microsoft SQL Server 2012 R2:

  • Implement transactions to handle or avoid deadlocks
  • Demonstrate different transaction isolation levels to prevent concurrency issues

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.