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
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.
Understand data granularity and aggregation
Get the average of a set of data
Get a count for number of records
Group aggregated data
Filter using aggregated data