SQL for Data Analysis

2025/2026

Учебный год

ENG

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

3

Кредиты

Кто читает:

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

Статус:

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

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

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

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

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

Course Syllabus

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
• Project 2: SELECT, JOIN, GROUP BY
• Project 3: BI Project

Interim Assessment

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

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

• DYMOVA POLINA MAKSIMOVNA