CS 460 Database Technology (HWS 2017)
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, Room B6 A1.04
- Exercise: Wednesday, 13.45 – 15.15, Room B6 A1.04
Exam Review
- The exam review for the first and second exam from FSS2018 will take place on : Thursday, 27 September, 9am, in room C1.01 (building B6, 26).
Administrative Details
No formal registration (Portal2 or ILIAS) is required, but you are invited to join the ILIAS group.
Material and Literature
Slides:
- 14.02.: Organization, Introduction
- 21.02.: SQL Part 1
- 28.02.: SQL Part 2
- 07.03.: ER Models
- 14.03.: Normalization
- 21.03. Indexing and Hashing
- 11.04. Database Architectures
- 18.04. Query Processing
- 25.04. Query Optimization
- 02.05. Transactions and Concurrency
- 16.05. Recovery
- 23.05. Application Development
Exercises:
- 14.02.: Introduction
- 21.02.: SQL 1
- 28.02.: SQL_2
- 07.03.: ER_Models
- 14.03.: Normalization
- 21.03.: Indexing and Hashing
- 21.03.: Easter Break
- 11.04.: Database Architectures
- 18.04.: Query Processing
- 25.04.: Query Optimization
- 02.05.: Transactions and Concurrency
- 16.05.: Recovery
- 23.05.: Application Development
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
Week Wednesday (Lecture) Wednesday (Exercise) 14.02.2018 Introduction Introduction 21.02.2018 SQL Part 1 SQL Part 1 28.02.2018 SQL Part 2 SQL Part 2 07.03.2018 ER Models ER Models 14.03.2018 Normal Forms Normal Forms 21.03.2018 Index and Hashing Index and Hashing & Big exercise 28.03.2018 -- (Easter Break) -- (Easter Break) 04.04.2018 -- (Easter Break) -- (Easter Break) 11.04.2018 DB Architectures DB Architectures & Big exercise 18.04.2018 Query Processing Query Processing & Big exercise 25.04.2018 Query Optimization Query Optimization 02.05.2018 Transactions and Concurrency Transactions and Concurrency 09.05.2018 -- (canceled) -- (canceled) 16.05.2018 Recovery Recovery 23.05.2018 Application Development Application Development