Free course · Programming
Database Design
Tables that will still make sense after 100,000 rows.
5lessons
10quiz questions
5exercises
What you'll be able to do
- Lay out data so it stays correct.
- Store each fact once.
- Put the rules where they cannot be bypassed.
- Make queries fast without making writes slow.
- Evolve a schema without losing data.
Course content
- 1 Tables, keys and relationships Lay out data so it stays correct.
- 2 Normalisation, in plain terms Store each fact once. Sign in to open
- 3 Constraints, or letting the database say no Put the rules where they cannot be bypassed. Sign in to open
- 4 Indexes and the cost of speed Make queries fast without making writes slow. Sign in to open
- 5 Changing a database that is already live Evolve a schema without losing data. Sign in to open