Databases · From your first query to how databases work inside
Databases and SQL
How data is stored, queried, kept consistent and scaled. Every lesson is a small machine you can step through, then a short quiz.
0 of 21 available lessons completed
Module 01 Beginner
SQL
Tables and the language for asking questions of them.
-
Lesson 01 · 10 min
What a database is
11 stepsNot started -
Lesson 02 · 12 min
Tables, rows and keys
10 stepsNot started -
Lesson 03 · 12 min
SELECT: asking questions
10 stepsNot started -
Lesson 04 · 12 min
JOINs
9 stepsNot started -
Lesson 05 · 12 min
Grouping and aggregates
9 stepsNot started -
Lesson 06 · 12 min
INSERT, UPDATE and DELETE
11 stepsNot started
Module 02 Intermediate
Design
Modelling data well so it stays correct and fast.
Module 03 Advanced
Inside a database
Pages, B-trees, transactions and recovery.
-
Lesson 12 · 14 min
Storage and pages
9 stepsNot started -
Lesson 13 · 14 min
B-trees
11 stepsNot started -
Lesson 14 · 14 min
Transactions and ACID
11 stepsNot started -
Lesson 15 · 14 min
Isolation levels
11 stepsNot started -
Lesson 16 · 15 min
MVCC
9 stepsNot started -
Lesson 17 · 14 min
Write-ahead logging and recovery
10 stepsNot started
Module 04 Advanced
At scale
Replication, sharding, NoSQL and backups.
Go deeper
Special topics
Stand-alone deep dives.