Swedish web site
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) (last update: 2.sep.2012) | Introduction, SQL (part 1) slides see below (ed 6: ch 1-2) (ed 5: ch 1-2) (ed 4: ch 1-2) (ed 3: ch 1-2) |
| Fö 2 (Fang) | pdf (6 slides/page) (last update: 2.sep.2012) | 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 (Jose) | pdf |
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 , code example | SQL/PSM, stored procedures and triggers MySQL Reference Manual 5.0/5.1 |
| Fö 6 + 7 (Fang) | pdf +
pdf (6 slides/page)
(last update: 27.sep.2012)
|
Data structures for databases (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) | 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) | 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 (Jose) | 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 (several) | Selected topics |
Tutorial sessions (Lektioner)
- lektion 1: normalization (lab assistants)
- lektion 2: project - EER (lab assistants)
Page responsible: Fang Wei-Kleiner
Last updated: 2012-10-12
