JOINs in MS SQL Server

Table of contents

1. 1. Recap of SQL JOIN types

   0/21

   Review the most common types of JOINs. Practice JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN and others.

   List of exercises Start now
   1. Simple JOINs recap
      1. Introduction
      2. Get to know the Author table
      3. Get to know the Book table
      4. Get to know the Adaptation table
      5. JOINs – recap
      6. JOIN and filtering
      7. JOINS – ambiguous columns
   2. Various kinds of JOINs
      1. INNER JOIN
      2. LEFT JOIN
      3. RIGHT JOIN
      4. FULL JOIN
      5. CROSS JOIN
   3. Filtering with LEFT JOIN and RIGHT JOIN
      1. Filtering with JOINs
      2. Filtering with JOINS – continued
      3. ON and WHERE conditions
   4. Summary
      1. Summary
      2. Get ready
      3. Exercise 1
      4. Exercise 2
      5. Exercise 3
      6. Congratulations

2. 2. Multiple JOINs

   0/13

   Refine your joining skills. Exercise joining more than two tables in one SQL query.

   List of exercises Buy course
   1. Healthy Shop database
      1. Introduction
      2. Get to know the Department table
      3. Get to know the Product table
      4. Get to know the NutritionData table
   2. MULTIPLE JOINs – Exercises
      1. Exercise 1
      2. Exercise 2
      3. Exercise 3 – Get to know the Producer table
      4. Exercise 4
      5. Exercise 5 – Get to know the SalesHistory table
      6. Exercise 6
      7. Exercise 7
      8. Exercise 8
      9. Congratulations

3. 3. Joining a table with itself

   0/12

   Learn how to join SQL table with itself.

   List of exercises Buy course
   1. Introduction
      1. Introduction
      2. Get to know the WorkshopWorkers table
      3. Filtering self joined tables
      4. Filtering – exercise
   2. Dictionary database
      1. Get to know the Dictionary table
      2. Dictionary table – exercise 1
      3. Dictionary table – exercise 2
      4. Dictionary table – exercise 3
   3. Summary
      1. Summary
      2. Person table – exercise 1
      3. Person table – exercise 2
      4. Congratulations

4. 4. Non-equi JOINs

   0/29

   Practice joins with less common conditions: non-equi JOINs and joins between non-key columns.

   List of exercises Buy course
   1. Medical Center database
      1. Introduction
      2. Get to know the Physician table
      3. Get to know the Therapy table
      4. Get to know the Treatment table
   2. Non primary-foreign key JOINs
      1. Non primary-foreign key JOINs
      2. Exercise 1
      3. Exercise 2
      4. Joining more tables
      5. Filtering results – exercise
   3. Non-equi JOINs
      1. Non-equi JOINs
      2. Get to know the Item table
      3. Get to know the Buyer table
      4. Items within price range
      5. Filtering non-equi-JOINs
      6. Get to know the Apartments table
      7. Get to know the Couples table
      8. Get apartments in price range
      9. Preferred affordable apartments
   4. Non-equi self JOINs
      1. NON-EQUI self JOINs
      2. Employee ages
      3. Get to know the ProductPrice table
      4. Get to know the Orders table
      5. Exercise 1
      6. Exercise 2
   5. Summary
      1. Summary
      2. Exercise 1
      3. Exercise 2
      4. Exercise 3
      5. Congratulations

5. 5. Challenge

   0/18

   Check your knowledge in the challenge.

   List of exercises Buy course
   1. Challenge time
      1. Get to know the Lecturer table
      2. Get to know the StudentGroup table
      3. Get to know the Tuition table
      4. Get to know the Timetable table
      5. Exercise 1
      6. Exercise 2
      7. Exercise 3
      8. Exercise 4
      9. Exercise 5
      10. Get to know the Car table
      11. Get to know the CharityAuction table
      12. Get to know the Buyer table
      13. Exercise 6
      14. Exercise 7
      15. Exercise 8
      16. Exercise 9
      17. Exercise 10
      18. Congratulations!

Get the Certificate of Competency in SQL

This certificate will confirm your practical SQL problem-solving skills

Obtain the Certificate Learn more