Sumários
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
Session 6
15 Outubro 2026, 09:00 • Jesualdo Fernandes
Introduction to SQL language
Installation and configuration of the SQL client software
DDL commands: Create Table
DML commands: Insert, Update, Delete, Select on single table.
Where conditions
Session 5
8 Outubro 2026, 09:00 • Jesualdo Fernandes
Project Management Exercise:
Conceptual Model - Class Diagram
Logical model - Relational Schema and Logical Data Diagram
Session 4
1 Outubro 2026, 09:00 • Jesualdo Fernandes
Helpdesk Exercise:
Conceptual Model - Class Diagram
Logical model - Relational Schema and Logical Data Diagram
Sessão 3
24 Setembro 2026, 09:00 • Jesualdo Fernandes
Rules of transposition from the Class Diagram to the Relational Schema
Logical Data Model representation
Library Exercise - Relational Schema
Library Exercise - Logical Data Model