CS 460 Database Technology (FSS 2024)

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

  • Lecture: Wednesday, 12.00 – 13.30, B6 26, A104
  • Exercise: Wednesday, 13.45 – 15.15, B6 26, A104
  • Administrative Details

    No formal registration (Portal2 or ILIAS) is required, but you are invited to join the ILIAS group.

  • Material and Literature

    Lecture Slides:

    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

    DateLectureExercise
    14.2.IntroductionIntroduction
    21.2.SQL Part 1SQL Part 1
    28.2.SQL Part 2SQL Part 2
    6.3.ER ModelsER Models
    13.3.Normal Forms (Video)Normal Forms
    20.3.Index and Hashing

    Index and Hashing + Intro Easter Eggcercise

    27.3.Easter BreakEaster Break
    3.4.Easter BreakEaster Break
    10.4.DB ArchitecturesDB Architectures
    17.4.Query ProcessingQuery Processing
    24.4.Query OptimizationQuery Optimization
    1.5.HolidayHoliday
    8.5.Transactions and ConcurrencyTransactions and Concurrency
    15.5.RecoveryRecovery
    22.5.Application DevelopmentApplication Development