Refer to the following markdown file for the respective sections of the class:
Learners will understand:
- Meta queries
- Joining tables
- Unions
- Window functions
- Subqueries
- Common table expressions
Learners will be able to:
- Use meta queries to retrieve information about the database
- Join tables using inner, left, right and full joins
- Use unions to combine data from multiple tables
- Use window functions to calculate aggregates over a set of rows
- Use subqueries to filter data
- Use common table expressions to create temporary tables