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
- Topic 2: Relational databases
- Topic 3: Basic SQL
- Topic 4: EER modeling
- Topic 5: Mapping of EER diagrams to relations
- Topic 6: Advanced SQL
- Topic 7: Information security concepts
- Topic 8: Information security modeling
- Topic 9: Database security
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
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
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
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 (16:25 mins), slides
Material of the lecture session: will be made available here after the lecture session
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)
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: lecture slides
Topic 9: Database security
Material: lecture slides
Edition 5: Chapter 23
Edition 6: Chapter 24
Edition 7: Chapter 30
Page responsible: Olaf Hartig
Last updated: 2024-10-17