SQL Joins Explained with Examples - Inner Join, Left Join, Right Join, Full Join, Cross & Self Join

#SQL #Joins Explained - If you work with #databases, you need to know what joins are and how to use them. Whether you are new to working with databases, or just need a JOINs refresher, this video is for you.

In this video, I will explain what joins are, the different types of joins (inner join, outer joins, cross join and self join), and the types of joins needed for certain kinds of questions. I will also answer some common questions (and misconceptions!) about joins.

In addition to the theory, I will provide you walkthroughs of each type of joins using Microsoft SQL Server (using the Transact-SQL, or T-SQL, variant).

*CORRECTION: (Thank you Aditya Jain!)
It looks like I have accidentally copied and pasted the wrong record (sorry!).
On:
9:26 - the course that has not been taken yet is COMP4677.