MySQL: Grouping & Aggregation Operations

MySQL 8:0    |    Intermediate
  • 8 videos | 57m 26s
  • Includes Assessment
  • Earns a Badge
Likes 138 Likes 138
Learners can explore how to use grouping and aggregation operators to analyze groups of rows rather than just individual rows, in this 8-video course. In it you will learn how to perform filtering operations on groups of rows. Then examine the GROUP BY clause, one of the most important syntactic constructs in SQL. You will learn how to use the GROUP BY clause to analyze groups of rows aggregated by common attribute values. Next, learn about aggregate functions such as SUM, COUNT, MIN, and MAX, and how they are used with GROUP BY clauses. You will learn how subqueries can be leveraged by using the ANY, SOME, and ALL keywords. You will learn how to implement multi-way joins in MySQL, and how the HAVING clause adds to the effectiveness of the GROUP BY construct by allowing groups of rows to be filtered based on specific conditions. Finally, this course explains the differences between the WHERE clause and the HAVING clause, which applies conditional filters to groups of rows rather than to individual rows.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    prepare a small but meaningful relation that can be used to work with data aggregation operators
    use the DISTINCT keyword as well as the GROUP BY clause to identify duplicates and cardinality
    use the GROUP BY clause with important common aggregation functions such as SUM, COUNT, MIN, MAX
  • use the HAVING keyword along with the GROUP BY clause to apply filters to aggregates
    use the SOME, ALL, and ANY keywords to link subqueries to outer queries
    implement joins with more than two relations in MySQL
    Course Summary

IN THIS COURSE

  • Playable
    1.  Course Overview
    1m 47s
  • Playable
    2.  Data Setup
    9m 9s
    In this video, you will prepare a small but meaningful relation that can be used with data aggregation operators. FREE ACCESS
  • Locked
    3.  Unique Values
    9m 10s
    During this video, you will learn how to use the DISTINCT keyword and the GROUP BY clause to identify duplicates and cardinality. FREE ACCESS
  • Locked
    4.  Aggregate Functions
    8m 48s
    In this video, find out how to use the GROUP BY clause with important common aggregation functions such as SUM, COUNT, MIN, and MAX. FREE ACCESS
  • Locked
    5.  Filtering Aggregates
    8m 46s
    Learn how to use the HAVING keyword with the GROUP BY clause to apply filters to aggregates. FREE ACCESS
  • Locked
    6.  Subqueries and Aggregates
    9m 10s
    In this video, you will use the SOME, ALL, and ANY keywords to link subqueries to outer queries. FREE ACCESS
  • Locked
    7.  Three-way Joins
    9m 31s
    In this video, you will learn how to implement joins with more than two relations in MySQL. FREE ACCESS
  • Locked
    8.  Course Summary
    1m 5s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 278 Likes 278  
Likes 57 Likes 57  
Likes 248 Likes 248