Slides will be available before the lecture; Video and Data several hours after the lecture.
The Video links all go to YouTube; in addition, videos of all lectures are on Echo360.
| Week 1 Tuesday | Data Modelling, ER Model | Slides, Video, Data |
| Week 1 Thursday | ER, Relational Model, ER->Rel Mapping | Slides, Video, Data |
| Week 2 Tuesday | SQL DDL, ER->SQL Mapping | Slides, Video, Data |
| Week 2 Thursday | ER->SQL Mapping, Building Databases | Slides, Video, Data |
| Week 3 Tuesday | Assignment 1, Modifying a DB, BeerDB | Slides, Video, Data |
| Week 3 Thursday | Simple BeerDB, Querying, SQL | Slides, Video, Data |
| Week 4 Tuesday | More SQL, Stored Procedures, PLpgSQL | Slides, Video, Data |
| Week 4 Thursday | More PLpgSQL | Slides, Video, Data |
| Week 5 Tuesday | Ass1, More PLpgSQL, Aggregates, Constraints | Slides, Video, Data |
| Week 5 Thursday | Triggers, PL/DBMS, Python/Psycopg2 | Slides, Video, Data |
| Week 6 | No Lectures | - |
| Week 7 Tuesday | Assignment 2, More Python/Psycopg2 | Slides, Video, Data |
| Week 7 Thursday | Relational Design Theory: FDs, Closures | Slides, Video, Data |
| Week 8 Tuesday | Normalisation (BCNF, 3NF) | Slides, Video, Data |
| Week 8 Tuesday | Dylan's Assignment 2 Q&A | Video |
| Week 8 Thursday | Relational Algebra, DBMS Architecture | Slides, Video, Data |
| Week 9 Tuesday | Query Evaluation, Transactions | Slides, Video, Data |
| Week 9 Thursday | Serializability, Locking, Database Futures | Slides, Video, Data |
| Week 10 Tuesday | Course Review, Exam Preview | Slides, Video |
| Week 10 Thursday | - |
Resource created Saturday 10 December 2022, 06:11:34 PM, last modified Tuesday 02 May 2023, 09:38:31 AM.