Sumários
SQL queries with ETL tools
12 outubro 2020, 15:30 • Diogo Ribeiro Ferreira
Examples of SQL queries. Implementing SQL queries as data flow transformations. Design considerations and performance implications. Materialization of the results.
Lab 2
12 outubro 2020, 09:30 • Diogo Ribeiro Ferreira
Exercises about SQL views. Creating a mediated schema based on views.
Introduction to ETL tools
9 outubro 2020, 14:00 • Diogo Ribeiro Ferreira
Working with materialized vs. non-materialized views. Extract-transform-load (ETL) process for a data warehouse. ETL tools. Database connections. Introduction to Pentaho Data Integration.
Introduction to ETL tools
9 outubro 2020, 14:00 • Diogo Ribeiro Ferreira
Working with materialized vs. non-materialized views. Extract-transform-load (ETL) process for a data warehouse. ETL tools. Database connections. Introduction to Pentaho Data Integration.
Lab 2
8 outubro 2020, 11:00 • Diogo Ribeiro Ferreira
Exercises about SQL views. Creating a mediated schema based on views.