Schedule

This course schedule is subject to change through the quarter.

The textbook referred to here is the "cow book" mentioned on the home page.

Lecture slides and video links will be made available here well in advance of the lecture meetings. Joining the lecture slot call is not mandatory. You are welcome to view the lecture videos and/or review the lecture slides at a different time slot that works better for your time zone.

Note that each Canvas Quiz in this class (6 short quizzes, midterm exam, and final exam) will have a fixed global time window within which it must be taken regardless of where you are.

Week	Topic	Textbook Chapters, Additional References	Slides	Videos

1	Introduction; Recap of Relational Algebra and SQL	Ch 1, 4, 5.1-5.6	PPTX PDF	Video_0_1 Video_0_2 Video_0_3 Video_0_4
1-2	Data Storage; Buffer Management; File Organization	Ch 8, except 8.5.4, Ch 9, except 9.2	PPTX PDF	Video_1_1 Video_1_2 Video_1_3 Video_1_4 Video_1_5

2	Talk by TA on Project 1 on 4/10 (Fri)	–	Docs	-

3-4	Indexing (B+ Tree; Hash Index)	Ch 10, Ch 11, sections 11.1-11.2 only	PPTX PDF	Video_2_1 Video_2_2 Video_2_3 Video_2_4
4	External Sorting	Ch 13	PPTX PDF	Video_3_1 Video_3_2

5	Midterm Exam on 4/29 (Wed); Sample exams in docs page	–	–	–

5	Talk by TA on Project 2 on 5/1 (Fri)	–	PPTX PDF

5-7	Relational Operator Implementations; Query Processing	Ch 12, sections 12.1-12.3, Ch 14	PPTX PDF	Video_4_1 Video_4_2 Video_4_3 Video_4_4 Video_4_5 Video_4_6
7-8	Query Optimization	Ch 12, sections 12.4 - 12.6	PPTX PDF	Video_5_1 Video_5_2 Video_5_3
8-9	Transaction Management; Concurrency Control	Ch 16, up to 16.6.1	PPTX PDF	Video_6_1 Video_6_2 Video_6_3

9	No class on 5/25 (Mon; Memorial Day Holiday)	–	–	–

9-10	Parallel Data Systems	Ch 22, till 22.5; More references in slides	PPTX PDF	Video_7_1 Video_7_2 Video_7_3 Video_7_4
10	Optional: NoSQL, Graph, and ML Systems	Not in syllabus	PPTX PDF	Video

11	Optional: ML for RDMBSs	Not in syllabus	PPTX PDF	Video

11	Final Exam on 6/11 (Thu); Sample exams in docs page	–	–	–