Hide menu

TDDD12 Database Technology

Lectures


This page contains lecture material including reading guides for all the lectures. The reading guides refer to the textbook for the course (Elmasri, R. and Navathe, S. B. Fundamentals of Database Systems, Addison Wesley). The old slides made available here are the slides that have been used in earlier versions of the course.

Topic 1: Introduction

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

Slides: logistics,   Slides: quizzes

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

old slides,   old slides for print-out (6 slides per page)

Topic 2: Relational databases

Video lecture; please watch the first 15:10 minutes of this video before the corresponding lecture session (i.e., you can stop at the end of slide 17, the rest of the video is not relevant at this point) and, while you do so, take notes on things that are unclear to you.

Slides: lecture and quizzes

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

old slides,   old slides for print-out (6 slides per page)

Topic 3: SQL

Video lecture for the first SQL-related lecture session: part 1 (24:32 mins) and part 2 (35:13 mins); please watch these two videos 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.

Video lecture for the second SQL-related lecture session: part 3 (32:17 mins) and part 4 (7:20 mins; attention: you do not need to watch the whole video but only the first 7:20 minutes; that is, you can stop at the end of slide #9).

Slides: quizzes

Edition 5: Chapter 8
Edition 6: Chapters 4, 5
Edition 7: Chapters 6, 7
Check also MySQL 5.5 Reference Manual (chapter 13)

old slides,   old slides for print-out (6 slides per page)

Topic 4: EER modeling

Video lecture: part 1 (33:04 mins; attention: watch only from time point 42:23 until the end) and part 2 (10:00 mins; watch only the first 10:00 minutes of this video); please watch these two videos 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: see the next topic

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

old slides,   old slides for print-out (6 slides per page)

Topic 5: Mapping of EER diagrams to relations

Video lecture: part 1 (23:30 mins) and part 2 (5:50 mins; watch only the first 5:50 minutes of this video); please watch these two videos 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: quizzes

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

old slides,   old slides for print-out (6 slides per page)

Topic 6: Functional dependencies and normalization

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)

old slides,   old slides for print-out (6 slides per page)

Topic 7: Stored procedures and triggers

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

MySQL Reference Manual 5.5 (chapters 13 and 20)

old slides,   old slides for print-out (6 slides per page)

Topic 8: Data Structures for Databases

Video lecture; for the first lecture session on the topic, please watch until 1:03:40 into the video (i.e., you can stop at the end of slide 53, the rest of the video is not relevant at this point); for the second lecture session on the topic, please watch the remaining 43:18 minutes of the video (i.e., start at time point 1:03:40 when the presenter goes to slide 54).

Slides: quizzes

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

old slides,   old slides for print-out (6 slides per page)

Topic 9: Introduction to Transaction Processing

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

old slides,   old slides for print-out (6 slides per page)

Topic 10: Transactions and Concurrency Control

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

old slides,   old slides for print-out (6 slides per page)

Topic 11: Recovery of Databases

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

old slides,   old slides for print-out (6 slides per page)

Topic 12: Query Processing and Optimization

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

old slides,   old slides for print-out (6 slides per page)


Page responsible: Olaf Hartig
Last updated: 2017-03-14