2025/2026

SQL для анализа данных

Статус: Маго-лего

Кто читает: Департамент бизнес-информатики и операционного менеджмента

Где читается: Санкт-Петербургская школа экономики и менеджмента

Когда читается: 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

• Windows functions in SQL queries
• Common table expressions. Stored procedures and functions
• Nested queries in SQL
• Handling standard data types
• Introduction to SQL
• Development of a Relational Database
• Introduction to Relational Databases

Assessment Elements

• Class participation and assignments
  Assessment takes place during module 2, in the academic period. It is conducted offline with the student presenting completed tasks or functioning code and explaining the logic of solving the problem, if necessary. The volume of completed tasks should correspond to the workload specified in accordance with the work plan of the group.
• Interim exam
  Assessment takes place during module 2, in the academic period. It is conducted offline using PostgreSQL and PgAdmin
• Final exam
  Assessment takes place during the session, module 2. It is conducted offline using PostgreSQL and PgAdmin. This form of control serves as a final exam.

Interim Assessment

• 2025/2026 2nd module
  0.2 * Class participation and assignments + 0.51 * Final exam + 0.29 * Interim exam

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

• Foster, E. C., & Godbole, S. (2014). Database Systems : A Pragmatic Approach. [Berkeley, CA]: Apress. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=933677
• 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

Authors

• Орлова Екатерина Дмитриевна