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 11
17 Outubro 2024, 12:00 • Jesualdo Fernandes
Correction of Lab 1
SQL SubqueriesCo-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