Sumários

Data Warehousing

25 Outubro 2024, 09:00 Eduardo Rodrigues

Introduction to the Data Warehouse concept


Arquitectura de BI

24 Outubro 2024, 12:00 Eduardo Rodrigues

Presentation of BI architecture, its context within IS architecture and its evolution over the years. Main components associated with the concept of Data Platforms


Session 12

18 Outubro 2024, 09:00 Jesualdo Fernandes

SQL Exercises

Transactions
Lab 2


Session 11

17 Outubro 2024, 12:00 Jesualdo Fernandes

Correction of Lab 1
SQL Subqueries
Co-Related and non co-related subqueries


Session 10

11 Outubro 2024, 09:00 Jesualdo Fernandes

SQL:

Exercises: multi-table queries
INNER vs OUTER joins (LEFT JOIN / RIGHT JOIN)
SELF JOINS

1st LAB