Sumários

Session 11

19 novembro 2026, 09:00 • Jesualdo Fernandes

DWH concepts


Session 10

12 novembro 2026, 09:00 • Jesualdo Fernandes

SQL exercises

Lab 2
Correction of the lab


Session 9

5 novembro 2026, 09:00 • Jesualdo Fernandes

Correction of the first lab

Views / Materialized views
Exercises


Session 8

29 outubro 2026, 09:00 • Jesualdo Fernandes

Count dstinct

Sub-Queries (co-related and non-correlated)
Union queries
CASE statement
1st assessment Lab


Session 7

22 outubro 2026, 09:00 • Jesualdo Fernandes

SQL aggregate functions: Group By / Group By Having

Multi-table queries: Equi-Join, Join, LEFT/RIGHT Join, Natural Join, Self Join