• A
  • A
  • A
  • ABC
  • ABC
  • ABC
  • А
  • А
  • А
  • А
  • А
Regular version of the site
For visually-impairedFor visually-impairedUser profile (HSE staff only)Search
Advanced search
Menu
HSE University
User profile (HSE staff only)Search
Advanced search

Course Syllabus

Bachelor 2017/2018

Databases

Category 'Best Course for Career Development'
Category 'Best Course for New Knowledge and Skills'
Type: Elective course (Sociology and Social Informatics)
Area of studies: Sociology
Delivered by: Department of Sociology
Where: Saint-Petersburg School of Social Sciences
When: 2 year, 1, 2 module
Mode of studies: offline
Instructors: Ilya Musabirov
Language: English
ECTS credits: 6
Contact hours: 70

Course Syllabus

Full 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