The business problem
Negative prices, duplicate emails and orphaned orders make reports unreliable.
What you will be able to do
Choose and write the right constraint for a simple business rule.
- Use NOT NULL, UNIQUE and CHECK
- Connect two tables with a foreign key
- Choose a constraint instead of 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
- Tables, columns and primary keys
Project and practice
The planned structure contains 8 exercises and a mini-project. They will remain unavailable until they have been run and validated.