Loved by learners at thousands of companies
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.
Getting to Know TransactionsFree
This chapter focuses on learning about single and multistatement transactions and the read committed isolation level.Welcome to Transactions and Error Handling in PostgreSQL50 xpTransaction structure100 xpMaking our first transaction100 xpMultiple statement transactions100 xpTransaction sizes and PostgreSQL protections50 xpUsing and making transactions100 xpSingle statement transactions100 xpIsolation levels50 xpSelecting isolation levels50 xpUsing an isolation level100 xpIsolation levels and transactions100 xp
Rolling Back and Savepoints
How to rollback when an error is encountered in a transaction block and setting savepoints.Handling mistakes50 xpUsing rollbacks100 xpMultistatement Rollbacks100 xpRolling back to a savepoint50 xpWorking with a single savepoint100 xpRolling back with a savepoint100 xpMultiple savepoints and rollback50 xpMultiple savepoints100 xpSavepoints and rolling back100 xpUnderstanding outcomes100 xpIsolation levels, savepoints, and rollbacks50 xpWorking with repeatable read100 xpIsolation levels comparison100 xpSavepoint's effect on isolation levels100 xp
In this chapter, you'll learn about exceptions and how to handle them.Catching exceptions50 xpWriting do statements100 xpUsing exception handling wisely50 xpHandling exceptions100 xpRollbacks, savepoints, and exceptions50 xpMultiple exception blocks100 xpUnderstanding rollbacks and savepoints50 xpSpecific exception handling and messages50 xpCapturing specific exceptions100 xpLogging messages on specific exceptions100 xpGraceful exception handling50 xpWhen to use graceful degradation100 xpGraceful degradation100 xp
With stacked diagnostics, you can get all the information available from PostgreSQL about an exception.Enhancing exception handling with stacked diagnostics50 xpGetting stacked diagnostics100 xpWhat data is available in stacked diagnostics50 xpHints to help handle nested exceptions50 xpCapturing a context stack100 xpWhen to add custom exception logging and recording100 xpMixing it all together with debugging functions50 xpCreating named functions and declaring variables100 xpStructure of stacked diagnostics function100 xpPutting it all together100 xpWrapping it up50 xp
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.