Database Systems
Semestr: Summer
Range: 2P+2C+4D
Completion:
Credits: 6
Programme type: Bachelor
Study form: Fulltime
Course language: Czech
Summary:
The course is designed as a basic database course mainly aimed at the student ability to design a relational data model and to use the SQL language for data definition as well as for data querying and to choose the appropriate degree of transaction isolation. Students will also get acquainted with the most commonly used indexing techniques, database system architecture and their management. They will verify their knowledge during the elaboration of a continuously submitted seminar task.
Keywords:
Course syllabus:
- Conceptual model
- Relational model
- Functional dependencies
- Integrity constraints, reference integrity, normal forms
- SQL (schema definition), data querying
- Query optimization, indexes
- Stored procedures, triggers
- Object relational mapping, JPA
- Modern trends in database systems
Seminar syllabus:
Literature:
Pokorný J., Valenta M.: Databázové systémy, Nakladatelství ČVUT, Praha, 2013, ISBN 978-80-01-05212-9