Databases

2022/2023

Academic Year

ENG

Instruction in English

5

ECTS credits

Delivered at:

Department of Sociology

Course type:

Elective course

When:

2 year, 3, 4 module

Instructor

Харюков Алексей Сергеевич

Course Syllabus

Abstract

We will cover database theory, characteristics of contemporary DBMS landscape, Relational Algebra, Entity Relationship modeling of different domains, SQL and its dialects, different approaches to data modelling. Course DB project will include group modelling of a complex domain area, design, and implementation of DB for this area, including relationships, triggers, stored procedures, complex queries. Applications of databases to Business Intelligence are also discussed through the course, including the integration of predictive analytics with DBMS and user BI systems. Course BI project will include defining BI goals, setting KPI and designing dashboards for a particular case from different domain areas. Visualization of business metrics and dashboards design will become a special topic of the course, which will allow students to get familiar with the process of data communication. Data-driven dashboards, being one of the most essential parts of Business Intelligence, will be discussed a lot.