SQL - Introduction to JOINing Tables

Jon Avis, Application Support Analyst

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

      1:49
    • JOINS

      3:49
    • INNER JOIN PART 1

      13:03
    • INNER JOIN PART 2

      7:48
    • LEFT JOIN

      8:32
    • RIGHT JOIN

      6:32
    • FULL JOIN

      7:33
    • JOINING MULTIPLE TABLES

      13:47
    • UNION

      11:34
    • 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.

3

Students

--

Projects

Jon Avis

Application Support Analyst

My name is Jon. I am from the UK and currently work in Hong Kong as an application support analyst for an investment bank. I have over three years experience as a support analyst. This has allowed me to become an expert on SQL and Unix systems.

In my spare time I enjoy hiking, cycling, photography and traveling.