1.5 SQL Advanced

Dependencies

Refer to the following markdown file for the respective sections of the class:

• Self Studies
• Lesson
• Assignment
• Quiz
• Reference

Lesson Objectives

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

Lesson Plan

Duration	What	How or Why
- 5mins	Start zoom session	So that learners can join early and start class on time.
30 mins	Activity	Recap on self-study and prework materials.
30 mins	Code-along	Use meta queries. Introduction to joins.
	1 HR MARK
45 mins	Code-along	Use joins and unions to combine data from multiple tables.
15 mins	Break
	2 HR MARK
45 mins	Code-along	Use window functions to calculate aggregates over a set of rows. Use subqueries to filter data. Use common table expressions to create temporary tables.
15 mins	Briefing / Q&A	Brief on references, assignment, quiz and Q&A.
	END CLASS 3 HR MARK