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: Tuesday, 10.15 - 11.45 Room B6 A1.04
  • Exercise: Friday, 10.15 - 11.45, 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:

Exercises:

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

WeekTuesday (Lecture)Friday (Exercise)
04.09.2017IntroductionIntroduction
11.09.2017SQL Part 1SQL Part 1
18.09.2017SQL Part 2SQL Part 2
25.09.2017ER ModelsER Models
02.10.2017--Summary & Big exercise
09.10.2017Normal FormsNormal Forms
16.10.2017Index and Hashing
--
23.10.2017--Index and Hashing
30.10.2017--Big exercise
06.11.2017DB ArchitecturesDB Architectures
13.11.2017Query ProcessingQuery Processing
20.11.2017Query OptimizationQuery Optimization
27.11.2017Transactions and ConcurrencyTransactions and Concurrency
04.12.2017RecoveryRecovery