Calendar
Click the title of a lecture to view the page with lecture notes.
For reference materials, "DMS" refers to the textbook (Database Management Systems),
denoted in purple.
Weekly problem sets are due each Tuesday night, available on Gradescope.
Lab assignment writeups are on the assigments page; submissions on Thursdays on Gradescope.
Jump to: January | February | March | April/May
January 2025
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|---|---|---|---|---|---|---|
| 19 | 20 | 21 Lecture 1: Introduction, Relational model Reading: DMS Ch. 1, 3.1-3.2 |
22 | 23
Lecture 2: Intro to SQL, Memory hierarchy, Disks
Reading: DMS Ch. 9.1, 9.3, 9.4 Lab 1: Part 0 out |
24 |
25 |
| 26 |
27 |
28
Lecture 3: Buffer manager, Files and records
Reading: DMS Ch. 9.5-9.7 Problem set 1 out |
29 |
30
Lecture 4: Intro to indexes
Reading: DMS Ch. 8 Lab 1: Part 0 "due" |
31 |
1 |
February 2025
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|---|---|---|---|---|---|---|
| 2 |
3 |
4
Lecture 5: Tree-based indexes
Reading: DMS Ch. 10 Problem set 1 due |
5 |
6
Lecture 6: Hash-based indexes
Reading: DMS Ch. 11 Lab 1: Part 1 due |
7 |
8 |
| 9 |
10 |
11
Lecture 7: Relational algebra
Reading: DMS Ch. 4.1-4.2 Problem set 2 due |
12 |
13
Lecture 8: SQL
Reading: DMS Ch. 5 Lab 1: Final due |
14 |
15 |
16 |
17 |
18
Lecture 9: SQL II
Reading: DMS Ch. 5 Problem set 3 due |
19 |
20
Lecture 10: Query Evaluation I
Reading: DMS Ch. 12.2, 13.1-13.4 Lab 2: Part 1 due |
21 |
22 |
| 23 |
24 |
25
Lecture 11: Query Evaluation II
Reading: DMS Ch. 14.0-14.6 Problem set 4 due |
26 |
27
Lecture 12: Query Optimization I
Reading: DMS Ch. 12.1, 12.4-12.5,15.1,15.3 Lab 2: Part 2 due |
28 |
1 |
March 2025
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|---|---|---|---|---|---|---|
| 2 |
3 |
4
Lecture 13: Query Optimization II
Reading: DMS Ch. 15.2,15.4 Problem set 5 due |
5 |
6
Note: classroom change for today, class in Shan 1480 Reading: DMS Ch. 15.4-15.6 Lab 2: Final dueLab 3: Part 1 out |
7 |
8 |
| 9 |
10 |
11 Lecture 15: Midterm in class |
12 |
13 No class Lab 3: Part 1 due |
14 |
15 |
| 16 |
17 Spring Break |
18 |
19 |
20 |
21 |
22 |
| 23 |
24 |
25
Lecture 16: Transactions I
Reading: DMS Ch. 16.1-16.6, 17.1 Problem set 6 out |
26 |
27
Lecture 17: Transactions II
Reading: DMS Ch. 17.2-17.5 Lab 3: Part 2 due |
28
Cesar Chavez day |
29 |
April/May 2025
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|---|---|---|---|---|---|---|
| 30 | 31 | 1
Lecture 18: Transactions III
Reading: DMS Ch. 17.6, 16.7 Problem set 6 due |
2 | 3
Lecture 19: Recovery
Reading: DMS Ch. 18.1-18.6 Lab 3: Final due |
4 | 5 |
| 6 |
7 | 8
Lecture 20: Database Design I
Reading: DMS Ch. 2.1-2.5,3.5 Problem set 7 due |
9 | 10
Lecture 21: Database Design II
Reading: DMS Ch. 19.1-19.3 Lab 4: Part 1 due |
11 |
12 |
| 13 |
14 |
15
Lecture 22: Database Design III
Reading: DMS Ch. 19.4-19.7 Problem set 8 due |
16 |
17
Lecture 23: Object Oriented and Semi-Structered
Reading: DMS Ch. 23, 27.6-27.8, Object-Relational DBMS - The Next Wave Lab 4: Final due |
18 |
19 |
| 20 |
21 |
22 Lecture 24: Distributed and Parallel DBMSs exercise worksheet Reading: DMS Ch. 22.1-22.3, 22.8, 22.10-22.12, 22.14.1 Problem set 9 due |
23 |
24
Lecture 25: NoSQL
Reading: References (skim only): |
25 |
26 |
| 27 |
28 |
29
Lecture 26: OLAP and Data Analytics
Reading: DMS Ch. 25.1-25.5,25.7,25.9. Can also skim: Lakehouse: A New Generation of Open Platforms that Unify Data Warehousing and Advanced Analytics Problem set 10 due |
30 |
May 1
Lecture 27: Last class! Includes time for evaluations
Lab 5 due |
May 2 Take-home exam available by 5pm |
3 |
| 4 |
5 |
6 |
7 |
May 8
Graduating Seniors: |
9 |
10 |
| 11 |
May 12 Non-graduating students: |
13 |
13 |
15 |
16 |
17 |