Syllabus

Title
6108 Database Systems
Instructors
Dr. Javier David Fernandez Garcia, Dr. Vadim Savenkov
Contact details
Type
PI
Weekly hours
2
Language of instruction
Englisch
Registration
02/05/19 to 02/26/19
Registration via LPIS
Notes to the course
Subject(s) Master Programs
Dates
Day Date Time Room
Friday 03/01/19 09:00 AM - 01:00 PM D2.0.030
Friday 03/08/19 09:00 AM - 01:00 PM D2.0.030
Friday 03/22/19 09:00 AM - 01:00 PM D2.0.030
Friday 03/29/19 09:00 AM - 11:00 AM D2.0.030
Friday 04/05/19 09:00 AM - 01:00 PM D2.0.030
Friday 04/12/19 09:00 AM - 01:00 PM D2.0.030
Friday 05/03/19 09:00 AM - 01:00 PM D2.0.030
Friday 05/10/19 09:00 AM - 11:00 AM D2.0.030
Thursday 05/16/19 02:00 PM - 05:00 PM TC.2.01
Tuesday 06/25/19 05:00 PM - 06:00 PM D2.1.103
Friday 06/28/19 01:00 PM - 01:45 PM D2.1.103
Contents

Entity-Relationship Model

Relational Model

SQL Structured Query Language

Advanced Database Systems beyond SQL & RDBMS:

  • NoSQL Databases
  • Graph Databases
  • Processing Streams & Complex events

 

Learning outcomes

Understand concepts of DBMS and apply in practical problems

- understand Entity-Relationship Model and apply in practical problems

- understand Relational Model and execute transition from ERM to RM

- understand SQL Structured Query Language and formulate queries to solve practical problems in a programmatic environment
Attendance requirements

According to the examination regulation full attendance is intended for a PI.

Teaching/learning method(s)

Lecture and practical exercises on the PC using different practical Database systems on Linux

Active participation by solving problems using Relational DBMS and advancd Database Systems

Assessment

Initial test in the end of the first class (5%) 

Three obligatory homeworks (35%)

Final written exam (60%)

Other

Please note that this will be a course with just seven classes, so unregistering after the course start will not be possible. A small graded test will be given at the end of the first class.

Last edited: 2018-11-26



Back