Study Plan
This course explains what a database is in the current digital ecosystem (basic concepts, management, etc.). Students review the compound and derivative operations of relational algebra and then discuss two key aspects of design and optimize the relational database model using SQL.
Introduction to Business Intelligence and Database Design
This module presents an introduction to databases, including their definition and a review of their history. Students learn about database management systems and DML, DCL, TCL, and DDL statements. The course also looks at database models and the differences between OLTP and OLAP databases. There is an explanation of the relational model and how it relates to relational algebra and SQL.
SQL Standard
This module covers several aspects of the relational database model. The concept of relational algebra and its relationship with the SQL language is explained. Students explore composite and derived operations and normalization, as well as the process of moving from an entity-relationship model to a relational model. They will look at SQL and how to create and use a relational database, including subqueries and the ANY/ALL statements. The module concludes with examples and practical work to consolidate the concepts.