Lecture Notes
Lecture notes will be published here during the course.
Important: the slides below do not cover everything that is said and
given during the lectures.
To get the full coverage, attend the lectures and read the
Course Book.
-
Lecture 1, Introduction
(one per page,
six per page,
alternative slides)
-
Lecture 2, Design 1 E-R diagrams
(one per page,
six per page,
alternative slides)
-
Lecture 3, Design 2 Functional Dependencies
(one per page,
six per page,
alternative slides)
-
Lecture 4, Design 3 Normalisation
(one per page,
six per page,
alternative slides, 1,
alternative slides, 2)
-
Lecture 5, Database Construction 1:
SQL DDL and DML. Relational Algebra
(one per page,
six per page,
alternative slides)
-
Lecture 6, Database Usage 1:
SQL Queries and Relational Algebra
(one per page,
six per page,
alternative slides)
-
Lecture 7, Database Usage 2: More SQL Queries and Relational Algebra
(one per page,
six per page,
alternative slides)
-
Lecture 8, Database Construction 2:
More on Modifications and Table Creation. Assertions, Triggers
(one per page,
six per page,
alternative slides)
-
Lecture 9, Database Applications SQL/PSM, Embedded SQL, JDBC
(one per page,
six per page,
alternative slides)
(some extra slides on Embedded SQL
and ODBC)
-
Lecture 10, Database Usage 3: Transactions, Authorization, Indexes
(one per page,
six per page,
alternative slides;
one per page,
six per page)
-
Lecture 11, XML
(alternative slides)
-
Lecture 12, Guest lecture from Spotify: Cassandra (Marcus Better)
-
Lecture 13, Revision: going through old exams
Last Modified: 23 February 2015
by Aarne Ranta.