| Week | Date | Chapter | Description | Due |
|---|---|---|---|---|
| 1 | Aug 25 | Ch 1 | First Database and Table | |
| Aug 27 | Ch 2 | Using SELECT | ||
| 2 | Sep 01 | Labor Day | ||
| Sep 03 | Ch 3 | Understanding Data Types | HW 1 due | |
| 3 | Sep 08 | Ch 4 | Importing and Exporting Data | |
| Sep 10 | Ch 5 | Math and Stats with SQL | HW 2 due | |
| 4 | Sep 15 | Ch 5 | Math and Stats with SQL | |
| Sep 17 | Ch 6 | Joining Tables | HW 3 due | |
| 5 | Sep 22 | Ch 6 | Joining Tables | |
| Sep 24 | Test 1 (Ch 1-5) | |||
| 6 | Sep 29 | Ch 7 | Designing Tables | |
| Oct 01 | Ch 7 | Designing Tables | HW 4 due | |
| 7 | Oct 06 | Ch 8 | Grouping and Summarizing | |
| Oct 08 | Ch 9 | Inspecting and Modifying Data | HW 5 due | |
| 8 | Oct 13 | Ch 9 | Inspecting and Modifying Data | |
| Oct 15 | Ch 11 | Dates and Times | HW 6 due | |
| 9 | Oct 20 | Window Functions | ||
| Oct 22 | Ch 12 | Advanced Queries | HW 7 due | |
| 10 | Oct 27 | Ch 12 | Advanced Queries | |
| Oct 29 | Test 2 (Ch 6-9) | |||
| 11 | Nov 03 | Ch 13 | Mining Text | |
| Nov 05 | Ch 13 | Mining Text | HW 8 due | |
| 12 | Nov 10 | Ch 14 | Spatial Data with POSTGIS | |
| Nov 12 | Ch 14 | Spatial Data with POSTGIS | HW 9 due | |
| 13 | Nov 17 | Webscraping | ||
| Nov 19 | Ch 15 | Views, Functions, and Triggers | HW 10 due | |
| 14 | Nov 24 | Ch 15 | Views, Functions, and Triggers | |
| Nov 26 | Thanksgiving Break | |||
| 15 | Dec 01 | Ch 17 | Project Presentations | |
| Dec 03 | Ch 17 | Project Presentations | ||
| 16 | Dec 10 | Final |