Skip to main content
Joining and Aggregating Data

Joining Data with SQL

It is almost inevitable, when working with databases, that you will need to query more than one table. This course explores the different options for joining separate tables in SQL, how you can bring together separate elements of your database to significantly boost the speed and simplicity of your data analysis.

Intermediate        7 Lessons        90 Minutes        CPD Credits
Start Today

About This Course

The concept of joining tables is straightforward, however, understanding the different types of joins can be tricky. In this course, you will explore the different options for joining tables in SQL.

You will examine the different types of join available in SQL. Throughout this course, you will experiment with left, right, outer and self joins and explore the appropriate use case for each.

By the end of this course, you will have a powerful tool at your disposal for combining separate tables within your database. You will have a much better understanding of which type of join to use in each situation.

Start Today

Learning Outcomes

  • Understand types of joins
  • Perform left & right joins
  • Perform full joins
  • Perform left & right outer joins
  • Perform self-joins

Lessons

1. Course Introduction
2. Types of SQL Joins
3. Inner Joins
4. Full Outer Joins
5. Full Left/Right Joins
6. Outer Left/Right Joins

Read More

7. Self Joins
Learning Certificates

Showcase Your Skills

Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.

When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Become A Data Citizen

Ready yourself for the rapidly changing world