Master
2023/2024
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:
distance learning
Online hours:
52
Open to:
students of one campus
Instructors:
Margarita Burova
Master’s programme:
Master of Data Science
Language:
English
ECTS credits:
3
Contact hours:
10
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.