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 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 28 October 2024, 04:14:50 PM.