Master
2021/2022
SQL
Type:
Compulsory course
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
Online hours:
82
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.