Skip to main content
Joining and Aggregating Data

Aggregating Data with SQL

Gain useful insights from the data in your database. In this course you will explore the different options in SQL for grouping, aggregating and performing calculations on your data.

Intermediate        7 Lessons        90 Minutes        CPD Credits
TRY FOR FREEEXPLORE OUR LIBRARY

About This Course

With the basics covered, it’s time to start asking proper questions of your database using SQL. In this course, you will discover that, by adding simple operators, you can vastly improve the analytical potential of your SQL queries.

You will drill down into your database, using operators like SUM, AVG, MIN and MAX. You will calculate the average value of a numerical column and use the COUNT function on a number of records. You will also explore some of SQL’s more advanced options for filtering your results.

By the end of this course, you will feel confident incorporating advanced calculations into your SQL queries to gain useful, informative insights from your data.

GET STARTED

Learning Outcomes

  • Understand data granularity and aggregation
  • Sum data
  • Get the average of a set of data
  • Get a count for number of records
  • Group aggregated data
  • Filter using aggregated data

Lessons

1. Course Introduction
2. The SUM Function
3. The COUNT Function
4. More Aggregate Functions
5. Grouping Aggregated Data
6. Filtering Aggregated Data with HAVING

Read More

7. Windows Functions
Learning Certificates

Showcase Your Skills

Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.

When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Become A Data Citizen

Ready yourself for the rapidly changing world