SQL: Transactions, COMMIT and ROLLBACK

Wishlist Share

About Course

Learn how database transactions keep data consistent when several changes must succeed or fail together. Covers BEGIN, COMMIT and ROLLBACK, savepoints, the ACID properties, autocommit behaviour and an introduction to isolation levels, with PostgreSQL as the worked example.

Tutwoo is an independent learning provider. This course is general training based on official database documentation. It is not produced or endorsed by any database vendor and is not an accredited qualification.

© 2026 Tutwoo UK Limited. This course was created in-house by Tutwoo and is our original work. It is for your own learning only: please do not copy, share, record or resell it.

What Will You Learn?

  • Group related changes so they all succeed or all fail
  • Use BEGIN, COMMIT, ROLLBACK and SAVEPOINT correctly
  • Explain the ACID properties in plain English
  • Recognise dirty, non-repeatable and phantom reads and how isolation levels prevent them

Course Content

Course Lessons

  • Why transactions matter: all or nothing
  • Safer data changes: checking before you commit and using savepoints
  • Concurrency and isolation levels

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕