Relational & SQL

When is a relation the clearest model?

Learn schema design and SQL, then open the engine: parsing, planning, indexes, joins, MVCC, transactions, and recovery.

Systems compared

• PostgreSQL
• MySQL
• SQLite
• Oracle Database
• SQL Server

Open the engine

1. Relational algebra
2. B-tree and hash indexes
3. Query planning and joins
4. MVCC and isolation
5. WAL, vacuum, and recovery

Reconstruction lab

Design a schema, explain a query plan, reproduce an isolation anomaly, and tune the workload.