Sumários
24 Outubro 2024, 09:00
•
Jesualdo Fernandes
SQL
Group by
Multi-table joins: EQUI-JOIN, INNER JOIN, LEFT/RIGHT JOIN; NATURAL JOIN
17 Outubro 2024, 09:00
•
Jesualdo Fernandes
SQL:
DDL (Create Table)
DML (Insert / Update / Delete)
DML Select statements: Select from a single table with Where conditions
10 Outubro 2024, 09:00
•
Jesualdo Fernandes
Data modeling exercise: Project Planning (Class Diagram + Relational Schema)
Installation and configuration of the SQL client software
3 Outubro 2024, 09:00
•
Jesualdo Fernandes
Data Modeling exercises:
Helpdesk exercise Class Diagram and Relational Schema
26 Setembro 2024, 09:00
•
Jesualdo Fernandes
Finish class Diagram for Library exercise.
Rules to transform the class diagram into a relational schema
Relational schema for the Library exercise
Logical diagram for the Library exercise (to be completed as homework)