SQL Server Aggregations

Home/Development, SQL Server/SQL Server Aggregations

SQL Server Aggregations

$15.00 $4.00

Aggregations functions are used to perform calculations on a group of values to return a single value. In this lab, we will look into various basic and advanced aggregations. In the first exercise, we will look into various basic aggregate functions such as SUM, MAX, MIN, COUNT, STDEV, VAR, AVG. In the second exercise, we will learn to perform some advanced aggregations using CUBE and ROLLUP operators. In the third exercise, we will to learn to use GROUPING SETS and GROUPING_ID to perform grouping. In the fourth and final exercise, we will learn to use OVER clause to perform aggregations.

Exercise 1: Introduction to basic aggregate functions
Exercise 2: CUBE and ROLLUP
Exercise 3: GROUPING SETS and GROUPING_ID
Exercise 4: OVER clause

Categories: ,

Description

Aggregations functions are used to perform calculations on a group of values to return a single value. In this lab, we will look into various basic and advanced aggregations. In the first exercise, we will look into various basic aggregate functions such as SUM, MAX, MIN, COUNT, STDEV, VAR, AVG. In the second exercise, we will learn to perform some advanced aggregations using CUBE and ROLLUP operators. In the third exercise, we will to learn to use GROUPING SETS and GROUPING_ID to perform grouping. In the fourth and final exercise, we will learn to use OVER clause to perform aggregations.

Exercise 1: Introduction to basic aggregate functions
Exercise 2: CUBE and ROLLUP
Exercise 3: GROUPING SETS and GROUPING_ID
Exercise 4: OVER clause

Data Platform Virtual Summit 2020

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin.

SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.