Syllabus
Registration via LPIS
Day | Date | Time | Room |
---|---|---|---|
Friday | 12/04/20 | 08:30 AM - 12:30 PM | Online-Einheit |
Friday | 12/11/20 | 08:30 AM - 12:30 PM | Online-Einheit |
Friday | 12/18/20 | 08:30 AM - 12:30 PM | Online-Einheit |
Friday | 01/15/21 | 08:30 AM - 12:30 PM | Online-Einheit |
Friday | 01/22/21 | 08:30 AM - 12:30 PM | Online-Einheit |
Friday | 01/29/21 | 08:30 AM - 11:00 AM | Online-Einheit |
In this course we will learn to apply Relational Database Management Systems (RDBMS) in practical scenarios, as a basic component of data science data pipelines, and a foundation of multi-user applications. You will learn to interoperate with DBMS from command line, as well as from programming languages (Python, PHP), to rapidly build dashboards for data analysis and implement data persistence.
Basic knowledge of Python is a benefit but not a strong prerequisite, as long as you are ready to learn by working on practical examples.
You will learn the essentce of relationdal data model and Structured Query Language (SQL) in practice.
You can apply databases for data persistence and data manipulation in Python, learn basics of relational data modelling.
You know how to use a relational database in the context of Jupyter Notebooks (Python), to support interactive dashboards, and to prototype web applications.
A combination of frontal instruction and self-learning based on practical assignments. Work in small groups.
Homework 1 | 15 points |
Homework 2 | 15 points |
Homework 3 (Project) | 30 points |
Final test | 15 points |
Participation & continuous evaluation (Q&A, clicker questions) | 25 points |
Total | 100 points |
Back