image
Day 2 AM

Day 2 AM

Welcome to the second day of your Live event on Data Modelling.

You’ll begin day two with a recap of has been covered on day one, before moving on to focus on the below topics.

Aggregation

In this session, you will learn about Aggregation functions via which SQL creates totals, averages etc it in the SELECT statement.

Exercise: aggregation

Here, you will perform practical tasks using the Northwind database. You will use basic aggregates, the GROUP BY clause and an ORDER BY and aggregate functions on calculated columns.

Advanced grouping: Rollup, Cube, Grouping Sets

In this session, you will practise advanced aggregation by learning about rollup, cube, and grouping sets.

When you’re ready, select Next to continue.

Difficulty
Intermediate
Duration
15h 8m
Students
401
Ratings
5/5
Description

Here you will find an introduction to this Live event, and a summary of what will be covered on each day.

About the Author
Students
44173
Labs
168
Courses
1754
Learning Paths
45

A world-leading tech and digital skills organization, we help many of the world’s leading companies to build their tech and digital capabilities via our range of world-class training courses, reskilling bootcamps, work-based learning programs, and apprenticeships. We also create bespoke solutions, blending elements to meet specific client needs.