Normalisation, one fact in one place
Spot repeated data and the bugs it causes, then split a flat spreadsheet-style table into customers, products, orders and order lines with INSERT ... SELECT.
- The skill
- Spot repeated facts and split a flat table so each fact lives in one place.
- You make
- A shop's spreadsheet export rebuilt as four linked tables, then a playlist export split on your own.
Premium lesson
£7.99 a month or £59 a year. Cancel any time.
Builds on 27 Designing tables with CREATE TABLE. Free to try: SQL Foundations and the playground.
Passed
You can now
Step 1 of 8
exercise_1.sql
You've reached the good stuff.
5 exercises in this lesson, checked as you type. Premium opens every lesson after Foundations, in all four courses.
SQLite