Credit: Anna Logue
CS 460 Database Technology (FSS 2021)
Important: This course is open only to MMDS students!
Course Description
The course provides an introduction to relational database systems. The course will cover the following topics:
- Principles of data storage
- Database query languages (SQL)
- Relational modeling
- Keys and normal forms
- Hash and index structures
- Transactions and concurrency
Lecturers
Dates and Times
Exam Review
- The exam review for the retake exam of FSS2021 will take place on Thursday, 04 November 2021, starting from 08:00. You have to register for the exam review by writing a mail to Bianca Lermer until Thursday, 28 October 2021. We will then allocate a time slot for the review to you.
Administrative Details
No formal registration (Portal2 or ILIAS) is required, but you are invited to join the ILIAS group.
Material and Literature
Slides and exercise assignments will be posted here shortly before the respective courses take place.
Exercise solutions and additional materials will be made available in the corresponding ILIAS group.
The course will be based on the book Database System Concepts by Silberschatz et al.
Lecture:
- 03.03.2021: Organization, Introduction
- 10.03.2021: SQL Part 1
- 17.03.2021: SQL Part 2
- 24.03.2021: ER Models
- 14.04.2021: Normal Forms
- 21.04.2021: Indexing and Hashing
- 28.04.2021: Database Architectures
- 05.05.2021: Query Processing
- 12.05.2021: Query Optimization
- 19.05.2021: Transactions and ConcurrencyNote: there is no live lecture on 19th! We provide a pre-recorded lecture video, please check ILIAS for the link and password to the video.
- 26.05.2021: Recovery
- 02.06.2021: Database Applications
Exercise:
- 03.03.2021: Prologue, Intro
- 10.03.2021: SQL_1
- 17.03.2021: SQL_2
- 24.03.2021: ER Model Easter Exercise
- 14.04.2021: Normal Forms
- 21.04.2021: Indexing Hashing
- 28.04.2021: Database Architectures
- 05.05.2021: Query Processing
- 12.05.2021: Query Optimization
- 19.05.2021: Transactions Concurrency
- 26.05.2021: Recovery
- 02.06.2021: Database Applications
Outline
Date Lecture Exercise 3.3. Introduction Introduction 10.3. SQL Part 1 SQL Part 1 17.3. SQL Part 2 SQL Part 2 24.3. ER Models ER Models + Introduction Easter Eggcercise
31.3. Easter Break -- 7.4. Easter Break -- 14.4. Normal Forms Normal Forms 21.4. Index and Hashing Index and Hashing 28.4. DB Architectures DB Architectures 5.5. Query Processing Query Processing 12.5. Query Optimization Query Optimization 19.5. Transactions and Concurrency Transactions and Concurrency 26.5. Recovery Recovery 2.6. Application Development Application Development 9.6. -- Wrap up and Q&A (lecture slot)