Course DBMS

A short introductory course on databases: core concepts, models, and mechanisms.

The value of data. Databases and DBMS as part of data management technologies.
File systems as a precursor to DBMS. Storing information in files versus databases.
DBMS: core concepts, functions, and classification.
Early DBMS: architecture and key ideas. The navigational approach to data processing.
Hierarchical and network data models.
Navigational versus relational approaches to data processing.
History and evolution of relational DBMS
Capabilities of the SQL query language. SQL command categories.
Using SQL to create databases and tables. SQLite specifics.
Aggregate functions and window functions in SQL queries.
Common Table Expressions (CTEs) in SQLite.
Table join types in relational databases using SQL queries.
Defining relationships and constraints in a relational DBMS using SQL
Sorting, grouping, and combining results of SQL queries.
Nested and correlated SQL subqueries.
Using SQL for inserting, updating, and deleting data in tables.
DBMS architectures. Embedded DBMS, file-server and client-server technologies.
Пирамида абстрагирования при работе с данными. Функции и задачи файловой системы и СУБД.
Classification of DBMS by data structuring method.
Classification of data processing tools by task scale. Spreadsheets and different types of DBMS.
Non-relational (NoSQL) databases. Reasons for emergence and types.

Submitting laboratory work through the Pull Request mechanism

1.0. Course Content.

1.1. The role of data and databases.

1.2. Core database concepts. The file system as a precursor to databases

2. First DBMS. Navigational Approach.

3. Relational data model. First relational DBMS.

4. SQL. History and basic features.

5. SQL. Table join types. Subqueries in SQL statements.

6. SQL. Subqueries, analytical queries, and window functions.

7. SQL. Simple and recursive CTEs. SQL topic summary.

4. Файловая система и СУБД. Функции СУБД. Классификация и выбор СУБД.

Assignment Topics

Interactive work with relational databases. Database design. Creating and modifying tables. Inserting, selecting, updating, and deleting data.

Assignment Reporting

Each student has their own repository at https://github.com/andpop-mrsu. In these repositories, the instructor posts laboratory assignment tasks (files task01.md, task02.md, ...), while students submit their project solutions to these assignments (in the corresponding folders Task01, Task02, Task03, ...).
Students do not have write access to these repositories; your files must be submitted there from your personal repositories via the Pull Request mechanism.
An assignment will be considered accepted after the corresponding Pull Request is closed at https://github.com/andpop-mrsu.

When calculating scores, two criteria are taken into account: