• A
  • A
  • A
  • АБВ
  • АБВ
  • АБВ
  • А
  • А
  • А
  • А
  • А
Обычная версия сайта

Бакалаврская программа «Социология и социальная информатика»

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.