| Week | Topic | Course Materials | Note | |
|---|---|---|---|---|
| 1-1 | Course Overview | [syllabus] | ||
| 1-2 | Introduction to Database |
[slides]
[video1] , [video2] , [video3] |
Chapter 1 | |
| 2-1 | 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 | |
| 2-3 | SQL Practice - Part 1 |
|
||
| 3-1 | Intermediate SQL - Part 1 |
[slides]
[video1] , [video2] , [video3] , [video4] , [video5] |
Chapter 4 | |
| 3-2 | Advanced SQL |
[slides]
[video1] , [video2] , [video3] , [video4] , [video5] , [video6] |
Chapter 5 | |
| 3-3 | SQL Practice - Part 2 |
|
||
| 3-4 | Relational Algebra |
[slides]
[video1] , [video2] |
Chapter 2 | |
| 4 | Exam 1 Review | Exam Review (Chapters 1-5) | Exam 1 on Monday, 6/29/2026 at 12:00 PM via Canvas | |
| 5-1 | Database Design - ER Diagram |
[slides]
ER Case Study |
Chapter 6 | |
| 5-2 | Transfer ER to Relational Schema | [slides] | Chapter 6 | |
| 6-1 | Database Design: Normalization | [slides] Normalization Example |
Chapter 7 | |
| 6-2 | Exam 2 Review | Exam 2 Review (Chapters 6, 7) | Exam 2 on Tuesday, 7/7 at 12:00 PM via Canvas |
| Team number | Team member | Demo Date |
|---|---|---|
| #1 | 1.Oleksandr Kovalenko, 2.Grant Griffin | Tuesday, 7/7 @ 1PM |
| #2 | 1.Zachary Bayles, 2.Wun Ng, 3.Dhruvin Patel | TBD |
| #3 | 1.Daniel Dayrit, 2.Emmanuel Sanchez, 3.Leonid Vartanian | TBD |
| #4 | 1.Ethan Gonzalez | TBD |
| #5 | 1.Alirie Gray, 2.Christian Bartle, 3.Odelia Sheelo | TBD |
| #6 | 1.Gor Navasardyan, 2.Kipp Reitzel, 3.Sofiia Unkovskaia | TBD |
| #7 | 1.Brandon Contreras, 2.Kevin Aguilar, 3.Guadalupe Ramos | TBD |
| #8 | 1.Angie Alas, 2.Hassanat Ahmed, 3.Adrian Villaneda | TBD |
| #9 | 1.Jose Bastidas Gonzalez | TBD |
| #10 | 1.Kyle Coleman | TBD |
| #11 | 1.Tristan Munoz, 2.Daniel Ray | TBD |
| #12 | 1.Leslie Cruz | TBD |
| #13 | 1.George Danielyan | TBD |
| #14 | 1.Rodolfo Medina | TBD |
| #15 | 1.Sarkis Nazaryan, 2.Julian Lozada, 3.Hero Jaiyen | TBD |