Introduction and Overview

Welcome to your first Live event on Data Modelling!

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 Course.

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

When you’re ready, select Next to continue.

Live Event Schedule | DAL4 RS A4.2A |