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

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

Databases

2017/2018
Учебный год
ENG
Обучение ведется на английском языке
6
Кредиты
Статус:
Курс по выбору
Когда читается:
2-й курс, 1, 2 модуль

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

Course Syllabus

Abstract

We will cover database theory, characteristics of contemporary DBMS landscape, Relational Algebra, ER-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 integration of predictive analytics with DBMS and and-user BI systems Course BI project will include defining BI goals, setting KPI, designing dashboards and predictive analytics models for a particular case from different domain areas.
Learning Objectives

Learning Objectives

  • introduce to database design and querying in different DBMS. Emphasis is both on DB design and on applications of databases to analytical tasks.
Expected Learning Outcomes

Expected Learning Outcomes

  • be able to model different domain areas using ER approach
  • be able to design and implement normalized database structures by creating database tables, queries, triggers, stored procedures, reports, and forms
  • be able to perform typical BI reporting queries using SQL and analytical tools
  • be able to understand applications of BI to decision support in modern companies
  • be able to perform simple integrations of DB and predictive analytics models
  • be able to custom reports and dashboards based on DB data in Tableau and/or Power BI
Course Contents

Course Contents

  • Fundamentals of Databases: Relational Algebra, ER modelling
  • Database Design
  • SQL
  • BI and Databases: Predictive analytics
Assessment Elements

Assessment Elements

  • non-blocking Seminar participation
  • non-blocking Homework
  • non-blocking DB Project + Presentation
  • non-blocking BI Project + Presentation
  • non-blocking Final exam
Interim Assessment

Interim Assessment

  • Interim assessment (2 module)
    0.2 * BI Project + Presentation + 0.2 * DB Project + Presentation + 0.2 * Final exam + 0.2 * Homework + 0.2 * Seminar participation
Bibliography

Bibliography

Recommended Core Bibliography

  • Churcher, C. (2012). Beginning Database Design : From Novice to Professional (Vol. 2nd ed). New York: Apress. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1173722

Recommended Additional Bibliography

  • Laursen, G. H. N., & Thorlund, J. (2016). Business Analytics for Managers : Taking Business Intelligence Beyond Reporting (Vol. Second edition). Hoboken, New Jersey: Wiley. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1367899