Skip to main content
HomeSQLTransactions and Error Handling in PostgreSQL

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
2,058 LearnersTrophyStatement of Accomplishment

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.
GroupTraining 2 or more people?Try DataCamp For Business

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.
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more
Try DataCamp for BusinessFor a bespoke solution book a demo.
  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
  2. 2

    Rolling Back and Savepoints

    How to rollback when an error is encountered in a transaction block and setting savepoints.

    Play Chapter Now
    Handling mistakes
    50 xp
    Using rollbacks
    100 xp
    Multistatement Rollbacks
    100 xp
    Rolling back to a savepoint
    50 xp
    Working with a single savepoint
    100 xp
    Rolling back with a savepoint
    100 xp
    Multiple savepoints and rollback
    50 xp
    Multiple savepoints
    100 xp
    Savepoints and rolling back
    100 xp
    Understanding outcomes
    100 xp
    Isolation levels, savepoints, and rollbacks
    50 xp
    Working with repeatable read
    100 xp
    Isolation levels comparison
    100 xp
    Savepoint's effect on isolation levels
    100 xp
  3. 3

    Handling Exceptions

    In this chapter, you'll learn about exceptions and how to handle them.

    Play Chapter Now
    Catching exceptions
    50 xp
    Writing do statements
    100 xp
    Using exception handling wisely
    50 xp
    Handling exceptions
    100 xp
    Rollbacks, savepoints, and exceptions
    50 xp
    Multiple exception blocks
    100 xp
    Understanding rollbacks and savepoints
    50 xp
    Specific exception handling and messages
    50 xp
    Capturing specific exceptions
    100 xp
    Logging messages on specific exceptions
    100 xp
    Graceful exception handling
    50 xp
    When to use graceful degradation
    100 xp
    Graceful degradation
    100 xp
  4. 4

    Stacked Diagnostics

    With stacked diagnostics, you can get all the information available from PostgreSQL about an exception.

    Play Chapter Now
    Enhancing exception handling with stacked diagnostics
    50 xp
    Getting stacked diagnostics
    100 xp
    What data is available in stacked diagnostics
    50 xp
    Hints to help handle nested exceptions
    50 xp
    Capturing a context stack
    100 xp
    When to add custom exception logging and recording
    100 xp
    Mixing it all together with debugging functions
    50 xp
    Creating named functions and declaring variables
    100 xp
    Structure of stacked diagnostics function
    100 xp
    Putting it all together
    100 xp
    Wrapping it up
    50 xp

Datasets

FFEIC data

Collaborators

Collaborator's avatar
Amy Peterson

Prerequisites

Data Manipulation in SQL
Jason Myers HeadshotJason 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?

    FAQs

    Join over 13 million learners and start Transactions and Error Handling in PostgreSQL today!

    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.