| 1 |
2025-09-01 (一) |
|
|
| Ch 0. Course Overview |
|
|
|
| (Slides |
Recordings) |
2025-09-04 (四) |
|
| Ch 1. Introduction |
|
|
|
| Ch 2. Introduction to the Relational Model |
|
|
|
| (Slides |
Recordings) |
Assignment 0: Signing Honor Code (Due: Wed, 09/10) |
|
| 2 |
2025-09-08 (一) |
|
|
| Ch 2. Introduction to the Relational Model |
|
|
|
| (Slides |
Recordings) |
2025-09-11 (四) |
|
| Ch 2. Introduction to the Relational Model |
|
|
|
| Ch 3. Introduction to SQL |
|
|
|
| (Slides |
Recordings) |
**Course ADD/DROP Finalization (Due: Fri, 09/12, 10:00 a.m.) |
|
Final Project - Part 1:** Team Up & Ideation (Due: Wed, 09/17 Tuesday, 9/23) |
|
|
|
| 3 |
2025-09-15(一) |
|
|
| Ch 3. Introduction to SQL |
|
|
|
| (Slides |
Recordings) |
2025-09-18(四) |
|
| Ch 3. Introduction to SQL |
|
|
|
| Ch 4. Intermediate SQL |
|
|
|
| (Slides |
Recordings) |
|
|
| 4 |
2025-09-22(一) |
|
|
| Ch 4. Intermediate SQL |
|
|
|
| (Slides |
Recordings) |
2025-09-25(四) |
|
| Ch 4. Intermediate SQL |
|
|
|
| Ch 6. Database Design Using The E-R Model |
|
|
|
| (Slides |
Recordings) |
Final Project - Overview |
|
| 5 |
**2025-09-29(一) |
|
|
| Official Holiday (No On-site Class)** |
2025-10-02(四) |
|
|
| Ch 6. Database Design Using The E-R Model |
|
|
|
| (Slides |
Recordings) |
Assignment 1: Apply SQL on real-world datasets (Due: 10/20) |
|
| 6 |
2025-10-06(一) |
|
|
| Official Holiday (No On-site Class) |
2025-10-09(四) |
|
|
| Ch 6. Database Design Using The E-R Model |
|
|
|
| Ch 7. Relational Database Design - Normalization I |
|
|
|
| (Slides |
Recordings) |
|
|
| 7 |
2025-10-13(一) |
|
|
| Ch 7. Relational Database Design - Normalization I |
|
|
|
| (Slides |
Recordings) |
2025-10-16(四) |
|
| Ch 7. Relational Database Design - Normalization I & II |
|
|
|
| (Slides |
Recordings unavailable) |
|
|
| 8 |
2025-10-20(一) |
|
|
| (No On-site Class) Dennis Travel to Conference (CSCW) |
|
|
|
| Ch 7. Relational Database Design - Normalization I & II |
|
|
|
| 2025-10-23(四) |
|
|
|
| (No On-site Class) Dennis Travel to Conference (CSCW) |
|
|
|
| Ch 7. Relational Database Design - Normalization II |
**Final Project - Part 2: Project Proposal (Due: Thu, 11/06) |
|
|
| Ch 7-2. Recordings and Course Materials:** (Slides |
Recordings) |
|
|
| 9 |
**2025-10-27(一) |
|
|
| (No On-site Class) Dennis Travel to Conference (CSCW)** |
|
|
|
| Ch 7. Relational Database Design - Normalization II |
**2025-10-30(四) |
|
|
| Midterm (**Test Paper |
Regrade Request) |
Midterm Review: (Slides |
Recordings) |
| 10 |
2025-11-03(一) |
|
|
| Ch 12. Physical Storage Systems |
|
|
|
| (Slides |
Recordings) |
2025-11-06(四) |
|
| Ch 12. Physical Storage Systems |
|
|
|
| Ch 13. Data Storage Structures |
|
|
|
| Ch 14. Indexing |
|
|
|
| (Slides |
Recordings) |
|
|
| 11 |
2025-11-10(一) |
|
|
| Ch 14. Indexing |
|
|
|
| (Slides |
Recordings) |
2025-11-13(四) |
|
| Ch 14. Indexing |
|
|
|
| Ch 15. Query Processing |
|
|
|
| (Slides |
Recordings) |
|
|
| 12 |
2025-11-17(一) |
|
|
| Ch 15. Query Processing |
|
|
|
| (Slides |
Recordings) |
2025-11-20(四) |
|
| Ch 15. Query Processing |
|
|
|
| (Slides |
Recordings: Part 1, Part 2) |
~~Final Project - Part 3: Database Implementation (Due: Wed, TBA) |
|
| ~~Midterm (Test Paper |
Regrade Request) |
|
|
| 13 |
2025-11-24(一) |
|
|
| Ch 15. Query Processing |
|
|
|
| (Slides |
Recordings) |
2025-11-27(四) |
|
| Ch 16. Query Optimization |
|
|
|
| (Slides |
Recordings) |
|
|
| 14 |
2025-12-01(一) |
|
|
| Ch 16. Query Optimization |
|
|
|
| (Slides |
Recordings) |
2025-12-04(四) |
|
| Ch 16. Query Optimization |
|
|
|
| Ch 17. Transactions |
|
|
|
| Ch 18. Concurrency Control |
|
|
|
| (Slides |
Recordings) |
Assignment 2: Practice Question Set (Due: Sun, 12/14) |
|
| 15 |
2025-12-08(一) |
|
|
| Guest Lecture: Backend Engineering Fundamentals |
|
|
|
| Lecturer: Sean Lin (Google) |
2025-12-11(四) |
|
|
| Ch 17. Transactions |
|
|
|
| Ch 18. Concurrency Control |
|
|
|
| Course Wrap-Up |
Course withdrawal (Due: 11/28) |
|
|
| 16 |
**2025-12-15(一) |
|
|
| (NO CLASS, FINAL STUDY WEEK)** |
**2025-12-18(四) |
|
|
| Final Exam** |
Final Project - Final Submission (Due: Tue, 12/23) |
|
|