| Week | Topics |
| All | Weekly Previews: 01, 02, 03 , 04 , 05 , 07 , 08 , 09 , 10 |
| 00 | Course Welcome, Course Overview |
| 01 | Data Modelling, ER, Relational, ER→Relational |
| 02 | SQL intro, DBMSs, SQL DDL, ER→SQL |
| 03 | SQL: Sample DB, Updating, Queries, Views |
| 04 | More SQL Queries, Stored Procedures, PLpgSQL |
| 05 | PLpgSQL (ii), Constraints, Triggers, Aggregates, DB Programming |
| 06 | flex week - no new content |
| 07 | Python, Pyscopg2, Relational Design Theory |
| 08 | Relational Design Theory |
| 09 | Relational Algebra, Query Evaluation |
| 10 | Transactions, Course Review, Exam Preview |
Resource created Sunday 10 September 2023, 10:00:14 PM, last modified Sunday 12 November 2023, 09:23:49 PM.