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
About the author
I have over 12+ years of experience building global products being used by millions of users across the globe. I love technology and teaching it. Currently, I am heading Product at one of the fast-paced startups in India and enjoying every moment of it. Prior to this, I built out a couple of startups that had over half a million users across the globe, raised funding from Google + other investors, and was part of Google Launchpad Accelerator. I have experience in building products from scratch ... more