Datenbanksysteme für Hörer anderer Fachrichtungen
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
- Lecture: Wednesdays, 4.45 - 6.15 p.m. in
lecture hall 0790
(Munich City Campus)
Start: October 18, 2017 - Repeat Exam: Tuesday, September 4th, 2018, 10.30 a.m.
Room: lecture hall N1090 ZG
The exam will be a closed book exam!
Please register on time for the corresponding exam: - 3 ECTS/60 minutes for BV470015, 6 ECTS/120 minutes for BV300022, registration deadline for both July 31 (starting July 1).
- Preparation for the repeat exam, esp. Q&A session: Wednesday, August 8th, 2018, 4 p.m. in lecture hall 0790
Tools
-
MOOCs:
-
Self paced course Databases, Stanford
Datenmanagement mit SQL, HPI (in German)
Database Systems, Uni Saarland (partly in German)
-
Lernenhoch2 (in German)
W3Schools
Documents
-
... will be provided one day before the lecture takes place
18.10.17: Introduction
25.10.17: E/R-Modeling
08.11.17: UML-Modeling
Discussion Ternary - Binary Relationships
15.11.17: Relational Model
Solution sample assignment
22.11.17: Data Definition in SQL
Solution Discussion Personell
29.11.17: Data Retrieval in SQL, part 1
06.12.17: Data Retrieval (and Manipulation) in SQL, part 2
Excercise SQL
13.12.17: Physical Data Organisation
DB-Schema University, DB-Schema University (German)
Solutions SQL excercises
20.12.17: Physical Data Organisation, see 13.12.17
Christmas: SQL Exercises
10.01.18: Transactions
B-Tree excercise
17.01.18: Transactions, see 10.01.18
another B-Tree excercise, solution of another B-Tree excercise
example and excercise SQL self join
24.01.18: Query Execution and New Developments, updated
31.01.18: Summary of the chapters by the students, no warranty: ER/- UML-Modeling, Relational Model, SQL, Indexes, Transactions, Query Execution & New Developments
07.02.18: Mock exam, Solution mock exam