Database Systems are a long standing pillar of any modern IT System, and the key to store, exchange and query data. In this course you will learn about foundations of Database Systems and how to effectively use and manage them in practical contexts. You will both learn about data models and developing schemas within a relational database systems, as well as complex queries. Last, but not least you will learn about query optimization and indexing as well as techniques for concurrency control and transaction management, which make database systems scale not only to large amounts of data but also large numbers of concurrent users. As a final recent topic, we will treat database management systems in the cloud and so called NoSQL databases (such as Graph Database System and Document Store)

Topics:

• Entity-Relationship Model
• Relational Model
• Advanced uses of SQL (Structured Query Language)
• Query Optimization, Transaction Management
• Advanced Database Systems beyond SQL & RDBMS:
  • NoSQL Databases
  • Graph Databases
  • Databases in the cloud

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

- understand physical query execution, and ways to optimize queries through indexes

- understand challenges of concurrency and transaction management

- understand limitations of traditional Relational Database Management Systems and approaches to overcome those

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

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

Online Clicker/Quiz Questions (up to 20%  in total) throughout the classes (the initial Clicker/Quiz questions in the first class serve mainly to assess prior knowledge - if you don't know the answers, don't worry: You can make up for missed points during the rest of the course!)

Four obligatory homeworks in groups of 2 (40%)

Final written exam (40%)

You will need 60% to pass the course, i.e.:

>=90%  Sehr Gut (1)

>= 80% Gut (2)

>= 70% Befridigend (3)

>= 60% Genügend (4)

We assume basicfamiliarity with SQL and ER Modeling, and will mostly repeat these only, quickly diving into more advanced topics.

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