Designing tables with CREATE TABLE
Design tables with CREATE TABLE: types, keys, NOT NULL, UNIQUE, DEFAULT, CHECK and foreign keys, then change them later with ALTER TABLE.
- The skill
- Design tables with keys and rules that keep bad data out.
- You make
- Tables for players, school clubs and football match results, and changes to tables that already hold data.
Premium lesson
£7.99 a month or £59 a year. Cancel any time.
Builds on 26 Transactions, all or nothing. Free to try: SQL Foundations and the playground.
Passed
You can now
Step 1 of 12
exercise_1.sql
You've reached the good stuff.
9 exercises in this lesson, checked as you type. Premium opens every lesson after Foundations, in all four courses.
SQLite