Hide menu

TDDD37 Database Technology

Lectures


This page contains lecture material and reading guides for all the lectures. The slides will be available the day before the lecture. Slides marked with * are last year's slides and may be changed.

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 Reference Manual 6.0

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: Triggers and stored procedures

MySQL Reference Manual 6.0 (Chapter 18)

Slides pdf*, ppt*

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*

Lecture 12: Summary and Muddy cards evaluation


Page responsible: Jose M. Peña
Last updated: 2014-10-28