After doing these courses, I feel confident creating professional visualizations and dashboards
Shoebur RahmanProcurement Specialist, Giz Bangladesh
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.
Prerequisites
Curriculum
Course outline
1
Getting to Know Transactions
This chapter focuses on learning about single and multistatement transactions and the read committed isolation level.
- Welcome to Transactions and Error Handling in PostgreSQL50 XP
- Transaction structure100 XP
- Making our first transaction100 XP
- Multiple statement transactions100 XP
- Transaction sizes and PostgreSQL protections50 XP
- Using and making transactions100 XP
- Single statement transactions100 XP
- Isolation levels50 XP
- Selecting isolation levels50 XP
- Using an isolation level100 XP
- Isolation levels and transactions100 XP
2
Rolling Back and Savepoints
How to rollback when an error is encountered in a transaction block and setting savepoints.
3
Handling Exceptions
In this chapter, you'll learn about exceptions and how to handle them.
4
Stacked Diagnostics
With stacked diagnostics, you can get all the information available from PostgreSQL about an exception.
S
Transactions and Error Handling in PostgreSQL
Course
Complete
