Бакалавриат
2022/2023
Базы данных
Лучший по критерию «Полезность курса для Вашей будущей карьеры»
Статус:
Курс обязательный (Прикладной анализ данных)
Направление:
01.03.02. Прикладная математика и информатика
Кто читает:
Департамент программной инженерии
Где читается:
Факультет компьютерных наук
Когда читается:
3-й курс, 1, 2 модуль
Формат изучения:
с онлайн-курсом
Онлайн-часы:
10
Охват аудитории:
для своего кампуса
Язык:
английский
Кредиты:
5
Контактные часы:
80
Course Syllabus
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
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
Interim Assessment
- 2022/2023 2nd module0.14 * work on seminars + 0.28 * group project + 0.07 * quiz + 0.07 * midterm test + 0.14 * essay + 0.3 * written exam
Bibliography
Recommended Core Bibliography
- Big data of complex networks, , 2017
- Big data. Вся технология в одной книге, Вайгенд, А., 2021
- Database systems : design, implementation and management, Rob, P., 2008
- NoSQL : новая методология разработки нереляционных баз данных, Садаладж, П. Дж., 2016
Recommended Additional Bibliography
- Big data computing, , 2014
- 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