Syllabus

Title
0875 Database Systems
Instructors
Dr. Vadim Savenkov
Contact details
Type
PI
Weekly hours
2
Language of instruction
Englisch
Registration
09/02/19 to 10/14/19
Registration via LPIS
Notes to the course
Subject(s) Master Programs
Dates
Day Date Time Room
Friday 10/18/19 09:00 AM - 01:00 PM TC.2.01
Friday 10/25/19 09:00 AM - 01:00 PM D5.1.001
Friday 11/08/19 08:30 AM - 12:30 PM D4.0.022
Friday 11/15/19 09:00 AM - 01:00 PM TC.5.15
Friday 11/22/19 09:00 AM - 01:00 PM TC.4.03
Friday 11/29/19 09:00 AM - 01:00 PM TC.4.03
Friday 12/06/19 09:00 AM - 01:00 PM TC.0.01 ERSTE
Friday 12/13/19 10:30 AM - 12:30 PM TC.5.03
Friday 12/20/19 09:00 AM - 01:00 PM TC.1.01 OeNB
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: 2019-04-29



Back