The business problem
An order is recorded but its payment fails, leaving an incomplete state.
What you will be able to do
Use COMMIT, ROLLBACK and SAVEPOINT while understanding errors and concurrency.
- Define a transaction boundary
- Undo an operation
- Use a savepoint
- Understand isolation
What this micro-course does not promise yet
The content, exercises and laboratory are not accessible yet. This page describes a production goal, not a skill you can already practise on SQL.tn.
Prerequisites
- INSERT, UPDATE and DELETE
Project and practice
The planned structure contains 8 exercises and a mini-project. They will remain unavailable until they have been run and validated.