Goal: 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).
Course description: 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.
Lecture schedule
Education week Topic
Lecture Laborator
https://nik.uni-obuda.hu/targyleirasok/wp-content/uploads/2024/09/Databases_NIXAB0EBNE_24251.pdf