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 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

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ña
Last updated: 2014-12-10