1
What is a relational database?
6 min
2
SELECT: your first query
9 min
3
Filtering with WHERE
12 min
4
Sorting & LIMIT
6 min
5
Aggregates: COUNT, SUM, AVG
9 min
6
GROUP BY & HAVING
12 min
7
INNER JOIN
6 min
8
LEFT JOIN & NULLs
9 min
9
Subqueries
12 min
10
DISTINCT & de-duplication
6 min
11
CASE expressions
9 min
12
Working with dates
12 min
13
String functions & LIKE
6 min
14
Capstone: analytics on a shop
9 min
Three tracks, one Postgres.
Every lesson pairs a short read with runnable SQL. Your progress lives in this browser.
✓
Install PostgreSQL
7 min
✓
initdb & cluster anatomy
9 min
✓
Start, stop & status
11 min
✓
psql & connecting
13 min
✓
Create users & roles
7 min
✓
pg_hba.conf & auth
9 min
7
postgresql.conf parameters
11 min
8
Backup with pg_dump
13 min
9
Restore strategies
7 min
10
VACUUM & autovacuum
9 min
11
Monitoring queries & locks
11 min
12
Kill sessions safely
13 min
13
Constraints & integrity
7 min
14
Extensions
9 min
15
Indexes & EXPLAIN
11 min
16
Replication & HA
13 min
17
Load balancing
7 min
18
Capstone: run a production DB
9 min
✓
Why AI needs databases
8 min
2
Embeddings 101
10 min
3
Installing pgvector
12 min
4
Vector columns & inserts
14 min
5
Similarity search operators
9 min
6
Indexing vectors: HNSW & IVFFlat
11 min
7
Hybrid search: SQL + vectors
13 min
8
Chunking documents
8 min
9
Building a RAG pipeline
10 min
10
Evaluating retrieval quality
12 min
11
Capstone: docs Q&A on Postgres
14 min