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.
Here you will find an introduction to this Live event, and a summary of what will be covered on each day.
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.