Sumários

A review of SQL and SQL Views

19 setembro 2019, 14:00 • Helena Galhardas

Review of SQL: 

  • The employees database. Simple queries. Table joins. Table and column aliases. Sorting and grouping. Grouping and aggregation. Grouping by multiple columns. Group filtering.
SQL Views: 
  • Definition of SQL View. View unfolding. Non-materialized and materialized views.

No lab classes

19 setembro 2019, 11:00 • Helena Galhardas

Lab classes start on September 23rd.

No lab classes

17 setembro 2019, 15:30 • Helena Galhardas

Lab classes start on September 23rd.

No lab classes

17 setembro 2019, 14:00 • Helena Galhardas

Lab classes start on September 23rd.

Welcome Presentation

16 setembro 2019, 15:30 • Helena Galhardas

  • Topics
  • Instructors
  • Evaluation
    • Project
    • Exam
  • Bibliography
  • Software tools