Datenbanksysteme für Hörer anderer Fachrichtungen

• Dr. Angelika Reiser

Information

This course is after all held in German!

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

• Lecture: Wednesdays, 4.45 - 6.15 p.m. in lecture hall 0790 (Munich City Campus)
  Start: October 19, 2016
• Exam: Friday, March 10th 2017, 9.00 am, lecture hall N1080 ZG
  The exam will be a closed book exam!
  Please register on time for the corresponding exam (2 ECTS/40 minutes for IN4714, 3 ECTS/60 minutes for BV470015, 6 ECTS/120 minutes for BV300022).
• Repeat exam: Wednesday, August 30, 2017, 10.00 am in room 2710

Tools

MOOCs:
Self paced course Databases, Stanford
Datenmanagement mit SQL, HPI (in German)
Database Systems, Uni Saarland (partly in German)
SQL Tutorials:
Lernenhoch2 (in German)
W3Schools
SQL Web Interfaces:
HyPer
SQL Fiddle
Animation Programs:
B-Trees
B+ Trees

Documents

see German web page