Additional sample videos, individual lessons and other formats are available here.
Register your product to gain access to bonus material or receive a coupon.
Module 4: Troubleshoot and Optimize
In this module, you will learn how to troubleshoot and optimize queries. We start first with understanding and using SQL Server’s built in objects for optimizing. We will then see how to understand and manage transactions and row-based operations. Finally, we will implement error handling procedures.
Lesson 14: Optimize Queries
In this lesson, you will learn how SQL Server implements and optimizes queries. We will read and analyze query plans, as well as use optimizer hints and plan guides.
Lesson 15: Manage Transactions
In this lesson, you will learn how to apply transaction commands for both implicit and explicit transactions. We will also examine locking protocols and transaction isolation levels.
Lesson 16: Evaluate the Use of Row-Based Operations vs. Set-Based Operations
In this lesson, you will learn how to implement row-based cursor commands. We will examine and compare the affect of using a cursor-based solution versus a set-based solution.
Lesson 17: Implement Error Handling
In this lesson, you will learn methods to catch and redirect errors during query execution. We will examine error handling with TRY and CATCH blocks, using THROW, and implementing XACT_ABORT.