CS 460 Database Technology (FSS 2024)
Important: This course is open only to MMDS students!
Exam review. The exam review is going to take place on Friday, September 20th, at 9 am. Please contact Ms Ezgi Yilmaz upfront if you want to review your exam. The deadline for registering for the exam review is Tuesday, September 17th, EOB.
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, B6 26, A104
- Exercise: Wednesday, 13.45 – 15.15, B6 26, A104
Administrative Details
No formal registration (Portal2 or ILIAS) is required, but you are invited to join the ILIAS group.
Material and Literature
Lecture Slides:
- 14.02.: Organization (PDF, 2 MB), Introduction (PDF, 3 MB)
- 21.02.: SQL Part 1 (PDF, 3 MB)
- 28.02.: SQL Part 2 (PDF, 8 MB)
- 06.03.: Entity Relationship Models (PDF, 6 MB)
- 13.03.: Normal Forms (PDF, 4 MB)
- 20.03.: Indexing and Hashing (PDF, 16 MB)
- 10.04.: Database Architectures (PDF, 10 MB)
- 17.04.: Query Processing (PDF, 6 MB)
- 24.04.: Query Optimization (PDF, 3 MB)
- 08.05.: Transactions and Concurrency (PDF, 2 MB)
- 15.05.: Recovery (PDF, 2 MB)
- 22.05.: Application Development (PDF, 3 MB)
Video recordings, 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.
Outline
Date Lecture Exercise 14.2. Introduction Introduction 21.2. SQL Part 1 SQL Part 1 28.2. SQL Part 2 SQL Part 2 6.3. ER Models ER Models 13.3. Normal Forms (Video) Normal Forms 20.3. Index and Hashing Index and Hashing + Intro Easter Eggcercise
27.3. Easter Break Easter Break 3.4. Easter Break Easter Break 10.4. DB Architectures DB Architectures 17.4. Query Processing Query Processing 24.4. Query Optimization Query Optimization 1.5. Holiday Holiday 8.5. Transactions and Concurrency Transactions and Concurrency 15.5. Recovery Recovery 22.5. Application Development -- 29.5. -- Application Development