The business problem
Duplicates, missing values and orphaned relationships are discovered too late in reporting.
What you will be able to do
Write a suite of checks and produce an actionable anomaly report.
- Measure completeness and uniqueness
- Detect orphaned records
- Document a rule
- Prioritise a correction
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
- Filters, aggregations and joins
Project and practice
The planned structure contains 9 exercises and a mini-project. They will remain unavailable until they have been run and validated.