Кто читает:: Департамент программной инженерии

Статус:: Курс обязательный

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

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

Бакуров Тимофей Олегович

Брейман Александр Давидович

Корнелюк Егор Кириллович

Матвеева Анна Владимировна

Павлеева Мария Валерьевна

Full Syllabus Ask Question

Abstract

The course attendants should develop skills and understanding in: the design methodology for databases and verifying their structural correctness; implementing databases and applications software in the relational model as well as in map/reduce paradigm; using querying languages, primarily SQL, and other database supporting software; applying the theory behind various database models and query languages; implementing security and integrity policies relating to databases; working in group settings to design and implement database projects.

Learning Objectives

Can design conceptual, logical and physical relational data models.
Can compose queries to relational databases using relational algebra, tuple relational calculus and SQL.
Apply methods of database design, including entity-relationship approach and normalization-based approach.
Knows and is able to apply database application design and development methods usable for object-oriented program systems, including object-relational mappers, its advantages and disadvantages.
May reason on database systems performance based on knowledge models and methods of internal organization of relational databases including file storage, indexing, query processing and transaction management issues.

Expected Learning Outcomes

Able to build conceptual data models
Able to compose SQL queries using set (and bag) operators
Understands the fundamentals of database theory, organization, and applications.
Explains the role of databases in information systems and the fundamental principles of enterprise database management systems.
Describes the current state of database management systems and identifies major trends in their development.
Distinguishes levels of data abstraction and major data models, and explains methods of data organization, retrieval, and processing.
Explains the fundamentals of database theory, organization, and applications.
Creates conceptual database designs using Entity–Relationship (ER) modeling.
Constructs and documents conceptual database models using Entity–Relationship (ER) modeling.
Classifies data integrity constraints and explains methods of enforcing them.
Designs logical schemas for relational databases.
Identifies and explains the normal forms of relational database schemas.
Normalizes relational database schemas.
Applies normalization techniques to design and refine relational database schemas.
Explains the operations of relational algebra.
Classifies query languages and identifies their areas of application.
Describes SQL facilities for data definition (DDL) and data manipulation (DML).
Identifies SQL statements for retrieving, inserting, updating, and deleting data.
Explains how views and stored procedures support data independence and data security.
Selects appropriate index types, creates indexes, and configures them.
Defines database schemas using modern database management systems.
Uses database transactions to perform data operations.
Retrieves and processes data using database cursors.
Develops desktop database applications.
Develops web-based database applications.
Implements Object–Relational Mapping (ORM) in database applications.
Explains physical data storage structures, record formats, and storage organization in database management systems.
Analyzes query execution plans and compares alternative query processing strategies using cost estimates.
Explains distributed and parallel database architectures, data placement strategies, and distributed transaction management.

Course Contents

Introduction into data management
Data Modeling
Database Design: E/R and UML Approaches
Relational Model
Relational Database Design
Relational Query Languages
SQL: Structured Query Language
Application Design and Development
Storage and File Structure
Indexing and Hashing
Query processing
Transaction management
Distributed and parallel databases

Assessment Elements

work on seminars
midterm test
written exam
group project
essay
quiz

Interim Assessment

2026/2027 2nd module
0.07 * essay + 0.21 * work on seminars + 0.07 * quiz + 0.3 * written exam + 0.14 * midterm test + 0.21 * group project

Bibliography

Recommended Core Bibliography

Database systems : design, implementation and management, Rob, P., 2008
NoSQL : новая методология разработки нереляционных баз данных, Садаладж, П. Дж., 2016
PostgreSQL 17 изнутри - Рогов Е. - Издательство "ДМК Пресс" - 978-5-93700-372-0 - 2025 - русский - https://e.lanbook.com/book/514900 - ЛАНЬ - 514900
PostgreSQL. Профессиональный SQL - Е.Моргунов - ДМК Пресс - 9785937003737 - 2025 - русский - https://hse.alpinadigital.ru/document/45388 - Alpina - 45388
PostgreSQL. Профессиональный SQL - Моргунов Е. П. - Издательство "ДМК Пресс" - 978-5-93700-373-7 - 2025 - русский - https://e.lanbook.com/book/514901 - ЛАНЬ - 514901
Маркин, А. В. Базы данных. PostgreSQL : учебник для вузов / А. В. Маркин. — 2-е изд. — Москва : Издательство Юрайт, 2026. — 840 с. — (Высшее образование). — ISBN 978-5-534-22003-2. — Текст : электронный // Образовательная платформа Юрайт [сайт]. — URL: https://urait.ru/bcode/600524 (дата обращения: 02.07.2026).
Проектирование, разработка и использование баз данных в PostgreSQL - Евдошенко О. И. - МИРЭА - Российский технологический университет - 978-5-7339-2574-5 - 2025 - русский - https://e.lanbook.com/book/504835 - ЛАНЬ - 504835

Recommended Additional Bibliography

Big data computing, , 2014
Big data of complex networks, , 2017
Big data. Вся технология в одной книге, Вайгенд, А., 2021
Database Systems, An Application - Oriented Approach : Complete version, 2nd ed., 1235 p., Kifer, M., Bernstein, A., Lewis, P. M., 2006
Privacy and big data, Craig, T., 2011
The Data warehouse lifecycle toolkit : expert methods for designing, developing, and deploying data warehouses, Kimball, R., 1998

Authors

Butskaia Evgeniia Aleksandrovna
Breiman Aleksandr Davidovich

Бакалаврская программа «Прикладной анализ данных»

Контакты

Databases