| Week | Topic | Course Materials | Note | |
|---|---|---|---|---|
| 1-1 | Course Overview | [syllabus] | ||
| 1-2 | Introduction to Database |
[slides]
[video1] , [video2] , [video3] |
Chapter 1 | |
| 2 | Introduction to SQL - Part 1 |
[slides]
[video1] , [video2] , [video3] |
Chapter 3
Reference Book Database |
|
| 3 and 4 | Introduction to SQL - Part 2 |
[Slides from previous week used]
[video1] , [video2] , [video3] , [video4] , [video5] , [video6] |
Chapter 3 | |
| 5 | SQL Practice - Part 1 |
|
||
| 6 | Intermediate SQL |
[slides]
[video1] , [video2] , [video3] , [video4] , [video5] |
Chapter 4 | |
| 7-1 | Advanced SQL |
[slides]
[video1] , [video2] , [video3] , [video4] , [video5] , [video6] |
Chapter 5 | |
| 7-2 | SQL Practice - Part 2 |
|
||
| 8-9 | Exam 1 Review | Exam Review (Chapters 1, 3, 4) | Exam 1 on Fri, 3/29 at 11:30 AM via Canvas (Section 1: 11:30 AM - 12:45 PM) |
|
| 10 - 11 | Database Design - ER Diagram |
[slides]
ER Case Study |
Chapter 6 | |
| 12 | Transfer ER to Relational Schema | [slides] | Chapter 6 | |
| 13-14 | Database Design: Normalization | [slides] Normalization Example |
Chapter 7 | |
| 15 | Exam 2 Review | Exam Review (Chapters 6 - 7) | Exam 2 (online) on Fri, 05/10 at class time via Canvas (Section 1: 11:30 AM - 1:15 PM) |
| Team number | Team member | Demo Date |
|---|---|---|
| #1 | 1.Edwin Rivera, 2.Itzel Castaneda, 3.Zori badkerhanian | |
| #2 | 1.David Helmi, 2.Aryaman Mehta, 3.Jorge Torrez | |
| #3 | 1.Shelby Gallegos, 2.Daniel Barlam, 3.Rishabh Chadha | |
| #4 | 1.Justin Reyes, 2.Kobi Sherman, 3.Neville Elieh Janvisloo | |
| #5 | 1.Michael Buchinskiy, 2.Alek Ovsepyan, 3.Ahmad Satarzai | |
| #6 | 1.Jonathan Williams, 2.Justin Lee | |
| #7 | 1.Christian Walsh, 2.Michael Green, 3.Richard Caldera | |
| #8 | 1.Raneen Kakar, 2.Shima Jabbari, 3.Ali Kiani | |
| #9 | 1.Summer (Kyungwon) Shin, 2.Adrian Vergara | |
| #10 | 1.Garrette Clarke, 2.Joseph Valdez, 3.Elijah Lockett |