Aggregating Data with SQL
Learning Outcomes
Get More Info
data, Tech & ai skills in
What’s Included
Course Introduction
Course Introduction
In this lesson, we learn about the concepts of data granularity and data aggregation. We also get a brief summary of what we cover in this course.
The SUM Function
The SUM Function
In this lesson, we learn how to use the SUM function to add all the values in a numeric column of data.
The COUNT Function
The COUNT Function
In this lesson, we use the COUNT function to count the number of non null values in a column. We also use it to calculate proportions.
More Aggregate Functions
More Aggregate Functions
In this lesson we use the AVG function to calculate the average value of a numeric column. We also use the MIN and MAX functions to find the lowest and highest value in a column.
Grouping Aggregated Data
Grouping Aggregated Data
In this lesson, we use the GROUP BY section to break down our aggregated data according to another specified field
Filtering Aggregated Data with HAVING
Filtering Aggregated Data with HAVING
In this lesson, we learn how to apply filters to our data based on an aggregated field.
Windows Functions
Windows Functions
A window function performs a calculation across a set of table rows that are somehow related to the current row. These can often be used as a quicker and simpler alternative to a CTE or Subquery.
Certifications
A Learner Experience Designed to Deliver Transformation
How Leading Teams Use Kubicle to Upskill & Excel
