Show color key

 Hide color key

Lecture

Section

Project

Exam

Homework

Office Hour

Other

Holiday

March
Monday	Tuesday	Wednesday	Thursday	Friday
29 14:30-15:40 Practice/Office Hours Zoom The Relational Model Textbook chapters 1–2 notes Textbook: purpose of database systems Textbook: history of database systems Textbook: summary Practice problems	30 20:00-21:30 Drop-in office hours on Discord	31 Project 0: C++ Primer out 14:30-15:40 Practice/Office Hours Zoom SQL Basics Textbook chapter 3 slides A good SQL tutorial site Practice problems	01 13:30-16:00 Office hours appointments	02 Introductory Survey due Homework 1: SQL out 15:10-16:10 Lab Meeting Zoom Project 0 Intro; SQL Setup Pre-lab Activities lab notes

April
Monday	Tuesday	Wednesday	Thursday	Friday
05 14:30-15:40 Practice/Office Hours Zoom Advanced SQL Textbook chapters 4–5 notes Textbook: summary Practice problems	06 20:00-21:30 Drop-in office hours on Discord	07 14:30-15:40 Practice/Office Hours Zoom Buffer Pools Textbook sections 13.2–13.5 Brief Introduction to Computer Systems notes Buffer Pool notes Textbook: Database buffer Practice problems	08 13:30-16:00 Office hours appointments	09 Project 1: Buffer Pool out 15:10-16:10 Lab Meeting Zoom Project 1 Intro Pre-lab Activities lab notes 21:00 Project 0 due
12 14:30-15:40 Practice/Office Hours Zoom Database Storage Textbook sections 12.1–12.4, 13.2–13.3 notes Practice problems 21:00 Homework 1 due	13 20:00-21:30 Drop-in office hours on Discord	14 14:30-15:40 Practice/Office Hours Zoom Hash Tables Textbook sections 14.5, 24.5 notes slides Practice problems	15 13:30-16:00 Office hours appointments	16 15:10-16:10 Lab Meeting Zoom Concurrency
19 Homework 2: Indexes out 14:30-15:40 Practice/Office Hours Zoom Indexes and B+ Trees Textbook sections 14.1–14.4 notes Textbook: B+ Tree Indexes demo of indexes in Postgres (Pavlo) Practice problems	20 20:00-21:30 Drop-in office hours on Discord	21 14:30-15:40 Practice/Office Hours Zoom Multi-Threaded Indexes notes slides Practice problems	22 13:30-16:00 Office hours appointments	23 15:10-16:10 Lab Meeting Zoom Database Interfaces; SQL Injection 21:00 Project 1 due
26 Take-home midterm out 14:30-15:40 Practice/Office Hours Zoom Query Processing: Sorting & Aggregation Textbook section 15.4 notes Textbook: External Merge Sort Practice problems	27 20:00-21:30 Drop-in office hours on Discord	28 14:30-15:40 Practice/Office Hours Zoom Query Processing: Joins Textbook section 15.5 notes Textbook: Join Algorithms Practice problems	29 13:30-16:00 Office hours appointments	30 15:10-16:10 Lab Meeting Zoom Testing; Query Plans 21:00 Take-home midterm due

May
Monday	Tuesday	Wednesday	Thursday	Friday
03 Mid-term Break	04 20:00-21:30 Drop-in office hours on Discord	05 Project 2: B+ Tree out 14:30-15:40 Practice/Office Hours Zoom Query Processing Techniques Textbook sections 15.1–15.3, 15.7 notes	06 13:30-16:00 Office hours appointments	07 Homework 3: Joins out 15:10-16:10 Lab Meeting Zoom Project 2 Intro Pre-lab Activities lab notes 21:00 Homework 2 due
10 14:30-15:40 Practice/Office Hours Zoom Parallel Query Processing Textbook chapter 22 notes Practice problems	11 20:00-21:30 Drop-in office hours on Discord	12 14:30-15:40 Practice/Office Hours Zoom Query Planning and Optimization Textbook chapter 16 notes part 1 notes part 2 Practice problems	13 13:30-16:00 Office hours appointments	14 15:10-16:10 Lab Meeting Zoom Database Exploration
17 14:30-15:40 Practice/Office Hours Zoom Concurrency Control Theory Textbook 17.1-17.2, 17.4-17.6 notes Practice problems 21:00 Homework 3 due	18 20:00-21:30 Drop-in office hours on Discord	19 Homework 4: Concurrency Control out 14:30-15:40 Practice/Office Hours Zoom Two-Phase Locking Concurrency Control Textbook sections 18.1–18.3, 18.9 notes Practice problems	20 13:30-16:00 Office hours appointments	21 Project 3: Query Execution out 15:10-16:10 Lab Meeting Zoom Project 3 Intro Pre-lab Activities lab notes
24 14:30-15:40 Practice/Office Hours Zoom Optimistic and Multi-Version Concurrency Control Textbook sections 18.5, 18.7–18.8 OCC notes MVCC notes Practice problems	25 20:00-21:30 Drop-in office hours on Discord	26 14:30-15:40 Practice/Office Hours Zoom Logging Protocols Textbook sections 19.1–19.8 notes Practice problems	27 13:30-16:00 Office hours appointments	28 15:10-16:10 Lab Meeting Zoom Database Administration
31 14:30-15:40 Practice/Office Hours Zoom Crash Recovery Textbook sections 19.1–19.9 slides Textbook: Recovery Algorithm Textbook: ARIES 21:00 Homework 4 due	01 20:00-21:30 Drop-in office hours on Discord	02 Take-home final out 14:30-15:40 Practice/Office Hours Zoom Beyond! notes 21:00 Project 2 due 21:00 Project 3 due	03 13:30-16:00 Office hours appointments	04

June
Monday	Tuesday	Wednesday	Thursday	Friday
07 21:00 Take-home final due	08	09	10	11