Lectures

Lecture notes are available here and will be updated during the course.

You can also access the slides from last year here. These slides can give a different perspective and thereby help your understanding.

The notes and the slides do not cover everything that is said and given during the lectures. But they should contain enough of the technical material so that you can prepare for the exam if you need to skip some lectures. To get the full coverage, attend the lectures and read the Course Book.

Course Plan

The course will contain:

  • Relational model, E-R diagrams
  • Functional dependencies
  • Normalization, BCNF, Multivalued dependencies, 3NF, 4NF
  • SQL DDL, SQL Queries, Relational Algebra
  • Assertions, Triggers
  • SQL/PSM, Embedded SQL, JDBC
  • Transactions, Authorization
  • Indexes
  • XML

Lecture 1, Introduction

Book sections
  • Database Systems: The Complete Book, first edition: 1
  • Database Systems: The Complete Book, second edition: 1

Lecture 2, The relational data model

Book sections
  • Database Systems: The Complete Book, first edition: 3.1, 3.6.1-2, 2, 3.2
  • Database Systems: The Complete Book, second edition: 2.2, 3.3.1-2, 4.1-6

Lecture 3, E-R diagrams

Book sections
  • Database Systems: The Complete Book, first edition: 2, 3.2-5
  • Database Systems: The Complete Book, second edition: 4.1-6, 3.1-2

Lecture 4, Functional dependencies and normal forms

Book sections
  • Database Systems: The Complete Book, first edition: 3.6.3-, 3.7
  • Database Systems: The Complete Book, second edition 3.3.3-4, 3.4.1, 3.5.1, 3.6

Lecture 5, SQL 1

Book sections
  • Database Systems: The Complete Book, first edition: 6.5-6, 7.1-3, 5.1-2, 6.1.1-2, 6.2.1
  • Database Systems: The Complete Book, second edition: 6.5, 2.3, 7.1-3, 2.4, 6.1.1-2, 6.2.1

Country data: countries.tsv

Lecture 6, SQL2

Book sections
  • Database Systems: The Complete Book, first edition: 5.2.9-, 6.1.3 -6, 6.2.2-4, 6.3.1-7, 6.7.1-2
  • Database Systems: The Complete Book, second edition: 2.4.11-, 6.1.3-7, 6.2.2-4, 6.3.1-7, 8.1

Lecture 7, Table modification, triggers

Book sections
  • Database Systems: The Complete Book, first edition: rest of 5 & 6 except 6.7
  • Database Systems: The Complete Book, second edition: 6.1.8, 6.2.5, 6.3.8, 6.4, 5.1, 5.2, 2.5

Lecture 8, Relational algebra, query compilation

Book sections
  • Database Systems: The Complete Book, first edition: 6.7, 7.1.5, 7.4-
  • Database Systems: The Complete Book, second edition: 8.1, 8.2, 7.1.2, 7.4-7.5

Lecture 9, Embedded SQL

Book sections
  • Database Systems: The Complete Book, first edition: 8.1-5
  • Database Systems: The Complete Book, second edition: 9.2-6

Lecture 10, Transactions, authorization, indexes

Book sections
  • Database Systems: The Complete Book, first edition: 8.6-7; 6.6.5-6,13.1-2
  • Database Systems: The Complete Book, second edition: 6.6, 10.1, 18.1; 8.3-4, 14.1

Lecture 11, XML and NoSQL

Book sections
  • Database Systems: The Complete Book, first edition: 4.6-7
  • Database Systems: The Complete Book, second edition: 11.1-2

Lecture 12, Databases at Spotify (guest lecture by Oscar Söderlund, Spotify)

Lecture 13, Exam training