§The catalog

32 courses, one board.

Python, TypeScript, Rust, Algorithms, System design, Databases, Testing and Debugging & tools. Every course is taught live to 8 people or fewer and costs $8.64 to $148.64. None of them can be bought without talking to us first.

a: Python
b: TypeScript
c: Rust
d: Algorithms
e: System design
f: Databases
g: Testing
h: Debugging & tools

4 of 32 courses

File f: Databases

SQL, schemas, indexes and transactions — the part that outlives every rewrite.

SQL, one question at a time

SELECT, WHERE, JOIN, GROUP BY and NULL, asked of a dataset you would actually want answers from. You stop exporting to a spreadsheet to answer a question the database could.

SELECT · Joins · GROUP BY · NULL

Level: Beginner
Length: 3 weeks
Price: $14.64

Schemas that keep bad data out

Tables, keys and constraints that stop wrong rows at the door. You design a schema for a booking system, then watch the group try to break it with rows that only look valid.

Keys · Constraints · Normal forms · Relationships

Level: Intermediate
Length: 4 weeks
Price: $54.64

Indexes and the query planner

B-trees, EXPLAIN ANALYZE, statistics and the index that made a query slower. You take a sluggish endpoint from seconds to milliseconds and can say exactly which line did it.

B-trees · EXPLAIN · Statistics · Covering indexes

Level: Intermediate
Length: 3 weeks
Price: $42.64

Transactions and isolation

Isolation levels, locks, MVCC and the lost update nobody noticed for a year. You reproduce each anomaly on purpose, then choose the cheapest level that prevents it.

Isolation · MVCC · Locks · Anomalies

Level: Advanced
Length: 4 weeks
Price: $92.64

White to play

Your move.

Pick a course, or just write to us. Either way, you talk to the person who would teach you before anything is paid.

Browse the courses [email protected]