Standard syllabus
Advanced databases · Graduate · CS / Programming
Topics
Query processing
- Relational algebra equivalence and optimization
- Cost-based optimization and statistics
- Join algorithms: nested loop, hash join, sort-merge
- Indexing strategies beyond B-trees
- Parallel query execution
Transactions and recovery
- Serializability and conflict/view definitions
- Two-phase locking and timestamp ordering
- MVCC in commercial systems
- ARIES recovery algorithm (intro)
- Distributed transactions and 2PC (intro)
Pricing
Graduate-level rates are set on consultation. See the pricing page for K–12 and undergraduate rates.