Sumários

Analytical data models

5 Março 2026, 14:00 • PATRICIA ALEXANDRA LAGARTO MARTINS

Business intelligence and data warehousing, OLTP and OLAP systems, dimensional modeling, and Inmon and Kimball approaches 

Class exercise.

Structured Query Language (SQL): DML

26 Fevereiro 2026, 13:30 • PATRICIA ALEXANDRA LAGARTO MARTINS

SQL data manipulation language (DML) commands for querying data


PostgreSQL application.

Class exercise.

Structured Query Language (SQL): DDL

19 Fevereiro 2026, 13:30 • PATRICIA ALEXANDRA LAGARTO MARTINS


 

The relational model

12 Fevereiro 2026, 13:30 • PATRICIA ALEXANDRA LAGARTO MARTINS

The relational model, mapping the ER to the relational model, and database operations on relational model.


Class exercise.

Data models and modeling

5 Fevereiro 2026, 13:30 • PATRICIA ALEXANDRA LAGARTO MARTINS

Data models, the Entity Relationship Model (ERM).


Class exercise.