Hide menu

TDDD37 Database Technology

Lectures


This page contains lecture material and reading guides for all the lectures. The slides may change until two days before the lecture.

Lecture 1: Introduction

Edition 5: Chapter 1-2
Edition 6: Chapter 1-2

Slides pdf, ppt

Lecture 2: Relational databases and SQL

Edition 5: Chapter 5 and 8
Edition 6: Chapter 3-5
Check also MySQL 5.5 Reference Manual (chapter 13)

Slides pdf, ppt

Lecture 3: EER modeling

Edition 5: Chapter 3-4
Edition 6: Chapter 7-8

Slides pdf, ppt

Lecture 4: Mapping of EER diagrams to relations

Edition 5: Chapter 7
Edition 6: Chapter 9

Slides pdf, ppt

Lecture 5: Functional dependencies and normalization

Edition 5: Chapter 10
Edition 6: Chapter 15 and 16.1

Slides pdf, ppt

Teaching session 1: Normalization (lab 3)

Slides: pdf, ppt

Lecture 6: Stored procedures and triggers

MySQL Reference Manual 5.5 (chapters 13 and 20)

Slides pdf, ppt

Examples

Lecture 7: Data structures for databases I

Edition 5: Chapter 13
Edition 6: Chapter 17

Slides pdf, ppt

Lecture 8: Data structures for databases II

Edition 5: Chapter 14
Edition 6: Chapter 18

Slides pdf, ppt

Lecture 9: Transactions and concurrency control

Edition 5: Chapter 17-18
Edition 6: Chapter 21-22

Slides pdf, ppt

Teaching session 2: Project EER diagram (lab 4a)

Mandatory attendance.

Lecture 10: Recovery of databases

Edition 5: Chapter 19
Edition 6: Chapter 23

Slides pdf, ppt

Lecture 11: Query processing and optimization

Edition 5: Chapter 6 and 15
Edition 6: Chapter 6 and 19

Slides pdf, ppt

Page responsible: Jose M. Pe?
Last updated: 2015-11-24