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
- …
| Date | Subject |
|---|---|
| January 20 | Lecture 1, Introduction |
| January 21 | Lecture 2, The relational data model |
| January 25 | Lecture 3, E-R diagrams |
| January 28 | Lecture 4, Functional dependencies and normal forms |
| February 1 | Lecture 5, SQL 1 |
| February 4 | Lecture 6, SQL2 |
| February 8 | Lecture 7, Table modification, triggers |
| February 15 | Lecture 8, Relational algebra, query compilation |
| February 18 | Lecture 9, Embedded SQL |
| February 22 | Lecture 10, Transactions, authorization, indexes |
| February 25 | Lecture 11, XML and NoSQL |
| February 29 | Lecture 12, Databases at Spotify (guest lecture by Oscar Söderlund, Spotify) |
| March 3 | Lecture 13, Exam training |
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