课程

Transactions and Error Handling in SQL Server

中级技能水平

更新时间 2025年1月

Learn to write scripts that will catch and handle errors and control for multiple operations happening at once.

免费开始课程

SQLProgramming4 小时14 视频52 练习3,850 经验值15,986成就声明

创建您的免费帐户

或

继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。

深受数千家公司学习者的喜爱

培训2人或更多？

试用DataCamp for Business

课程描述

It is critical to know how to handle errors and manage transactions when programming SQL scripts. Unhandled errors can be very harmful and can cause unexpected situations, such as inconsistent data in your database, or even worse, errors can lead you to make wrong business decisions. In this course, you will learn how to handle errors and discover how to manage transactions in case of an error. Additionally, you will study what happens when two or more people interact at the same time with the same data. You will practice all these concepts using two datasets, one of them based on bank accounts and the other one on an electric bike store.

先决条件

Intermediate SQL Server

1

Starting with error handling

To begin the course, you will learn how to handle errors using the TRY...CATCH construct that provides T-SQL. You will study the anatomy of errors, and you will learn how to use some functions that can give you information about errors.

50 经验值

The TRY...CATCH syntax

50 经验值

Your first error-handling script

100 经验值

Nesting TRY...CATCH constructs

100 经验值

Error anatomy and uncatchable errors

50 经验值

Anatomy review

50 经验值

Correcting compilation errors

100 经验值

Giving information about errors

50 经验值

Error function syntax

50 经验值

Using error functions

100 经验值

Using error functions in a nested TRY...CATCH

100 经验值

2

Raising, throwing and customizing your errors

In this chapter, you will deepen your knowledge of handling errors. You will learn how to raise errors using RAISERROR and THROW. Additionally, you will discover how to customize errors.

50 经验值

RAISERROR syntax

50 经验值

CATCHING the RAISERROR

100 经验值

50 经验值

THROW with or without parameters

50 经验值

THROW without parameters

100 经验值

Executing a stored procedure that throws an error

100 经验值

THROW with parameters

100 经验值

Customizing error messages in the THROW statement

50 经验值

Ways of customizing error messages

50 经验值

Concatenating the message

100 经验值

FORMATMESSAGE with message string

100 经验值

FORMATMESSAGE with message number

100 经验值

3

Transactions in SQL Server

In this chapter, you will be introduced to the concept of transactions. You will discover how to commit and rollback them. You will finish by learning how to return the number of transactions and their state.

Transactions

50 经验值

Transaction statements

50 经验值

Correcting a transaction

100 经验值

Rolling back a transaction if there is an error

100 经验值

Choosing when to commit or rollback a transaction

100 经验值

@@TRANCOUNT and savepoints

50 经验值

Modifiers of the @@TRANCOUNT value

50 经验值

Checking @@TRANCOUNT in a TRY...CATCH construct

100 经验值

Using savepoints

100 经验值

XACT_ABORT & XACT_STATE

50 经验值

XACT_ABORT behavior

50 经验值

XACT_ABORT and THROW

100 经验值

Doomed transactions

100 经验值

4

Controlling the concurrency: Transaction isolation levels

This chapter defines what concurrency is and how it can affect transactions. You will learn exciting concepts like dirty reads, repeatable reads, and phantom reads. To avoid or allow this reads, you will explore, one by one, the different transaction isolation levels.

Transaction isolation levels

50 经验值

Concurrency phenomena

50 经验值

Using the READ UNCOMMITTED isolation level

100 经验值

READ COMMITTED & REPEATABLE READ

50 经验值

Choosing the correct isolation level

50 经验值

Prevent dirty reads

100 经验值

Preventing non-repeatable reads

100 经验值

SERIALIZABLE isolation level

50 经验值

Prevent phantom reads in a table

100 经验值

Prevent phantom reads just in some rows

100 经验值

50 经验值

Setting READ COMMITTED SNAPSHOT to ON

50 经验值

Comparing WITH (NOLOCK) & READ UNCOMMITTED

50 经验值

Avoid being blocked

100 经验值

Congratulations!

50 经验值

Transactions and Error Handling in SQL Server

课程完成

获得成就证明

将此证书添加到你的 LinkedIn 档案、简历或履历中
在社交媒体和绩效评估中分享立即注册

加入超过19百万学习者，今天就开始Transactions and Error Handling in SQL Server！

创建您的免费帐户

或

继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。

通过 DataCamp for Mobile 提升您的数据技能

随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。