Handling Errors in T-SQL

Have you experimented with error handling in T-SQL but were left wanting more? Well, this course is for you! Take your skills to the next level by of incorporating error handling into your ad hoc scripts and stored procedures today.
Course info
Rating
(16)
Level
Beginner
Updated
Jul 16, 2019
Duration
2h 45m
Table of contents
Description
Course info
Rating
(16)
Level
Beginner
Updated
Jul 16, 2019
Duration
2h 45m
Description

Perhaps you’re starting out or have been putting off learning error handling for years. Maybe you want to take your understanding of error handling in SQL Server to the next level. In this course, Handling Errors in T-SQL, you will gain the ability to handle exceptions in SQL Server. First, you will learn why handling errors in T-SQL is critical to writing quality code. Along the way, learning why you want to control the outcome of your scripts. Next, you will discover how transactions are woven into the fabric of SQL Server and how to manage them efficiently. Finally, you will explore the most important error handling methods. When you’re finished with this course, you will have the skills and knowledge necessary to consistently handle exceptions in T-SQL.

About the author
About the author

Jared Westover is a Microsoft Certified Solutions Expert in Data Management and Analytics. Data and technology have been paramount to his career for over 13 years. These days he focuses on SQL Server and finding ways to tell inspiring stories with raw data.

More from the author
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Jared Westover. Welcome to my course, Handling Errors in T-SQL. I'm a SQL Architect and a Microsoft Certified Solutions Expert in data management and analytics. Most importantly, I love working with data. During the development phase of an application, error handling can easily become an afterthought, especially when it comes to database objects such as stored procedures. However, knowing how to deal with exceptions when they pop up in SQL Server is critical to being a proficient developer. In this course, we'll examine several error handling methods currently available in SQL Server. Having knowledge of SQL Server and prior experience with writing queries will be helpful as you go through the course. Some of the major topics that we will cover include why handling errors at the database level is important, how and why to control transactions in SQL Server, methods for raising exceptions in T-SQL, several real-world examples of handling errors. By the end of this course, you will have a solid foundation to start optimizing your T-SQL ad hoc scripts and stored procedures to handle exceptions. I hope you'll join me on this journey to learn error handling with the Handling Errors in T-SQL course, at Pluralsight.