Guide Labs 1 and 2: SQL Review and SQL Views

25 setembro 2018, 14:00 • João Pedro Lebre Magalhães Pereira

Resolution of the laboratory guides 1 and 2:

• SQL Review: recalling the syntax of SQL queries
• SQL Views: how to create and execute SQL views.

Introduction to Data Integration

24 setembro 2018, 15:30 • Helena Galhardas

• Motivating example introducing the notions of: mediated schema, schema matching and mapping, wrappers and data matching
  
• Definition and goals of data integration
• Challenges of data integration
• Generic architecture of data integration
• Virtual data integration:
• wrappers
• mediator
• source descriptions
• Virtual data integration components: query reformulation, query optimiser, query execution engin
• Materialized data integration: data warehouse.

SQL Views

24 setembro 2018, 15:30 • Diogo Ribeiro Ferreira

Base tables and views. Creating views. View schema. Queries over views. Views over views. Query unfolding. Materialized vs. non-materialized views.

Guide Labs 1 and 2: SQL Review and SQL Views

24 setembro 2018, 09:30 • Helena Galhardas

Resolution of the laboratory guides 1 and 2:

A review of SQL

20 setembro 2018, 15:30 • Diogo Ribeiro Ferreira

The employees database. Simple queries. Table joins. Table and column aliases. Sorting and grouping. Grouping and aggregation. Grouping by multiple columns. Group filtering.