Sumários

SQL/DML III

10 Novembro 2020, 16:00 • Ana Paula Pereira Afonso

Aggregate operators. The GROUP BY and HAVING clauses. Examples of aggregate queries. Division operator.

Laboratory class: SQL/DML

10 Novembro 2020, 13:30 • Ana Paula Pereira Afonso

Laboratory class: SQL/DML

SQL/DML

3 Novembro 2020, 18:00 • Ana Paula Pereira Afonso

Exercises SQL/Data Manipulation Language(DML)

SQL/DML I e II

3 Novembro 2020, 16:00 • Ana Paula Pereira Afonso

SQL:Overview, the form of a basic SQL query and examples.Expressions and Strings in the SELECT command.UNION, INTERSECT, and EXCEPT.
Nested queries. Correlated nested queries.Set-comparison operators. Examples of nested queries. 

SQL/DML

3 Novembro 2020, 13:30 • Ana Paula Pereira Afonso

Exercises SQL/Data Manipulation Language(DML)