Databases
Where the data lives - and how not to lose it, corrupt it or wait on it.
- 1Tables, queries and joinsAsk a real SQLite database questions about a small zoo - and catch the two queries that return a tidy table, no error, and the wrong answer.Runs in your browserOn your machine16 min+35 XP
- 2Why one query takes 2 ms and another 20 sFind 10 orders among 200,000, watch SQLite read every row, add an index and watch it jump. Then meet the log-in query an index on email can't help.Runs in your browserOn your machine18 min+40 XP
- 3Transactions and the lost updateTwo clerks sell the same tee at the same moment and the stock only drops by one. Find out why BEGIN and COMMIT alone don't fix it, and the three fixes that do - each checked against a real PostgreSQL.Runs in your browserOn your machine18 min+40 XP
- 4Replicas, lag and why a replica is not a backupA replica copies every change a moment later. That's why you can save your name and still see the old one - and why a replica copies a DROP TABLE just as faithfully. Get the data back with point-in-time recovery.Runs in your browserOn your machine18 min+40 XP
Next track: Containers →