Syllabus

Title
5808 Datenbanksysteme
Instructors
Dr. Vadim Savenkov
Contact details
vadim.savenkov@wu.ac.at
Type
PI
Weekly hours
2
Language of instruction
Deutsch
Registration
02/12/19 to 02/26/19
Registration via LPIS
Notes to the course
Subject(s) Bachelor Programs
Database Systems
Dates
Day Date Time Room
Monday 03/18/19 09:00 AM - 12:00 PM D2.-1.019 Workstation-Raum
Monday 03/25/19 09:00 AM - 12:00 PM D2.-1.019 Workstation-Raum
Monday 04/01/19 09:00 AM - 12:00 PM D2.-1.019 Workstation-Raum
Monday 05/06/19 09:00 AM - 12:00 PM D2.-1.019 Workstation-Raum
Monday 05/13/19 09:00 AM - 12:00 PM D2.-1.019 Workstation-Raum
Monday 05/20/19 09:00 AM - 12:00 PM D2.-1.019 Workstation-Raum
Monday 05/27/19 09:00 AM - 12:00 PM D2.-1.019 Workstation-Raum
Monday 06/03/19 09:00 AM - 01:00 PM D2.-1.019 Workstation-Raum
Tuesday 06/11/19 03:00 PM - 04:30 PM TC.3.06
Friday 06/14/19 12:00 PM - 03:00 PM TC.4.02
Friday 06/28/19 03:45 PM - 04:30 PM D2.1.103

On this page:

to top
Contents
  • Theoretical and Practical Aspects of DBMS.
  • Relational Model (basis, relational algebra, data description and data manipulation)
  • Relational Theory (Semantic constraints, functional dependencies, normal forms)
  • Transactions (ACID principle, correctness, parallel processing)
  • Optimization (Indexes, Query Plan)
  • Structured Query Language SQL
  • NoSQL databases (Key-Value stores, document DBs, GraphDBs, Semantic Web triple stores)
  • In-Memory DBs 
  • Big Data, Google BigTable, etc.

to top
Learning outcomes
  • Understanding of DBMS and ability to apply DBMS in practice
  • Understanding of the relational model and the basic concepts of the relational theory
  • Understanding of the basic concepts of transactions and optimizations
  • Ability to formulate SQL statements to solve practical problems
  • Integration of DB and websites (PHP)
  • Basic ideas of non-relational DBs, including graph databases and NoSQL stores
  • Current scalability issues (Big Data)
to top
Attendance requirements

at least 80% attendance

to top
Teaching/learning method(s)
  • Lessons and computer exercises with DBMS on Linux servers
  • Active participation in solving tasks using DBMS
  • Repetitions of lesson content in front of your colleagues
  • Peer Review (review each others’ work)
  • Presentation of a final project
to top
Assessment
  • 40% - Homeworks submitted via learn@WU
  • 20% - Test
  • 25% - Presentation of final project (a small database application)
  • 15% - Commitment in class
to top
Prerequisites for participation and waiting lists

Nach Ende der Anmeldefrist werden verfügbare LV-Plätze den Studierenden der Warteliste, die noch keine gültige Anmeldung zum Planpunkt haben, gereiht nach Studienfortschritt zugeteilt, nicht nach Wartelistenplatz.

to top
Availability of lecturer(s)

vadim.savenkov@wu.ac.at
to top
Additional information on MyLEARN.

 

Last edited: 2018-11-22



Back