/transactions-and-error-handling-in-postgresql

This is a repository for the DataCamp course Transactions and Error Handling in PostgreSQL.

Primary LanguagePLpgSQL

Transactions and Error Handling in PostgreSQL

Open in Google Colab

Open in GitHub Codespaces

Clear as Data

This is the repository for the DataCamp course Transactions and Error Handling in PostgreSQL. The full course is available from DataCamp.

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.

Instructor

Jason Myers

Co-Author of Essential SQLAlchemy and Software Engineer