EasyEnv
Engineering/Courses/Catalog/PostgreSQL/Transactions and Isolation
PostgreSQL
IntermediateLesson 9 of 1435 min · hands-on

Transactions and Isolation

Part of the PostgreSQL course

Two UPDATE statements move money from Alice to Bob. The first one runs, the connection drops, the second one never happens, and thirty pounds have simply ceased to exist. Nothing was buggy about either statement; the problem is that they were two separate events when they needed to be one.

Open the terminal, give this lesson a fresh database of its own, and connect to it as postgres (lesson 02 explains the sudo -u postgres) ...

Want to learn PostgreSQL Transactions and Isolation in a real environment?

Click below, get a fresh Linux box with PostgreSQL ready to go, and work through Transactions and Isolation hands-on with an AI tutor that knows your code.

Start this lessonTransactions and Isolation

What you'll learn

  • BEGIN COMMIT ROLLBACK
  • Savepoints
  • READ COMMITTED default
  • REPEATABLE READ
  • SERIALIZABLE
  • Dirty read non-repeatable read phantom read serialization anomaly

Read this lesson in your language

All lessons in this course

14 lessons
  1. 1What is PostgreSQL20 min
  2. 2psql and First Commands25 min
  3. 3Creating Databases and Tables30 min
  4. 4Data Types25 min
  5. 5SELECT and WHERE30 min
  6. 6Joins35 min
  7. 7Aggregates and Grouping30 min
  8. 8Indexes35 min
  9. 9Transactions and Isolation35 min
  10. 10Functions and Triggers35 min
  11. 11JSONB and Arrays35 min
  12. 12EXPLAIN and Query Tuning35 min
  13. 13Backup and Restore25 min
  14. 14Capstone: Design a Schema60 min

Explore other courses

Transactions and Isolation - PostgreSQL (English) | Engineering Courses