Aims/Objectives of Lecture: In the framework of the subject, students get acquainted with the theoretical foundations and implementation of database management systems, the database design process, and modern data management methods. Lab: The aim of the training is to apply the theory of relational database management systems in practice, and to introduce SQL through the use of a specific client-server type database management system (Oracle 12g).
Topics: Lecture: Theory and use of the relational model. Anomalies. Normalization. Database design. Data modeling. ER diagram. Relational algebra. Role and use of indexes. Tasks of the database administrator. DDL. DML. DCL. Oracle analytical functions. Database architectures. Database management system structure. Data warehouses. Business intelligence. Laboratory: Basic concepts of relational database design (relations, relational operations), Normalization (0NF, 1NF, 2NF, 3NF), database anomalies. Queries using SQL SELECT statement, join tables, subqueries. DML instructions, database transactions. DDL statements, table creation, data types, constraints, view tables, top-N analysis. Authorization management, DCL instructions. Analytical functions in Oracle12gR2.