Sumários

Introdução

20 Outubro 2026, 11:00 • Eduardo Rodrigues

Arquitectura de BI


Session 12

16 Outubro 2026, 09:00 • Jesualdo Fernandes

SQL Exercises using sub-queries

Transactions - example.
Assessment - Second LAB

Session 11

13 Outubro 2026, 11:00 • Jesualdo Fernandes

Correction of the first lab

Sub-queries: Correlated and Not Correlated
Union Queries
CASE
Views

Session 10

9 Outubro 2026, 09:00 • Jesualdo Fernandes

SQL Exercises

Lab 1

Session 9

6 Outubro 2026, 11:00 • Jesualdo Fernandes

SQL: 

Equi-Join, Inner-Join, Natural Join
Group by
Multi-Tabler Joins, Outer Join (Left/Right) Self Join, Self Outer Join