#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 TransactSQL, or TSQL, 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.