CS 133: Database Systems

Fall 2026

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: September | October | November | December

 
 

September 2026

Sunday Monday Tuesday Wednesday Thursday Friday Saturday
30 31 1

Lecture 1: Introduction, Relational model

Reading: DMS Ch. 1, 3.1-3.2


2 3

Lecture 2: Intro to SQL, Memory hierarchy, Disks

exercise worksheet

Reading: DMS Ch. 9.1, 9.3, 9.4

Lab 1: Part 0 out


 4
 5
6

 7

Labor day


 8

Lecture 3: Buffer manager, Files and records

exercise worksheet

Reading: DMS Ch. 9.5-9.7

Problem set 1 out


 9

 10

Lecture 4: Intro to indexes

exercise worksheet

Reading: DMS Ch. 8

Lab 1: Part 0 "due"
Lab 1: Part 1 out


 11

 12
13

 14

 15

Lecture 5: Tree-based indexes

exercise worksheet

Reading: DMS Ch. 10

Problem set 1 due
Problem set 2 out


 16

 17

Note: class in Shan 3465 today!

Lecture 6: Hash-based indexes

exercise worksheet

Reading: DMS Ch. 11

Lab 1: Part 1 due
Lab 1: Final out


 18
 19
20

 21

 22

Lecture 7: Relational algebra

exercise worksheet

Reading: DMS Ch. 4.1-4.2

Problem set 2 due
Problem set 3 out


 23

 24

Lecture 8: SQL

exercise worksheet

Reading: DMS Ch. 5

Lab 1: Final due
Lab 2: Part 1 out


 25

 26
27

 28

 29

Lecture 9: SQL II

exercise worksheet

Reading: DMS Ch. 5

Problem set 3 due
Problem set 4 out


 30

 1

Lecture 10: Query Evaluation I

exercise worksheet

Reading: DMS Ch. 12.2, 13.1-13.4

Lab 2: Part 1 due
Lab 2: Part 2 out


 2

 3

 
 

October 2026

Sunday Monday Tuesday Wednesday Thursday Friday Saturday
4

 5

 6

Lecture 11: Query Evaluation II

exercise worksheet

Reading: DMS Ch. 14.0-14.6

Problem set 4 due
Problem set 5 out


 7

 8

Lecture 12: Query Optimization I

exercise worksheet

Reading: DMS Ch. 12.1, 12.4-12.5,15.1,15.3

Lab 2: Part 2 due
Lab 2: Final out


 9

 10
11

 12

 13

Lecture 13: Query Optimization II

Reading: DMS Ch. 15.2,15.4

Problem set 5 due


 14

 15

Lecture 14: Midterm in class (covers through lecture 11)


 16

 17
18

 19

Fall Break


 20

 21

 22

Lab 2: Final due
Lab 3: Part 1 out


 23

 24
25

 26

 27

Problem set 6 out


 28
 29

Lab 3: Part 1 due
Lab 3: Final out


 30

 31

 
 

November 2026

Sunday Monday Tuesday Wednesday Thursday Friday Saturday
1 2 3

Problem set 6 due
Problem set 7 out


 4 5

Lab 3: Final due
Lab 4: Part 1 out


 6 7

8
 9 10

Problem set 7 due
Problem set 8 out


 11 12

Lab 4: Part 1 due
Lab 4: Final out


 13

 14
15

 16

 17

Problem set 8 due
Problem set 9 out


 18

 19

Lab 4: Final due
Lab 5 out


 20

 21
22

 23

 24

Problem set 9 due


 25

Thanksgiving break


 26

 27

 28

 
 

December 2026

Sunday Monday Tuesday Wednesday Thursday Friday Saturday
29

 30

 1

Problem set 10 out


 2

 3


 4

 5
6

 7

 8

Problem set 10 due


 9

 10

Lab 5 due


 11


 12
13

 14

 15

 16

 17

Final exam: 2-5pm


 18

 19