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:

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.

Date	Lecture	Exercise
15.2.	--	--
22.2.	Introduction	Introduction
1.3.	SQL Part 1	SQL Part 1
8.3.	SQL Part 2	SQL Part 2
15.3.	ER Models	ER Models
22.3.	Normal Forms	Normal Forms
29.3.	Index and Hashing	Index and Hashing + Intro Easter Eggcercise
5.4.	Easter Break	Easter Break
12.4.	Easter Break	Easter Break
19.4.	DB Architectures	DB Architectures
26.4.	Query Processing	Query Processing
3.5.	Query Optimization	Query Optimization
10.5.	Transactions and Concurrency	Transactions and Concurrency
17.5.	Recovery	Recovery
24.5.	Application Development	Application Development