SQL Tutorial - Introduction to SQL Joins

Jon Avis, IT Systems Engineer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
10 Lessons (1h 16m)
    • 1. CLASS INTRODUCTION

      1:49
    • 2. JOINS

      3:49
    • 3. INNER JOIN PART 1

      13:03
    • 4. INNER JOIN PART 2

      7:48
    • 5. LEFT JOIN

      8:32
    • 6. RIGHT JOIN

      6:32
    • 7. FULL JOIN

      7:33
    • 8. JOINING MULTIPLE TABLES

      13:47
    • 9. UNION

      11:34
    • 10. CLASS SUMMARY

      1:57

About This Class

In this class you will learn how to extract data from multiple tables by using the JOIN statement. You will learn:

  • The different types of JOIN queries in SQL.
  • How to write INNER JOINs.
  • How to write LEFT, RIGHT and FULL JOINs and the differences between them.
  • How to JOIN more than two tables together.
  • How to use the UNION and UNION ALL statements.