The business problem
A price history must be kept whenever a change occurs, regardless of the calling process.
What you will be able to do
Create and test an audit trigger with OLD, NEW, BEFORE, AFTER, ROW and STATEMENT.
- Write a trigger function
- Choose BEFORE or AFTER
- Prevent recursion
- Know when not to use a trigger
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
- Constraints
- INSERT, UPDATE, DELETE
- Transactions
Project and practice
The planned structure contains 10 exercises and a mini-project. They will remain unavailable until they have been run and validated.