Master the SQL SELECT statement part 05: JOIN clause

This video is part of a multi-part series on mastering the SQL SELECT statement. The SELECT statement, the most often used SQL command, is easy to learn yet difficult to master. Follow along with me and level up your database query super powers!

This video covers the table JOINS, specifically
- Natural / Equijoins on primary / foreign key
- Multi-table joins
- Table aliasing to handle ambiguous column names
- Outer joins: LEFT and RIGHT joins. FULL outer joins.
- Using a NULL check across Outer joins to find rows not participating in the join.
- Self joins where the same table participates more than once in the query.
- What can go wrong with joins, just because it works doesn't mean it makes sense!

[laughingcorpsev]

it's amazing the difference a good teacher can make, teaching is underrated . thanks

[goryllas]

I wish you were my professor. Your explanations are so easy to understand.

[vinith]

Prof. It will be really helpful if you use the chapters feature on YouTube and split the video into chapters :)

Nice, work your videos have been really helpful. When is use the try and add to strings together to create a fullname like you have done, i get an out of 0 (zero) not the full name. I'm using mysql workbench and mysql 8.0. Any ideas?

[minamishail_Tech]

This is a great effort Mr.Michael
Do you have a list of lectures for Stored procedures in details, same as Select statements ?