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

Статус:: Курс по выбору

Когда читается:: 2-й курс, 1 модуль

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

Ляпин Илья Викторович

Full Syllabus Ask Question

Abstract

The course is aimed at students who are pursuing a career of analysts, data scientists and other IT-oriented positions. The scope of the course is limited to relational databases. Upon finishing this course students should be familiar with relational database concept, be able to write simple/advanced SQL queries and apply the knowledge in the field of BI.

Learning Objectives

To introduce the principles of relational database systems.
To develop practical skills in writing SQL queries for data retrieval and manipula- tion.
To familiarize students with database design and normalization concepts.
To prepare students for analytical and professional use of SQL in real-world projects.
To make acquaintance with BI systems

Expected Learning Outcomes

Understand the architecture and functionality of relational DBMS.
Write efficient SQL queries using SELECT, JOIN, GROUP BY, and subqueries.
Perform data modification operations (INSERT, UPDATE, DELETE).
Apply constraints, indexes, and basic optimization techniques.
Use SQL for analytical tasks and reporting.
Use basic window functions for advanced queries.

Course Contents

Introduction to Databases and DBMS
Relational Model and Database Design
Data Definition Language (DDL)
Data Manipulation Language (DML)
Joins and Subqueries
Aggregation and Window Functions
Indexes and Query Optimization
Analytical SQL and Use Cases

Assessment Elements

Project 1: Database design
The student defines a coherent analytical domain, designs an entity–relationship model, converts it into a normalized PostgreSQL schema, implements the schema in SQL, and loads sufficient test or source data to demonstrate that the model works.
Project 2: SELECT, JOIN, GROUP BY
Using the database developed in Project 1, the student produces a coherent analytical brief supported by a purposeful set of SQL queries. The work must go beyond syntax demonstrations: the queries should answer substantive questions and the written interpretation should distinguish evidence from speculation.
Project 3: BI Project
The student develops a decision-oriented business intelligence product based on the project database and analytical SQL. The dashboard must be designed for a specified user and decision context, present trustworthy indicators, allow useful exploration, and communicate a concise analytical story rather than a collection of unrelated charts.

Interim Assessment

2026/2027 1st module
0.4 * Project 2: SELECT, JOIN, GROUP BY + 0.4 * Project 3: BI Project + 0.2 * Project 1: Database design

Bibliography

Recommended Core Bibliography

Rockoff, L. (2017). The Language of SQL (Vol. Second edition). Hoboken, NJ: Addison-Wesley Professional. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1601663

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

Authors

LYAPIN ILYA VIKTOROVICH

Магистерская программа «Анализ данных для государства и общества»

Контакты

Контакт-центр

SQL for Data Analysis