Week 7 - Advanced SQL 1

Learning Objectives

After today's class, you should be able to:

• Understand how to apply subqueries and correlated subqueries to perform more complex data retrieval, dynamic filtering, and row-level comparisons.
• Learn to use Common Table Expressions (CTEs) to simplify and organize complex SQL queries into clearer, reusable steps.
• Gain hands-on experience with INSERT INTO .. SELECT and UNION/UNION ALL statements to transform raw data from a single stage table into a relational database.

Class Agenda

• Advanced SQL 1 Slides
• In Class Time for CP5 Transform and Load Data

Task List

• Complete and Submit CP5 Transform and Load Data by EOD
• Start working on HW5 Advanced SQL