| Week | Topic | Course Materials | Note | |
|---|---|---|---|---|
| 1 | Course Overview | [syllabus] | ||
| 2 | Introduction to Database |
[slides]
[video1] , [video2] , [video3] |
Chapter 1 | |
| 3 | Introduction to SQL - Part 1 |
[slides]
[video1] , [video2] , [video3] |
Chapter 3
Reference Book Database |
|
| 2-2 | Introduction to SQL - Part 2 |
[Slides from previous week used]
[video1] , [video2] , [video3] , [video4] , [video5] , [video6] |
Chapter 3 | |
| 3 | SQL Practice - Part 1 |
|
||
| 4 | Intermediate SQL |
[slides]
[video1] , [video2] , [video3] , [video4] , [video5] |
Chapter 4 | |
| 5 | Advanced SQL |
[slides]
[video1] , [video2] , [video3] , [video4] , [video5] , [video6] |
Chapter 5 | |
| 6 | SQL Practice - Part 2 |
|
||
| 7 | Relational Algebra |
[slides]
[video1] , [video2] |
Chapter 2 | |
| 8 | Exam 1 Review | Exam Review (Chapters 1-5) | Exam 1 on Wednesday, 4/2/2025 at 8:30 AM via Canvas | |
| 9 | Database Design - ER Diagram |
[slides]
ER Case Study |
Chapter 6 | |
| 10 | Transfer ER to Relational Schema | [slides] | Chapter 6 | |
| 11 | Database Design: Normalization | [slides] Normalization Example |
Chapter 7 | |
| 12 | Exam 2 Review | Exam 2 Review (Chapters 6-7) | Exam 2 on Monday, 05/12/2025 at 8:30 AM via Canvas |
| Team number | Team member | Demo Date |
|---|---|---|
| #1 | 1.Sara Vaseem, 2.Kaung Khant, 3.Sara Madjdi | |
| #2 | 1.Joshua Gonzalez-Hahn, 2.Angelo Centenera, 3.Geoffrey Anselmo | |
| #3 | 1.Haarik Vallurupalli, 2.Vashishta Aennapoosala | |
| #4 | 1.Aldrind Reyes, 2.Fabiana Mayorga | |
| #5 | 1.Marco Minas, 2.Chinedu Egbujor, 3.Andres Feldstedt | |
| #6 | 1.Alfredo Ulloa, 2.Jacob Valmeo, 3.Emilio Montes | |
| #7 | 1.Vikranth Varma Boddu, 2.Varalakshmi Devi Mangari Kuruva | |
| #8 | 1.Ethan-Emmanuel Yanez, 2.Spencer Crowell, 3.Shadi Zgheib | |
| #9 | 1.Jade Dergevorkian, 2.Joshua Tung | |
| #10 | 1.Niall Barrett, 2.Mathews Silva | |
| #11 | 1.Bryan Abrego | |
| #12 | 1.Uriel Bailon | |
| #13 | 1.Eric Hong | |
| #14 | 1.Nam Vu |