Master 2024/2025

Data Bases and Data Warehouses

Type: Compulsory course (Master of Data Science)

Delivered by: Big Data and Information Retrieval School

When: 1 year, 3, 4 module

Open to: students of one campus

Language: English

Course Syllabus

Abstract

Students will learn the basic principles of working with database management systems, including PostgreSQL, ClickHouse, and master the skills of connecting to them via Python. The aim of the course is to develop students' competences in data extraction, transformation and aggregation using SQL in various DBMSs such as PostgreSQL, MongoDB, ClickHouse, Redis. Mastering SQL will enable students to successfully solve problems related to data analysis and preparation, and to effectively integrate this process with data analysis in Python.