Master 2024/2025

SQL

Type: Compulsory course (Master of Data Science)

Area of studies: Applied Mathematics and Informatics

Delivered by: Big Data and Information Retrieval School

Where: Faculty of Computer Science

When: 1 year, 4 module

Mode of studies: offline

Open to: students of one campus

Master’s programme: Master of Data Science

Language: English

ECTS credits: 3

Contact hours: 24

Course Syllabus

Abstract

Nowadays data analysis plays a significant role in business effectiveness. Most of the data sources are relational databases, which may contain lots of records. Successful data scientists should know how to retrieve and manipulate such information. This course consistently introduces students to database management systems, theoretical base of data manipulations, writing simple and complex queries. The course covers essential aspects of data retrieving and processing. Course materials consist mostly of practical tasks and screencasts, allowing students to implement new knowledge in writing queries to one of the most advanced free DBMS - PostgreSQL.