Free course · Programming
Database Design
Tables that will still make sense after 100,000 rows.
- 5 lessons
- about 10 minutes (estimate)
- Taught by Ali
- Free
- Exercises in اردو
- 10 quiz questions
- 5 exercises
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