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 HWS2017 will take place on : Thursday, February 15th, 10am, at room B6 C1.01.

 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

WeekWednesday(Lecture)Wednesday(Exercise)
14.02.2018IntroductionIntroduction
21.02.2018SQL Part 1SQL Part 1
28.02.2018SQL Part 2SQL Part 2
07.03.2018ER ModelsER Models
14.03.2018Normal FormsNormal Forms
21.03.2018Index and HashingIndex and Hashing & Big exercise
28.03.2018-- (Easter Break)
-- (Easter Break)
04.04.2018-- (Easter Break)-- (Easter Break)
11.04.2018DB ArchitecturesDB Architectures & Big exercise
18.04.2018Query ProcessingQuery Processing & Big exercise
25.04.2018Query OptimizationQuery Optimization
02.05.2018Transactions and ConcurrencyTransactions and Concurrency
09.05.2018-- (canceled)-- (canceled)
16.05.2018RecoveryRecovery
23.05.2018Application DevelopmentApplication Development