Hide menu

TDDE49 Databases and information security for bioinformatics

Lectures


This page contains lecture material including reading guides for all the lectures. The reading guides refer to the textbook for the course (Elmasri and Navathe: Fundamentals of Database Systems, Addison Wesley).

Table of Content


Topic 1: Introduction

Material: lecture slides

Edition 5: Chapters 1, 2
Edition 6: Chapters 1, 2
Edition 7: Chapters 1, 2

Topic 2: Relational databases

Video lecture: video (92:07 mins); this video is accessible only to people at LiU; please watch this video before the corresponding lecture session and, while you do so, take notes on things that are unclear to you so that we can clarify them in the lecture session.

Slides: as presented in the video

Material of the lecture session: slides with quizzes and exercises, recording (94:23 mins)

Edition 5: Chapter 5
Edition 6: Chapter 3
Edition 7: Chapter 5

Topic 3: Basic SQL

Video lecture for the first SQL-related lecture session: part 1 (43:32 mins) and part 2 (49:12 mins); these videos are accessible only to people at LiU

Slides: as presented in the videos

Material of the lecture session: slides with quizzes and exercises, recording of lecture session (1:20:35)

Edition 5: Chapter 8
Edition 6: Chapters 4, 5
Edition 7: Chapters 6, 7
Check also MySQL 5.5 Reference Manual (chapter 13)

Topic 4: EER modeling

Video lecture: video (51:46 mins), slides

Material of the lecture session: slides with quizzes and exercises, recording of lecture session (1:23:25; the first few minutes are missing, sorry!)

Edition 5: Chapters 3, 4
Edition 6: Chapters 7, 8
Edition 7: Chapters 3, 4

Topic 5: Mapping of EER diagrams to relations

Video lecture: video part 1 (13:14 mins), video part 2 (28:47 mins), video part 3 (18:40 mins), slides

Material of the lecture session: slides with quizzes and exercises, recording of lecture session (1:14:12)

Edition 5: Chapter 7
Edition 6: Chapter 9
Edition 7: Chapter 9

Topic 6: Advanced SQL

Video lecture for the second SQL-related lecture session: part 1 (43:29 mins) and part 2 (50:54 mins)

Slides: as presented in the videos (in particular, slides 25 and following)

Material of the lecture session: slides with quizzes and exercises (together with the slides from the first SQL lecture session), recording of the lecture session (1:31:59)

Edition 5: Chapter 8
Edition 6: Chapters 4, 5
Edition 7: Chapters 6, 7
Check also MySQL 5.5 Reference Manual (chapter 13)

Topic 7: Information security concepts

Material: lecture slides

Topic 8: Information security modeling

Material: will be made available here close before the lecture session

Topic 9: Database security

Material: will be made available here close before the lecture session

Edition 5: Chapter 23
Edition 6: Chapter 24
Edition 7: Chapter 30


Page responsible: Olaf Hartig
Last updated: 2021-05-05