Databases

2022/2023

Учебный год

ENG

Обучение ведется на английском языке

5

Кредиты

Кто читает:

Департамент социологии

Статус:

Курс по выбору

Когда читается:

2-й курс, 3, 4 модуль

Преподаватель

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

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.