Course
|
SQL
Joining Data with SQL
This course focuses on the various different join methods in SQL, such as inner joins, left and right joins as well as full outer joins.
2 HOURS
Intermediate
7 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Understand types of joins
Perform left & right joins
Perform full joins
Leave your number for the fastest response
Get More Info
Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
helping to build
data, Tech & ai skills in
data, Tech & ai skills in
What’s Included
7 Lessons
Course Introduction
2 MINS
LESSON
Course Introduction
Exercise
In this lesson, we cover the structure of the course.
Types of SQL Joins
5 MINS
LESSON
Types of SQL Joins
Exercise
In this lesson, we explore the various types of joins from a conceptual level before building them in SQL code.
Inner Joins
5 MINS
LESSON
Inner Joins
Exercise
In this lesson, we review the use cases of inner joins and how to create them in SQL.
Full Outer Joins
5 MINS
LESSON
Full Outer Joins
Exercise
This lesson covers how to join two datasets without losing any unmatched rows of data.
Full Left/Right Joins
3 MINS
LESSON
Full Left/Right Joins
Exercise
This lesson covers how to create a join that excludes unmatched data from just one of the two datasets.
Outer Left/Right Joins
5 MINS
LESSON
Outer Left/Right Joins
Exercise
In this lesson, we learn how to exclude all data from a join except the unmatched rows from just one of the datasets.
Self Joins
5 MINS
LESSON
Self Joins
Exercise
In this lesson, we learn how to join a dataset onto itself and why that can be useful.
LESSON
Exercise
LESSON
Exercise
LESSON
Exercise
LESSON
Exercise
LESSON
Exercise
Certifications
Earn a certificate with every exam you complete. All successful course completions are recognized by CPD, CPE, and NASBA. As your team gains confidence, skill, and speed, your firm becomes more competitive.
Earn cPE / CPD Credits
No items found.
THE PLATFORM OF CHOICE FOR 1M+ USERS
A Learner Experience Designed to Deliver Transformation
Testimonials
How Leading Teams Use Kubicle to Upskill & Excel
