CMU 15-445/645 :: Intro to Database Systems (Fall 2021)

<aside> 💡 I. Relational Databases

1. The Relational Model

2. Intermediate SQL

</aside>

<aside> 💡 II. Storage

Disk Manager

3. Data Storage I

4. Data Storage II

Buffer Pool Manager

5. Buffer Pools

Access Methods

6. Hash Tables

7. Tree Indexes

8. Index Concurrency Control

</aside>

<aside> 💡 III. Execution

Operator Execution

9. Sorting & Aggregation

10. Join Algorithms

11. Query Execution I

12. Query Execution II

Query Planning

13. Query Planning I

14. Query Planning II

</aside>

<aside> 💡 IV. Concurrency Control

15. Concurrency Control

16. Two-Phase Locking

17. Timestamp Ordering Concurrency Control

18. Multi-Version Concurrency Control

</aside>

<aside> 💡 V. Recovery

19. Database Logging

20. Database Crash Recovery

</aside>

<aside> 💡 VI. Distributed Databases

21. Introduction to Distributed Databases

22. Distributed OLTP Databases

23. Distributed OLAP Databases

</aside>