Photo credit: Anna Logue

CS 460 Database Technology (FSS 2021)

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

Dates and Times

Until further notice, the lecture and exercise will be conducted exclusively online.

  • Lecture: Wednesday, 12.00 – 13.30,  (please use Portal2 to get the Zoom link)
  • Exercise: Wednesday, 13.45 – 15.15, (please use Portal2to get the Zoom link)
  • 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 assignments will be posted here shortly before the respective courses take place.

    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.

    Lecture:

    Exercise:

  • Outline

    DateLectureExercise
    3.3.IntroductionIntroduction
    10.3.SQL Part 1SQL Part 1
    17.3.SQL Part 2SQL Part 2
    24.3.ER Models

    ER Models + Introduction Easter Eggcercise

    31.3.Easter Break--
    7.4.Easter Break--
    14.4.Normal FormsNormal Forms
    21.4.Index and HashingIndex and Hashing
    28.4.DB ArchitecturesDB Architectures
    5.5.Query ProcessingQuery Processing
    12.5.Query OptimizationQuery Optimization
    19.5.Transactions and ConcurrencyTransactions and Concurrency
    26.5.RecoveryRecovery
    2.6.Application DevelopmentApplication Development
    9.6.--Wrap up and Q&A