Syllabus

Title
2383 Database Systems
Instructors
Dr. Vadim Savenkov
Contact details
Type
PI
Weekly hours
2
Language of instruction
Englisch
Registration
10/20/20 to 11/29/20
Registration via LPIS
Notes to the course
Subject(s) Bachelor Programs
Dates
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
Contents

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.

Learning outcomes

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. 

Attendance requirements

Attendance is mandatory. The course is completely online. 

Teaching/learning method(s)

A combination of frontal instruction and self-learning based on practical assignments. Work in small groups. 

Assessment

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

Recommended previous knowledge and skills

Basics of Python programming, PHP programming, HTML, familiarity with Jupyter Notebooks is a plus. 

Last edited: 2020-12-03



Back