| 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 TBD |
| Team number | Team member | Demo Date |
|---|---|---|
| #1 | 1.Jordan Gottleib, 2.Ryan Ilan | TBD |
| #2 | 1.Juan Rodriguez, 2.Gloria Arias, 3.Jacob Arce | TBD |
| #3 | 1.Spencer Levine, 2.Grace Gallardo, 3.Ashton Rosales | TBD |
| #4 | 1.Ryan Sarmiento, 2.Kevin Karimi, 3.Diego Aragon | TBD |
| #5 | 1.Joshua Guzman, 2.Andrew Mazlumyan, 3.Javier Herrera | TBD |
| #6 | 1.Manan Bhuva, 2.Rudrakumar Khunt, 3.Krish Mangukiya | TBD |
| #7 | 1.Julio Reyes, 2.Taha Farooqui, 3.Miguel Jauregui | TBD |
| #8 | 1.Marlon Rios, 2.Brian Figueroa, 3.Mirella Soto | TBD |
| #9 | 1.Keano Aquino, 2.Christian Herrera | TBD |
| #10 | 1.Sean Cano, 2.Tyra Quiachon, 3.Renata S. Dantanarayana |