Skip to main content

Transactions and Error Handling in PostgreSQL

Ensure data consistency by learning how to use transactions and handle errors in concurrent environments.

Start Course for Free
4 Hours15 Videos49 Exercises
3950 XP

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA. You confirm you are at least 16 years old (13 if you are an authorized Classrooms user).

Loved by learners at thousands of companies


Course Description

Being able to leverage transactions and find and handle errors is critical to building resilient SQL scripts and working with databases. Transactions provide the protection needed to ensure that your data is consistent and operations work on the desired data in concurrent environments. Improper error handling can cause many serious and unexpected issues. Without the proper use of transactions and error handling, it's possible to make decisions based on incorrect data leading to false outcomes. In this course, we'll cover proper ways to use transactions and handle errors with a record of what went wrong. Additionally, we discuss how concurrently plays into the use of transactions and data outcomes. We'll practice these concepts on the FFEIC bank health data and with a patient data table.

  1. 1

    Getting to know transactions

    Free

    This chapter focuses on learning about single and multistatement transactions and the read committed isolation level.

    Play Chapter Now
    Welcome to Transactions and Error Handling in PostgreSQL
    50 xp
    Transaction structure
    100 xp
    Making our first transaction
    100 xp
    Multiple statement transactions
    100 xp
    Transaction sizes and PostgreSQL protections
    50 xp
    Using and making transactions
    100 xp
    Single statement transactions
    100 xp
    Isolation levels
    50 xp
    Selecting isolation levels
    50 xp
    Using an isolation level
    100 xp
    Isolation levels and transactions
    100 xp

Datasets

FFEIC data

Collaborators

Amy Peterson

Prerequisites

Intermediate SQL
Jason Myers Headshot

Jason Myers

Co-Author of Essential SQLAlchemy and Software Engineer

Jason Myers is a software engineer and author. His area of expertise is in developing data analytics platforms. He has also written the Essential SQLAlchemy book, co-authored with Rick Copeland, that introduces you to working with relational databases in Python.
See More

What do other learners have to say?

I've used other sites—Coursera, Udacity, things like that—but DataCamp's been the one that I've stuck with.

Devon Edwards Joseph
Lloyds Banking Group

DataCamp is the top resource I recommend for learning data science.

Louis Maiden
Harvard Business School

DataCamp is by far my favorite website to learn from.

Ronald Bowers
Decision Science Analytics, USAA