SQL: Joins & Aggregation

Wishlist Share

About Course

Take your SQL beyond single tables. Learn INNER and LEFT joins, how to combine data from related tables, and how to summarise results with GROUP BY, COUNT, SUM, AVG and HAVING.

This course is an independent introduction for learning purposes. Product menus and features change over time, so check the current official documentation.

What Will You Learn?

  • Understand primary and foreign keys Write INNER and LEFT JOIN queries Summarise data with aggregate functions and GROUP BY Filter groups with HAVING

Course Content

Course Lessons

  • Related Tables
  • INNER & LEFT Joins
  • Aggregation

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕