Session 8

16 Outubro 2020, 09:00 • Jesualdo Fernandes

Data Definition Language: Creating tables

1st Assessment Lab

---

Session 7

15 Outubro 2020, 12:00 • Jesualdo Fernandes

Exercises from the dry-run lab

SQL DDL (create table)

 

---

Session 6

2 Outubro 2020, 09:00 • Jesualdo Fernandes

Sub-queries: Correlated vs Non-Correlated

Dry-Run Lab

---

Session 5

1 Outubro 2020, 12:00 • Jesualdo Fernandes

Outer Joins

"Coalesce" function

Sub-queries

---

Session 4

25 Setembro 2020, 09:00 • Jesualdo Fernandes

SQL:

Group BY

Join (Inner Join/Natural Join; Outer Join)

 

---