G51DBS - Database Systems
Lectures
The module lecture slides will be added here shortly before each lecture. Below you will find the approximate structure for the lectures, this is subject to change.
- Introduction, Dr. Peter Blanchfield
- Relations and Relational Algebra [PDF]
- The Relational Model [PDF]
- Entity Relationship Modelling [PDF]
- SQL Data Definition [PDF]
- SQL Data Definition II [PDF]
- SQL Select [PDF]
- SQL Select II [PDF]
- SQL Select III [PDF]
- PHP and MySQL [PDF]
- PHP and MySQL II [index.php]
- Missing Information (NULLs) [PDF]
- Normalisation [PDF]
- Normalisation II [PDF]
- Transactions [PDF]
- Concurrency [PDF]
- Concurrency II [PDF]
- Efficiency and Storage [PDF]
- Database Security (and SQL Injection Attacks) [PDF] Injection: [Search] [Login] [Website Source]
- Modern Databases [PDF]
- Revision - Wednesday 11th May 9am LT3 [2pp PDF] [6pp PDF]
- Revision - Thursday 12th May 4pm LT3