Week 7 - Data Manipulation in SQL - Advanced
Subquery, Aggregation, GROUP BY, HAVING, JOIN
Week 7 - Data Manipulation in SQL - Advanced
We’ll continue on Data Manipulation in SQL, and learn how to aggregate and combine data from multiple tables.
Goals
- Use Subquery to retrieve data from one query to use in another
- Aggregate data using GROUP BY and aggregate functions
- Filter aggregated data using HAVING
- Combine data from multiple tables using JOIN
Slides
- Advanced SQL:
Labs
Resources
This post is licensed under CC BY 4.0 by the author.