Sumários

Session 12

21 Outubro 2022, 09:00 • Jesualdo Fernandes

SQL Exercises

2nd Lab

Session 11

20 Outubro 2022, 12:00 • Jesualdo Fernandes

Correction of the 1st Lab.

Sub-Queries: What are they, where can we use them.

Co-related vs Non co-related sub-queries

Examples


Sessio 10

14 Outubro 2022, 09:00 • Jesualdo Fernandes

SQL Exercises

Lab 1

Session 9

13 Outubro 2022, 12:00 • Jesualdo Fernandes

SQL - starting with slide 45

SQL Joins (Inner, Left Outer, Right Outer)

SQL Exercises

Session 8

7 Outubro 2022, 09:00 • Jesualdo Fernandes

SQL presentation and practice:

Simple join, where clause, group by clause, having, order by.