Магистратура
2026/2027




SQL для анализа данных
ID 1163139
Статус:
Курс по выбору (Аналитика данных для бизнеса и экономики)
Где читается:
Санкт-Петербургская школа экономики и менеджмента
Когда читается:
1-й курс, 2 модуль
Охват аудитории:
для своего кампуса
Преподаватели:
Алексеев Антон Дмитриевич
Язык:
английский
Кредиты:
3
Контактные часы:
28
Course Syllabus
Abstract
The course focuses on studying the relational data model and the capabilities of the SQL language, developing skills in using SQL to analyze data that are organized in accordance with the relational data model. Based on the results of studying the discipline, students will have the skills to develop relational databases and write queries in SQL to solve applied data analysis problems.
Learning Objectives
- ● Attain knowledge regarding the capabilities of SQL standards within the context of relational database management systems (RDBMS).
- ● Develop proficiency in designing databases that adhere to the principles of the relational data model.
- ● Acquire skills in conducting data analysis through the use of SQL queries.
Expected Learning Outcomes
- ● Ability to design and create data structures for well-defined problem domains in accordance with the classical relational data model.
- ● Ability to write queries for inserting and modifying data in relational databases.
- ● Proficiency in writing queries involving data filtering conditions, combining data from multiple tables and aggregating data.
- ● Competence in writing stored procedures and functions in the SQL language.
Course Contents
- Introduction to Relational Databases
- Development of a Relational Database
- Introduction to SQL
- Handling standard data types
- Nested queries in SQL
- Common table expressions. Stored procedures and functions
- Handling complex data types
- Windows functions in SQL queries
Assessment Elements
- Midtermmidterm covers topics 1–5 and contains open‑ended questions and tasks. 80 minutes are allocated for the midterm. The midterm grade is calculated as the sum of the points for the tasks.
- ExamThe exam consists of tasks related to working with a PostgreSQL database. There are 7 tasks in total, of which 4 tasks are worth a maximum of 1 point each, and 3 tasks are worth 2 points each. The exam is allocated 80 minutes. The exam grade is calculated as the sum of the points for the tasks.
- Ongoing monitoring of work at seminarsAn offline test is conducted with tasks based on the material that has been studied.
Interim Assessment
- 2026/2027 2nd module0.3 * Midterm + 0.2 * Ongoing monitoring of work at seminars + 0.5 * Exam