1. Home
  2. Training Library
  3. Live Event Schedule | DAL4 RS A4.2|

Live Event Schedule | DAL4 RS A4.2|

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 learning path.

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

Difficulty
Intermediate
Duration
15h 8m
Students
2
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
21346
Labs
107
Courses
774
Learning Paths
43

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.