image
Day 3 AM

Contents

Welcome and Overview
2
Data Modelling

Day 3 AM

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

You’ll begin day three with a recap of has been covered on the previous two days, before moving on to the first practical activity of the day.

Using multiple tables and multiple queries exercise

In this session, you will perform practical tasks involving multiple tables (Joins) and multiple queries (Set operators), using the Northwind database.

Window functions

In this session, you will learn about Window functions and view some window functions examples.

Time series

Here you will discover a useful application of window functions which is to analyse time series data. You will study a blog on the subject and discuss if any part of it can be applied to your job.

When you’re ready, select Next to continue.

Difficulty
Intermediate
Duration
15h 8m
Students
236
Ratings
5/5
starstarstarstarstar
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
38794
Labs
161
Courses
1557
Learning Paths
39

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.