Overview

Introduction

The Troubleshooting Queries 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:

  • Manage Transactions
  • Evaluating Row-Based Operations vs. Set Based Operations
  • Implementing Error Handling

Lab time: It will take approximately 30 minutes to complete this lab.

Exercise 1 - Manage Transactions

In this exercise, you will learn the following:

  • Use BEGIN, COMMIT, and ROLLBACK TRANSACTION statements
  • Demonstrate the use of transaction isolation level
  • Demonstrate the use of @@Trancount function

Exercise 2 - Evaluating Row-Based Operations vs. Set Based Operations

In this exercise, you will learn the following:

  • Using a cursor to fetch data row by row
  • Combining multiple DML operations using the Merge statement

Exercise 3 - Implementing Error Handling

In this exercise, you will learn the following using SQL Server 2012:

  • Implementing try/catch and throw exception handling in code
  • Using Begin Tran and Commit Tran for transactional consistency
  • Demonstrating ACID Properties

Comprehensive Learning

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