Improve your SQL Server skills by mastering JOINs | Online Course

What you get?

Fully interactive online courses. Just you, SQL, Python, R and the web browser.

Instant access to lessons. You decide when and how long you want to learn.

Hundreds of SQL, Python, R exercises to master Your skills.

Course completion certificate to show the world that you really can!

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Well done! Now you know how to JOIN a table with itself.

In this section, you'll learn how to JOIN tables using non primary-foreign key conditions.

Next exercise

12/12 Congratulations

1. Introduction

2. Get to know the WorkshopWorkers table

3. Filtering self joined tables

4. Filtering – exercise

5. Get to know the Dictionary table

6. Dictionary table – exercise 1

7. Dictionary table – exercise 2

8. Dictionary table – exercise 3

9. Summary

10. Person table – exercise 1

11. Person table – exercise 2

12. Congratulations

Well done! Joining a table with itself is easy and quite useful. But we're not done with JOINs just yet – see you in the next part!

Click the Next exercise button to continue.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.

Instruction

Exercise

Need assistance?

login:
password:
Remember me on this computer

Recipient's Name:
Recipient's Email:
Your Message (Optional):

Create a free accountand start learning now!

What you get?

Sign upand join a company account!

Log in

Your registration has been successfully finished

Wrap course as a gift

JOINs in MS SQL Server

Great job!

Instruction

Exercise

Need assistance?