Credit: Anna Logue
CS 460 Database Technology (FSS 2023)
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
- Lecture: Wednesday, 12.00 – 13.30, B6 26, A104
- Exercise: Wednesday, 13.45 – 15.15, B6 26, A104
Exam Review
- The exam review for the first exam of FSS2023 will take place on Monday, August 21st, between 10:00 and 10:30 in room C1.01 (building B6, 29). Please register by mail to Bianca Lermer until Monday, August 14th.
- The exam review for the second exam of FSS2023 will take place on Friday, October 20th, between 10:00 and 10:30 in room B0.01 (building B6, 26). No registration necessary.
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 materials will be posted here.
Lecture
22.02.2023: Organization, Introduction
01.03.2023: SQL Part 1
08.03.2023: SQL Part 2
15.03.2023: Entity Relationship Models
22.03.2023: Normal Forms
29.03.2023: Indexing and Hashing
19.04.2023: Database Architectures
26.04.2023: Query Processing
03.05.2023: Query Optimization
10.05.2023: Transactions and Concurrency
17.05.2023: Recovery
24.05.2023: Application Development
Exercise
22.02.2023: Introduction
01.03.2023: SQL Part 1
08.03.2023: SQL Part 2
15.03.2023: ER Models
22.03.2023: Normal Forms
29.03.2023: Indexing and Hashing
19.04.2023: Database Architectures
26.04.2023: Query Processing
03.05.2023: Query Optimization
10.05.2023: Transactions, Concurrency
17.05.2023: Recovery
24.05.2023: Application Development
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 15.2. -- -- 22.2. Introduction Introduction 1.3. SQL Part 1 SQL Part 1 8.3. SQL Part 2 SQL Part 2 15.3. ER Models ER Models 22.3. Normal Forms Normal Forms 29.3. Index and Hashing Index and Hashing + Intro Easter Eggcercise 5.4. Easter Break Easter Break 12.4. Easter Break Easter Break 19.4. DB Architectures DB Architectures 26.4. Query Processing Query Processing
3.5. Query Optimization Query Optimization 10.5. Transactions and Concurrency Transactions and Concurrency 17.5. Recovery Recovery 24.5. Application Development Application Development