In this three-day live class guided by your tutor, you will further explore the concepts and techniques you studied during the Discover stage. You will work through a series of discussions, review sessions, and activities.

The content for this Live event is split over three days.

Day 1

Introduction on Diagramming Tools
Data Modelling
Normalisation
Groups of commands in SQL
SQL databases and tables
The Northwind Database
SELECT statement
Common functions

Day 2

Aggregation
Advanced Grouping: Rollup, Cube, Grouping sets
Join types
Set Operators

Day 3

Using joins and set operators
Window functions
Time series
Views

Throughout the Live event, you’ll complete a series of tasks as directed by your tutor, to build your skills.

At the end, you’ll be asked to complete a personal reflection activity, submitting your work to Bud to close off the Learning Path.

Move on to the next section to find out what knowledge and skills will be covered.

When you’re ready, select Next to continue.

Next: Knowledge and Skills

Difficulty

Intermediate

Duration

15h 8m

Students

194

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

Training Provider

Students

32159

Labs

144

Courses

1508

Learning Paths

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.

Contents

Welcome and Overview

Data Modelling

Introduction and Overview