
SCHEDULE & MATERIALS
| Week | Date | Topic and Materials | Homework Due | Project Milestone Due |
|---|---|---|---|---|
| 1 | Jan 12 | Course overview, pipelines | — | — |
| 2 | Jan 19 | Modeling, normalization | Homework 1 | — |
| 3 | Jan 26 | SQL basics | Homework 2 | Matchmaking Workshop |
| 4 | Feb 2 | SQL joins | Homework 3 | — |
| 5 | Feb 9 | SQL constraints | Homework 4 | Proposal |
| 6 | Feb 16 | Shell, grouping | — | — |
| 7 | Feb 23 | Midterm | — | — |
| 8 | Mar 2 | Data generation | Homework 6 | Milestone Checkpoint 1 |
| 9 | Mar 9 | Docker, JSON | Homework 7 | — |
| 10 | Mar 16 | Subqueries, windows | Homework 8 | — |
| 11 | Mar 23 | Spring break | — | Milestone Checkpoint 2 |
| 12 | Mar 30 | Regex, text | — | — |
| 13 | Apr 6 | APIs, views | Assignment 10 | — |
| 14 | Apr 13 | PostGIS, MongoDB | — | Presentation |
| 15 | Apr 20 | Project presentations | — | Final Write-Up |