Hide menu

TDDD37 Database Technology

Lectures


This page contains lecture material and reading guides for all lectures. Slides will be available the day before the lecture.

OBS: slides with * are last year's slides and can still be changed. Final version of the slides will be available the day before the lecture.

Fö 1 (Fang) pdf (6 slides/page)  Introduction
(ed 6: ch 1-2)
(ed 5: ch 1-2)
(ed 4: ch 1-2)
(ed 3: ch 1-2)
Fö 2 (Jose) pdf (6 slides/page)  Relational databases and SQL
(ed 6: 3.1-3.2, ch 4, 5)
(ed 5: 5.1-5.2, ch 8)
(ed 4: 5.1-5.2, ch 8, 9.1-9.2)
(ed 3: 7.1-7.2, ch 8)
Fö 3 (Jose) pdf
 Data modeling, ER/EER diagram
(ed 6: ch 7 except 7.14)
(ed 5: ch 3 except 3.8, 4.1-5)
(ed 4: ch 3 except 3.8, ch 4 except 4.6)
(ed 3: ch 3, ch 4 except 4.6)
Fö 4 (Jose) pdf
 Mapping EER diagrams to relational schemas
(ed 5: ch 8)
(ed 5: ch 7)
(ed 4: ch 7)
(ed 3: ch 9.1-9.2)
Fö 5 (Fang) pdf (6 slides/page)
 Normalization
(ed 6: ch 14 except 14.6-7)
(ed 5: ch 10)
(ed 4: ch 10)
(ed 3: ch 14)
Fö 11 (Fang) pdf + pdf (6 slides/page)  SQL/PSM, stored procedures and triggers + database datastructures
MySQL Reference Manual 5.0/5.1
Fö 6 + 7 (Fang) pdf (6 slides/page)
 Database indexing
(ed 6: ch 16.1-16.2, 16.4-16.8, 17.1-17.4.1)
(ed 5: ch 13.1-13.2, 13.4-13.8, 14.1-14.4.1)
(ed 4: ch 13.1-13.2, 13.4-13.8, 14.1-14.4.1)
(ed 3: ch 5.1-5.2,5.5-5.9,6.1-6.4.1)
Fö 8 (Jose) pdf  Transactions and concurrency control
(ed 6: ch 20.1-20.4, 20.5.1-20.5.3, 20.6, 21.1)
(ed 5: ch 17.1-17.4, 17.5.1-17.5.3, 17.6, 18.1)
(ed 4: ch 17.1-17.4, 17.5.1-17.5.3, 17.6, 18.1)
(ed 3: 19.1-19.4, 19.5.1-19.5.3, 19.6, 20.1)
Fö 9 (Jose) pdf  Database recovery
(ed 6: ch 22.1-4, 22.7)
(ed 5: ch 19.1-4, 19.7)
(ed 4: ch 19.1-4, 19.7)
(ed 3: 21.1-4, 21.7)
Fö 10 (Fang) pdf, pdf (1 slide per page), solutions  Query processing and optimization
(ed 6: ch 6.1-6.3 18.1-18.3, 18.7-18.8.2)
(ed 5: ch 6.1-6.3 15.1-15.3, 15.7-15.8.2)
Fö 12 (Jose) pdf*  Selected topics

Tutorial sessions (Lektioner)

  • lektion 1: normalization (lab assistants)
  • lektion 2: project - EER (lab assistants)

Page responsible: Fang Wei-Kleiner
Last updated: 2013-12-09