Course was designed and taught by Georgiy Korneev at ITMO University in 2021 (year2018, 7th semester).
- Setting up and using DBMS (statements (ru))
- «University» database modeling (statements (ru), solution)
- Functional dependencies in «University» database (statements (ru), solution)
- Normalization of «University» database (statements (ru), solution)
- Relational algebra (statements (ru), solution)
- Relational calculus (statements (ru), solution)
- Modifying data (statements (ru), solution)
- Indexing (statements (ru), solution)
- Stored procedures (statements (ru), solution)
- Transactions (statements (ru), solution)
The course also involves the implementation of the project on the selected topic. Statements (ru) and solution are also available in the repository.
- C.J. Date An Introduction to Database Systems
- J. Widom, J. Ullman A First Course in Database Systems