Week 5 - Intermediate SQL 1
Learning Objectives
After today's class, you should be able to:
- Learn to summarize and analyze numerical data using aggregate functions, the GROUP BY and HAVING clauses, and understand how differences in RDBMS functionality can affect column alias usage.
- Understand how to combine data from multiple tables using various JOIN types and determine when each is most appropriate based on the analytical goal.
- Gain hands-on experience aggregating data and joining tables with a real database.
Class Agenda
- Intermediate SQL 1 Slides
[5 min]Break Optional- Aggregating Data and JOINs Demo
- In Class Time for CP3 Intermediate SQL 1
Task List
- Submit a list of Group Project names before the end of class. Must be between 3-5 students per group.
- Complete and Submit CP3 Intermediate SQL 1 by EOD
- Start working on HW4 Intermediate SQL
- Start working on GP1 Create Database and ERD