Sumários

Session 9

6 Novembro 2025, 09:00 • Jesualdo Fernandes

Correction of the first lab

Sub-queries: co-related and non-correlated

Session 8

30 Outubro 2025, 09:00 • Jesualdo Fernandes

SQL: Group By and Having clauses

1st Assessment Lab

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)