Database System Concepts for Non-Computer Scientists
Information
This course will be held in English!
Description:
- IN4714: Part of the modules BV470015 Geodatabases as well as BV300022 Spatial Databases and Visualization
- 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
- Exam:
There are three modules for which the database exam is used:- Stand alone (IN4714) for 2 ECTS (40 minutes)
- In combination with Geodatabases (BV470015) for 3 ECTS (+20 minutes)
- In combination with Spatial Databases and Visualization (BV300022) for 6 ECTS (+80 minutes)
Tools
-
Our tools:
-
SQL Games:
-
Downloads:
Material
| Lecture Slides |
|---|
| Lecture Intro |
| Introduction: Databases |
| Modeling/ER-Diagrams |
| Relational Model |
| SQL: Intro + DDL |
| SQL: Queries 1/2 |
| SQL: Queries 2/2 |
| Exercise Sheet | Solution | |
|---|---|---|
| Exercise Sheet 1 | Solution 1 | |
| Exercise Sheet 2 | Solution 2 | |
| Exercise Sheet 3 | Solution 3 | |
| Exercise Sheet 4 |