Description

Theory
1

Laboratory
2

Instructors

Rosa Reis

Contents

CP1 - Database general concepts;
CP2 - Relational Database Design: Relational Model; Relationships, Primary keys; Foreign Keys and Integrity Constraints;
CP3 - Structured Query Language (SQL): DDL (Data Definition Language); DML (Data Manipulation Language);
CP4 - Introduction to data warehouses: Main characteristics; Data Mart; General view of dimensional model; Kinds of schema;
CP5 - Dimensional Data Modelling: Star schema model; Dimension tables; Fact tables; Kind of facts ; Slowly changing dimensions; Modelling techniques;
CP6 - Data Warehouse Architectures; Corporate Information Factory; BUS architecture; Comparison between architectures;
CP7 - Extraction, Transformation, Cleaning and Loading Process;
CP8 - On-Line Analytical Processing: Kinds of analytical databases; Basic operations; Pivot tables;

Learning Outcomes

The student should be able to:
C01. Understand the fundamentals of database management systems(DBMS), with particular emphasis on relational databases;
C02. Acquire and consolidate knowledge on system modeling, including data modeling;
C03. Acquire knowledge to solve problems by constructing database queries using SQL (Structured Query Language);
C04. Design a database for a project, taking in account functional requirements, constraints and construction of database queries;
CO5. Describe the terminology and concepts used in the field of data warehouses;
C06. Explain a data warehouse architecture and, specifically, the purpose of its components;
C07. Apply methods that support the analysis, modelling, design and implementation of data warehouses;
C08. Combine techniques that support to perform an extraction, transformation, cleaning, integration, and load processes in a data warehouse.