Assuming familiarity with basic data management and storage techniques (such as ER models and SQL), which – if needed – will be repeated in a bridging course, this course shall teach you essentials of data management and analytics, from the concepts to their application on practical examples (for example applied to Web data but also to business scenarios). 

Part A of the course will focus on advanced databases, storage and data management techniques, analytical queries using SQL and Relational Database Management Systems, but also discuss Document and GraphDatabases. Next, we will discuss how to make certain tasks scale with big data (i.e. high volume, high velocity or highly heterogeneous data). To this end, we will review traditional indexing techniques and methods to deal with concurrent data access and discuss trends in Data Management and Storage. 

In Part B, we will cover (Descriptive, Predictive and Prescriptive Analytics) Data Analytics techniques and discuss how these can be scaled.

According to the examination regulation full attendance is intended for a PI. Attendance of 80% of all classes is compulsory

• Each of the classes will be accompanied by one or more interactive Jupyter Notebook(s) that should be prepared in groups before class and that we will walk through together in class,
  • final notebooks to be submitted after each class as documentation of in-class participation, max 3% per class, the worst result can be discarded, i.e. max. 30% for in-class work.
  • for those presenting their solutions in class to the others, there is maximum of 3 bonus points throughout the semester achievable on top.
• "Mastery" path: 10% of the points can be achieved by extra notebooks per class that will require additional reading.
• Each class will additionally have up to 3 clicker quiz questions per class (max. 2% each class, the worst result can be discarded, i.e. max. 20% for quizzes)
• plus two individualised exams (20% each, i.e. 40%) for Part A and Part B:
  • Part A will be an in-class exam in the last week of the course,
  • Part B will be a take-home exam in the form of a small individual project.

Grading Scheme:

>= 90% ... Excellent (1)

>= 80% ... Good (2)

>= 70% ... Satisfacory (3)

>= 60% ... Sufficient (4)

 <  60% ... Fail