Transactions and Error Handling in SQL Server

DataCamp

(3)

Course Features

Duration

4 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

Video Content

4 hours

Course Description

Programming SQL scripts requires the ability to handle errors and transactions. Unhandled errors can be very dangerous and cause unexpected situations, such as inconsistency or other problems that could lead to bad business decisions.

This course will help you deal with errors and manage transactions in the case of an error. It will also show you what happens when multiple users interact with the same data. These concepts will be tested using two datasets. The first is based upon bank accounts and the second on an electric bike store.

Course Overview

Virtual Labs

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Intermediate SQL Server

What You Will Learn

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

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

Course Content

Expand all sections

Module 1: Starting with error handling

Module 2: Raising, throwing and customizing your errors

Module 3: Transactions in SQL Server

Module 4: Controlling the concurrency: Transaction isolation levels

Course Instructors

Miriam Antona

Software Engineer

Miriam Antona has 10+ years of experience working as a Software Engineer. She is focused on analyzing, designing, and developing software applications for the Justice Administration. Miriam loves pro...

Course Reviews

Average Rating Based on 3 reviews

5.0

100%