Specialist
2024/2025
Database Management Systems
Type:
Compulsory course (Cyber Security)
Delivered by:
School of Applied Mathematics
When:
4 year, 2, 3 module
Mode of studies:
offline
Open to:
students of one campus
Area of studies:
Cyber Security
Language:
English
ECTS credits:
3
Contact hours:
42
Course Syllabus
Abstract
This course provides a comprehensive overview of database systems. Students will learn the fundamentals of data access and file systems, including hierarchical, network, re-lational and object oriented data models. The course will cover the elements of relational database design, data query languages, services such as data protection and integrity con-trol, and database management. This course include modern technologies in DBMS area. The course will provide a balance of theory and practical application and will culminate in a database implementation project conducted by individual or teams of students. The course covers: • Basic principles and elements of relational database design. • Practical tasks for relational database design: CASE-tools – AllFusion Data Modeler (ERWin) • Relational algebra. • Data query languages (SQL). • SQL transaction processing. • RDBMS services: data protection, integrity control and another functions. • Features of the modern RDBMS, NoSQL DBMS.
In addition, this program covers the use of artificial intelligence in database management systems.