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 PDFVideo_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