image
Day 2 PM

Contents

Welcome and Overview
2
Data Modelling

Day 2 PM

Welcome back!

The topics you will cover on the afternoon of the second day are listed below.

Join types

In this session, you will learn what joins are and why they are needed, moving on to join types.

Practise joins

Here you will practise joins in SQL Server by importing a simple set of data.

Joins Exercise

In this session, you will create and populate a theatre database and then perform practical tasks.

Set operators

In this session, you will be introduced to set operators and how they work with multiple queries.

Set operators exercise

In this practical activity, you will create queries using the Northwind database.

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.