SQL 2014 Developer, Part 4 of 13: Transactions

In this course you’ll learn about transaction concepts and the ACID test that SQL Server uses to protect the integrity of data. You’ll also learn about locking and blocking, and how to avoid these inevitable effects of heavily used relational databases. You’ll see how to use transactions in applications, as well as how to handle compile and run time errors caused by your code. Then you’ll learn about how to take control of transactions and defined them explicitly in your code. Then we’ll wrap with a look at a relatively new feature of T-SQL, structured exception handling that has long been a feature of general purpose programming languages.

Lesson 1:

• Passing the ACID Test
• Transactions Types
• Transaction Details
• Isolation Levels
• Locking
• Viewing Lock Information
• Avoiding Blocked Transactions
• Demo: Blocking
• Demo: Read Uncommitted
• Working Around DeadLocks
• Deadlocks
• Preventing Deadlocks.

Lesson 2:

• Designing Transaction Support
• Efficiency Guidelines
• Compile and Runtime Errors
• Demo: Compiler Errors
• Demo: Runtime Errors
• Demo:Invalid Object Name Error.

Lesson 3:

• Explicit Transaction Syntax
• Nested Transactions
• Demo: @@TRANCOUNT
• Error Handling
• Using @@ERROR
• Demo: Error Handling
• Manage with Stored Procedures
• Demo: Proactive Checks
• Demo:Errors In Transaction
• Demo: Testing Stored Procedure
• Using RAISERROR
• Demo: Using RAISERROR
• Demo: User-Defined RAISERROR.

Lesson 4:

• TRY/CATCH Overview
• Demo: TRY/CATCH
• Error Chaining
• Errors Not Handled
• Error Handling Functions
• Demo: Error Handling Functions
• Using RAISERROR With TRY/CATCH
• Demo: RAISERROR With TRY/CATCH
• The THROW Statement
• Demo: Using THROW Statement
• Demo: Within Stored Procedure
• Uncommittable Transactions
• XACT_STATE Function
• Demo: XACT_STATE.