Master 2021/2022

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, 2 module

Mode of studies: distance learning

Open to: students of one campus

Master’s programme: Master of Data Science

Language: English

ECTS credits: 5

Contact hours: 8

Course Syllabus

Abstract

Course objectives: · To introduce future data analysts to a relations data source · To teach students how to use the language tools of modern DBMS to extract and prepare data Practical skills: · Building SQL queries in a PostgreSQL database · Preparing analytical reports on relational databases · Data preparation for further analysis · Retrieving data from DB at the application level (e.g. with Python) Pre-requisites: · Beginner programming skills · Basic knowledge of discrete mathematics (working with sets) Other information: · Students will learn to write SQL queries for several different databases · The course includes three parts: theoretical foundation for data manipulation, the key features of SQL language, and SQL application for solving practical tasks.