Week 6 - Intermediate SQL 2

Learning Objectives

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

• Learn to manipulate and transform data using string functions, CASE statements, and data type conversions.
• Understand how to combine and compare data across tables using UNION/UNION ALL, non-equi joins, and self-joins.
• Gain hands-on experience with CASE statements and joining tables with custom operators with a real database.

Class Agenda

• Intermediate SQL 2 Slides
• [5 min] Break Optional
• CASE and Custom JOINs Demo
• In Class Time for CP4 Intermediate SQL 2

Task List

• Complete and Submit Quiz 4
• Complete and Submit CP4 Intermediate SQL 2 by EOD
• Complete and Submit HW4 Intermediate SQL
• Complete and Submit GP1 Create Database and ERD