Lesson 3 of 8

Protect an operation with transactions

Use COMMIT, ROLLBACK and SAVEPOINT, and understand concurrency.

40 minAdvanced SQL with PostgreSQL

By the end of this lesson

  • Define an atomic operation
  • Recover with SAVEPOINT
  • Recognise a concurrency conflict

SQL Pro

Continue with the right access

“Protect an operation with transactions” is included from SQL Pro.

30 free days of SQL Pro on registration, subject to the 31 remaining places. No card or automatic renewal.

Create my Discovery spaceI already have an account
After signing in, you will return directly to this activity.