• 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.

• 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 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)

Attendance is mandatory. Student can miss max. 2 lectures

• 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

• 40% - Homeworks submitted via learn@WU
• 20% - Test
• 25% - Presentation of final project (a small database application)
• 15% - Commitment in class

After the registration deadline, available courses will be allocated to students on the waiting list, who do not yet have a valid registration for the planned position, ranked according to their progress, not to the waiting list.

axel.polleres@wu.ac.at