Booking Information
Once you have booked your course, you will receive a
confirmation email containing an access link and passcode. Use these to set up your account on the Chartered Accountants Ireland
Portal within the Kubicle sitesite.
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.
Learning Outcomes
- Understand
types of joins
- Perform
left & right joins
- Perform
full joins
- Perform
left & right outer joins
- Perform
self-joins
Lessons
- Course Introduction
- Types of SQL Joins
- Inner Joins
- Full Outer Joins
- Full Left/Right Joins
- Outer Left/Right Joins
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.