Database System Concepts for Non-Computer Scientists

• Altan Birler
• Michael Zinsmeister

Information

This course will be held in English!

Description:

• IN4714: Part of the module BV470015 Geodatabases

• Extent: The lecture has 2 weekly hours per semester and gives 2 credits (ECTS).

• Content:
• Database Design
• Relational Data Model
• Relational Query Language SQL
• Data Integrity
• Physisical Organization of the Data
• Query Execution
• Transaction Management
• (Main Memory Databases, NoSQL Data Bases, Data Warehouses, etc.)

Dates

• Always check TUM online

Tools

Our tools:
SQL with Umbra

SQL Games:
SQL Island
Murder in SQL City

Downloads:
uni_schema.sql
uni_schema_extended.sql

Material

Lecture Slides
Lecture Intro
Introduction: Databases
Modeling/ER-Diagrams
Relational Model
SQL: Intro + DDL
SQL: Queries 1/2
SQL: Queries 2/2
SQL: DML
Index Structures
Query Data with DuckDB	Create Statements,Solutions
Repetition

Exercise Sheet	Solution
Exercise Sheet 1	Solution 1
Exercise Sheet 2	Solution 2
Exercise Sheet 3	Solution 3
Exercise Sheet 4	Solution 4
Exercise Sheet 5	Solution 5
Exercise Sheet 6	Solution 6