Schedule

No	Date	Topic	Slides	PSets	Code	Readings
		Chapter 0: Introduction
1	Aug 23	Course Introduction	[slides]	[pset]		§ 1
2	Aug 25	Relational Model Assignment 1 Released	[slides]	[pset]		§ 2
3	Aug 30	Advanced SQL	[slides]	[pset]		§ 3, 4
		Chapter 1: Storage Management
4	Sep 01	Disk Space Management	[slides]	[pset]		§ 12, 13
5	Sep 06	Memory Management	[slides]	[pset]		"
6	Sep 08	Data Representation Assignment 1 Due Assignment 2 Released	[slides]	[pset]		"
7	Sep 13	Buffer Management (Part 1)	[slides]	[pset]		"
8	Sep 15	Buffer Management (Part 2)	[slides]	[pset]		"
9	Sep 20	Compression	[slides]	[pset]		"
10	Sep 22	Project Proposal (Part 1)
11	Sep 27	Project Proposal (Part 2)
12	Sep 29	Larger-than-Memory Databases + Persistent Memory Databases Assignment 2 Due Assignment 3 Released	[slides] [slides]	[pset] [pset]		"
		Chapter 2: Access Methods
13	Oct 04	Access Methods	[slides]	[pset]		§ 14, 18
14	Oct 06	Mid-term Exam
15	Oct 11	Hash Tables	[slides]	[pset]		"
16	Oct 13	Trees (Part 1)	[slides]	[pset]		"
17	Oct 18	🍂 🍂 🎃 Fall Break — No Class 🎃 🍂 🍂
18	Oct 20	Trees (Part 2) Assignment 3 Due Assignment 4 Released	[slides]	[pset]		"
19	Oct 25	Index Concurrency Control	[slides]	[pset]		"
20	Oct 27	Modern OLTP Indexes	[slides]	[pset]		"
21	Nov 01	Project Updates (Part 1)
22	Nov 03	Project Updates (Part 2)
		Chapter 3: Query Execution
23	Nov 08	Sorting and Aggregation	[slides]	[pset]		§ 15
24	Nov 11	Joins	[slides]	[pset]		"
25	Nov 15	Query Execution (Part 1) Assignment 4 Due	[slides]	[pset]		"
26	Nov 17	Query Execution (Part 2)	[slides]	[pset]		"
27	Nov 22	Scheduling + Conclusion	[slides]	[pset]		"
28	Nov 24	🦃 🦃 🥧 Thanksgiving Break — No Class 🥧 🦃 🦃
29	Nov 29	Break
30	Dec 01	Final Project Presentations
31	Dec 06	Break
32	Dec 08	Final Exam

NOTE: The schedule is tentative and is subject to change as the semester progresses.

Credits

These slide decks are derived from courses developed by Thomas Neumann and Andy Pavlo.