From mastering the SQL language and understanding relational databases, to designing intricate entity-relationship diagrams and crafting advanced SQL queries, this course covers it all. Dive into real-world scenarios, explore privileges management, and unleash the potential of subqueries and advanced database concepts. Join us to transform your data handling skills and become a proficient database manager.
- Teacher: Enikő Nagy
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. 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).
- Introduction, Relational databases and the SQL language
- Foundations of DBMS and DB design
- Database design, E/R Diagram
- E/R to Relational Schema
- Normalization and Constraints
- Simple SQL queries (SELECT, WHERE, ORDER BY statements)
- Single-Row and Group functions (GROUP BY, HAVING), Multiple tables queries (Joins, views)
- DDL, DML, Views
- DCL, privileges management
- Subqueries