CS 460 Database Technology (FSS 2020)
Important: This course is open only to MMDS students!
Retake Exam: The second exam will take place on 24 September 2020.
IMPORTANT: Online Lecture During Corona Outbreak!
We'll run the lecture remotely during the suspension of the on-site teaching during the Corona outbreak. The time (Wednesday, noon) is the same.
For the lecture, we'll use Cisco Webex. Use this link to get to the lecture's meeting room.
The exam is going to take place at the announced time and date (10 June, 11.30–12.30) as an online open book exam.
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
- Lecture: Wednesday, 12.00 – 13.30, Room B6 A1.04
- Exercise: Wednesday, 13.45 – 15.15, Room B6 A1.04
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.
Slides
- 12.02.: Organization, Introduction
- 19.02.: SQL Part 1
- 26.02.: SQL Part 2
- 11.03.: ER Models
- 18.03.: Normal Forms
- 25.03.: Indexing and Hashing
- 01.04.: Database Architectures
- 22.04.: Query Processing
- 29.04.: Query Optimization
- 06.05.: Transactions and Concurrency
- 13.05.: Recovery
- 20.05.: Application Development
Exercises
- 12.02.: Introduction , schema, data
- 19.02.: SQL Part 1
- 26.02.: SQL Part 2
- 11.03.: ER_Models
- 18.03.: Normal Forms
- 25.03.: Indexing Hashing
- 01.04.: Database Architectures, Easter Eggxercise
- 22.04.: Query Processing
- 29.04.: Query Optimization
- 06.05.: Transactions Concurrency
- 13.05.: Recovery
- 20.05.: Application Development
Outline
Date Topic 12.2. Introduction 19.2. SQL Part 1 26.2. SQL Part 2 4.3. SQL Bootcamp (exercise only (lecture time slot), no lecture on this date) 11.3. ER Models 18.3. Normal Forms 25.3. Index and Hashing 1.4. DB Architectures, Introduction to Special Easter Eggxercise 8.4. Easter Break 15.4. Easter Break 22.4. Query Processing 29.4. Query Optimization 6.5. Transactions and Concurrency 13.5. Recovery 20.5. Application Development 27.5. Wrap up and Q&A (exercise only, no lecture on this date)