Hide menu

TDDD81 Database Technology

Lectures


This page contains lecture material including the lecture videos and reading guides for all topics. The reading guides refer to the textbook for the course (Elmasri, R. and Navathe, S. B. Fundamentals of Database Systems, Addison Wesley).

Table of Content


Topic 1: Introduction

Video lecture: video (1h); please watch this video before the first lecture session and, while you do so, take notes on things that are unclear to you.

Material of the lecture session: slides about logistics, slides with quizzes, recording from last version of the course (33:36 mins)

Old material: slides from previous traditional lecture

Edition 5: Chapters 1, 2
Edition 6: Chapters 1, 2
Edition 7: Chapters 1, 2

Topic 2: EER Modeling

Video lecture: video (51:46 mins); this video is accessible only to people at LiU; please watch this video before the corresponding lecture session and, while you do so, take notes on things that are unclear to you so that we can clarify them in the lecture session.

Slides: as presented in the video

Material of the lecture session: slides with quizzes and exercises, recording of lecture session (1:34:23)

Edition 5: Chapters 3, 4
Edition 6: Chapters 7, 8
Edition 7: Chapters 3, 4

Topic 3: Relational Databases

Video lecture: video (92:07 mins), slides; the video is accessible only to people at LiU

Material of the lecture session: slides with quizzes and exercises, recording (94:00 mins)

Edition 5: Chapter 5
Edition 6: Chapter 3
Edition 7: Chapter 5

Topic 4: Mapping of EER Diagrams to Relations

Video lecture: part 1 (13:14 mins), part 2 (28:47 mins), part 3 (18:40 mins), slides

Material of the lecture session: slides with quizzes and exercises, recording of lecture session (1:25:09)

Edition 5: Chapter 7
Edition 6: Chapter 9
Edition 7: Chapter 9

Topic 5: SQL

Video lecture for the first SQL-related lecture session: part 1 (43:32 mins) and part 2 (49:12 mins); these videos are accessible only to people at LiU

Video lecture for the second SQL-related lecture session: part 1 (43:29 mins) and part 2 (50:54 mins)

Slides: as presented in the videos

Material of the lecture sessions: slides with quizzes and exercises, recording of first lecture session (1:29:16), recording of second lecture session (1:32:54)

Edition 5: Chapter 8
Edition 6: Chapters 4, 5
Edition 7: Chapters 6, 7
Check also MySQL 8.0 Reference Manual (Chapter 13 - SQL Statements)

Topic 6: Stored Procedures and Triggers

Material: video (36:47 mins), slides

Note that we do not have a lecture session about this topic, but the topic is relevant for the BrianAir project.

Edition 5: Sections 9.4 and 24.1
Edition 6: Sections 13.4, 5.2.2, and 26.1
Edition 7: Sections 10.4, 7.2.2, and 26.1

Check also MySQL 8.0 Reference Manual (in particular, Chapter 25 and Section 13.1.22)

Topic 7: Functional Dependencies and Normalization

Video lecture for the first lecture session on the topic: part 1 (46:57 mins), part 2 (48:31 mins)

Video lecture for the second lecture session on the topic: part 3 (47:36 mins), part 4 (51:45 mins)

Slides: as presented in the videos

Material of the lecture sessions: slides with quizzes and exercises, recording of first session (95:50 mins),

Edition 5: Chapter 10
Edition 6: Chapters 15 and 16.1
Edition 7: Chapters 14 and 15 (except for 14.6-14.7 and 15.4-15.6)

Topic 8: Introduction to Transaction Processing

Video lecture: video (35:26 mins), slides

Material of the lecture session: will be made available here after the lecture session

Edition 5: Chapters 17
Edition 6: Chapters 21
Edition 7: Chapters 20

Topic 9: Recovery of Databases

Video lecture: part 1 (11:19 mins), part 2 (47:05 mins), slides

Material of the lecture session: will be made available here after the lecture session

Edition 5: Chapter 19
Edition 6: Chapter 23
Edition 7: Chapter 22

Topic 10: Transactions and Concurrency Control

Video lecture: part 1 (9:11 mins), part 2 (51:09 mins), part 3 (8:14 mins, recap of parts 1 and 2), part 4 (27:04 mins), slides
Notice that you can safely skip part 3 unless you want a summary again of parts 1 and 2.

Material of the lecture session: will be made available here after the lecture session

Edition 5: Chapters 17, 18
Edition 6: Chapters 21, 22
Edition 7: Chapters 20, 21

Topic 11: Data Structures for Databases

Video lecture: part 1 (49:50 mins), part 2 (35:19 mins), part 3 (59:22 mins)

Slides: as presented in the video

Material of the lecture sessions: will be made available here after the lecture session

Edition 5: Chapter 13, 14
Edition 6: Chapter 17, 18
Edition 7: Chapter 16, 17

Topic 12: Query Processing and Optimization

Video lecture: part 1 (36:01 mins), part 2 (53:30 mins), slides

Material of the lecture session: will be made available here after the lecture session

Edition 5: Chapters 6 and 15
Edition 6: Chapters 6 and 19
Edition 7: Chapters 18, 19


Page responsible: Olaf Hartig
Last updated: 2017-01-11