Data Management and Python Programming

Introduction

Please note that this is a preliminary course description. The final version will be published in June 2026.

Using available data to gain insights and make correct decisions is becoming essential for almost any business in today’s world. This course introduces two of the most popular and indispensable programming languages for data analysts:

• Python
• SQL

In addition, the course also covers the basics of data management with focus on relational databases.

Course content

• Introduction to programming with Scratch.
• Executing Python code, Jupyter notebooks.
• Variables, basic types, user input and output.
• Control flow (conditional execution, loops).
• Organizing code (functions and libraries).
• Data structures.
• Strings, regular expressions.
• Reading, writing and processing text files.
• Processing and analyzing tabular data with Pandas (reading, cleaning, manipulating, grouping and aggregating data).
• Plotting and visualization (Matplotlib, Seaborn).
• Introduction to relational databases.
• Structured Query Language (SQL).
• Relational model.
• Programming with databases.
• Indexes.
• Transactions.