CS 460 Database Technology (FSS 2023)

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

    Slides and exercise materials will be posted here.

    Lecture

    22.02.2023: Organization, Introduction

    01.03.2023: SQL Part 1

    08.03.2023: SQL Part 2

    15.03.2023: Entity Relationship Models

    22.03.2023: Normal Forms

    Exercise

    22.02.2023: Introduction

    01.03.2023: SQL Part 1

    08.03.2023: SQL Part 2

    15.03.2023: ER Models

    22.03.2023: Normal Forms

    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
    15.2.----
    22.2.IntroductionIntroduction
    1.3.SQL Part 1SQL Part 1
    8.3.SQL Part 2SQL Part 2
    15.3.ER ModelsER Models
    22.3.Normal FormsNormal Forms
    29.3.Index and HashingIndex and Hashing + Intro Easter Eggcercise
    5.4.Easter BreakEaster Break
    12.4.Easter BreakEaster Break
    19.4.DB ArchitecturesDB Architectures
    26.4.Query Processing

    Query Processing

    3.5.Query OptimizationQuery Optimization
    10.5.Transactions and ConcurrencyTransactions and Concurrency
    17.5.RecoveryRecovery
    24.5.Application DevelopmentApplication Development