Sumários

Session 7

23 Outubro 2025, 09:00 • Jesualdo Fernandes

SQL: 

Joins: Equi-join vs inner join vs Natural Join
Multi-table joins
LEFT/RIGHT joins
Self-Joins
Mock Lab

Session 6

16 Outubro 2025, 09:00 • Jesualdo Fernandes

SQL: 

DDL: Create tables
DML: INSERT, UPDATE, DELETE; Simple select queries in one table.

Session 5

9 Outubro 2025, 09:00 • Jesualdo Fernandes

Project Management Exercise: Relational Schema and Logical Data Diagram.

Introduction to the SQL Client DBeaver (installation and connection configuration)

Session 4

2 Outubro 2025, 09:00 • Jesualdo Fernandes

Transposing to the relational schema of exercises Library and Helpdesk.

Class Diagram for exercise ProjectManagement

Session 3

25 Setembro 2025, 09:00 • Jesualdo Fernandes

Exercise helpdesk - Class Diagram

Transposition of the conceptual model into the Relational Schema