Databases (HT2015)
Lecture Notes
Lecture notes will be published here during the course.
Important: the slides below do not cover everything that are said and
given during the lectures.
To get the full coverage, attend the lectures and read the
Course Book.
- Lecture 1, Introduction [1pp,4pp,6pp]
- Lecture 2, E-R diagrams [1pp,4pp,6pp]
- Lecture 3, Functional Dependencies [1pp,4pp,6pp]
- Lecture 4, Normalisation [1pp,4pp,6pp]
- Lecture 5, Independencies, Design wrapup [1pp,4pp,6pp]
- Lecture 6, SQL DDL and DML. Queries and Relational Algebra [1pp,4pp,6pp]
- Lecture 7, SQL Queries cont., Views [1pp,4pp,6pp]
- Lecture 8, SQL Queries cont. [1pp,4pp,6pp]
- Lecture 9, SQL DML and DDL, Assertions and Triggers [1pp,4pp,6pp]
- Lecture 10, SQL/PSM, Embedded SQL, JDBC [1pp,4pp,6pp]
- Lecture 11, Transactions, Authorization [1pp,4pp,6pp]
- Lecture 12, Optimization, Indexes, Non-natural keys [1pp,4pp,6pp]
- Lecture 13, Semi-structured data, XML [1pp,4pp,6pp]
- Lecture 14, Database Systems, RDBMSs, NoSQL [1pp,4pp,6pp]
- Lecture 15, Course overview [1pp,4pp,6pp]
Last Modified: 14 December 2015
by Niklas Broberg