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.
| Weekly Previews | 01, 02, 03, 03, 04, 05, 07, 08, 09, 10 | |
| Week 1 Monday | Data Modelling, ER Model | Slides, Video, Data |
| Week 1 Wednesday | ER, Relational Model, ER->Rel Mapping | Slides, Video, Data |
| Week 2 Monday | SQL DDL, ER->SQL Mapping | Slides, Video, Data |
| Week 2 Wednesday | ER->SQL Mapping, Building Databases | Slides, Video, Data |
| Week 3 Monday | Ass1, Modifying a DB, Simple BeerDB, SQL | Slides, Video, Data |
| Week 3 Wednesday | More SQL | Slides, Video, Data |
| Week 4 Monday | Stored Procedures, PLpgSQL | Slides, Video, Data |
| Week 4 Wednesday | More PLpgSQL | Slides, Video, Data |
| Week 5 Monday | Aggregates, Constraints, Triggers | Slides, Video, Data |
| Week 5 Wednesday | PL/DBMS, Python/Psycopg2 | Slides, Video, Data |
| Week 6 | no lectures | - |
| Week 7 Monday | Assignment 2, More Python/Psycopg2 | Slides, Video, Data |
| Week 7 Wednesday | Relational Design Theory: FDs, Closures | Slides, Video, Data |
| Week 8 Monday | Normalisation (BCNF, 3NF) | Slides, Video, Data |
| Week 8 Wednesday | Relational Algebra, DBMS Architecture | Slides, Video, Data |
| Week 9 Monday | Query Evaluation, Transactions | Slides, Video, Data |
| Week 9 Wednesday | Serializability, Locking | Slides, Video, Data |
| Week 10 Monday | Database Futures, Course Review, Exam Preview | Slides, Video |
| Week 10 Wednesday | - |
Resource created Wednesday 07 June 2023, 08:02:41 AM, last modified Monday 01 June 2026, 08:42:51 PM.