Databases (VT2011)
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, Indexes, "NoSQL" [1pp,4pp,6pp]
- Lecture 13, SSD, XML [1pp,4pp,6pp]
- Lecture 14, Summary [1pp,4pp,6pp]
Last Modified: 3 March 2011
by Niklas Broberg