Error Handling in SQL Server
This course will teach you how to deal with and manage errors effectively.
What you'll learn
Errors are unavoidable: what’s important is how you deal with them. The good news is that with the TRY CATCH construct in SQL Server, you have the power to manage errors effectively. In this course, Error Handling in SQL Server, you’ll gain the ability to work with and manage errors in SQL Server databases. First, you’ll explore what errors are and why we should handle them. Next, you’ll discover how you can make use of TRY CATCH block to gracefully handle errors and interpret error messages to pinpoint issues quickly. Finally, you’ll learn how to write robust SQL Server code. When you’re finished with this course, you’ll have the skills and knowledge needed to ensure the reliability and stability of your database applications.
Table of contents
- Understanding Errors in SQL Server 4m
- Demo: Syntax and Runtime Errors in Action 3m
- Errors and the Need to Handle Them 2m
- Setting up Work Environment 3m
- Introduction to TRY CATCH 1m
- Demo: TRY CATCH Hands-on 4m
- Control Flow with TRY CATCH 7m
- TRY CATCH in T-SQL 4m
- Anatomy of Errors and Working with Error Handling Functions 4m
- Demo: Error Handling Functions 1m
- Common Error Scenario and Tips to Handle Them 3m