Sumários
SQL: QUERIES - III and IV
23 Novembro 2021, 16:00 • Ana Paula Pereira Afonso
Aggregate operators. The GROUP BY and HAVING clauses. Examples of aggregate queries.Division operator.
Null values. Comparisons using null values. Logical connectives AND, OR, and NOT. Impact on SQL constructs. Outer joins.
SQL: QUERIES
16 Novembro 2021, 18:00 • Ana Paula Pereira Afonso
Exercises SQL/Data Manipulation Language (DML)
SQL: QUERIES I e II
16 Novembro 2021, 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: QUERIES
16 Novembro 2021, 13:30 • Ana Paula Pereira Afonso
Exercises SQL/Data Manipulation Language (DML)