Course details

MySQL: Grouping & Aggregation Operations

MySQL: Grouping & Aggregation Operations


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Explore how grouping and aggregation operators can be used to analyze groups of rows rather than just individual rows and also, how filtering operations can be performed on such groups.



Expected Duration (hours)
1.0

Lesson Objectives

MySQL: Grouping & Aggregation Operations

  • 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
  • Course Number:
    it_aplumgdj_05_enus

    Expertise Level
    Intermediate