Skip to content

PRO TIP Block youtube.com at the DNS level — Pi-hole, NextDNS or your hosts file — but allow youtube-nocookie.com and i.ytimg.com. These tutorials keep playing; the rabbit hole does not.

Learning without distractions

SQL JOINS Tutorial for beginners | Practice SQL Queries using JOINS – Part 1

1.5M views on YouTube

techTFQ 23 tutorials here
Programming

This is the SQL JOINS Tutorial for complete beginners. In this video we shall cover INNER Join, LEFT Join and RIGHT Join. I’ll be posting the second part of this video next week where we shall cover FULL OUTER Join, SELF Join, CROSS Join and NATURAL Join.

My Live SQL Bootcamp is back – the first one in over a year! 8 live sessions, Beginner to Advanced, starting Sept 5. Seats are limited 👇
https://sqlnest.com/bootcamp/Live_SQL_Bootcamp_Beginner_to_Advanced

Before we talk about different types of Joins in SQL, we shall first understand what are JOINS and why do we need them and then finally write some SQL queries to understand how to use them. We shall practice writing SQL queries using inner, left and right joins in this video.

Joins are the most fundamental concepts in SQL and having a clear understanding of Joins is very essential to write good SQL queries.

Timeline:
00:00 Intro
02:36 What are JOINS in SQL
05:30 Inner Joins in SQL
13:55 Left Join in SQL
19:59 Right Join in SQL

My recommended SQL Course: https://learnsql.com/?ref=thoufiqmohammed

Join my Discord Server: https://discord.gg/8aRSbygbdu

Join my FREE live SQL training session:
Batch 1 – Started on 03-Jan-2022 (08:00 pm Malaysian Time / 05:30 pm Indian Time)
Day: Monday, Tuesday, Thursday, Friday
Registration Link: https://www.lighthall.co/class/305d73cb-2381-4499-9088-54e82a4de7b8/

Batch 2 – Starts on 17-Jan-2022 (09:30 pm Malaysian Time / 07:00 pm Indian Time)
Day: Monday, Tuesday, Thursday, Friday
Registration Link: https://www.lighthall.co/class/185a13de-31a5-475a-abc3-b64926c054dc/

Note: Both batch 1 and batch 2 will cover the exact same topics. Just the date and time are different based on the convenience of everyone.

How to Join the sessions:
1) Go to https://www.lighthall.co/
2) Click the subject “Data Science”
3) Find my session and click on it. The sessions will automatically start 4 mins prior to the scheduled time.

Please do subscribe and like this video if you found it useful.

🔴 WATCH MORE VIDEOS HERE 👇

✅ SQL Tutorial – Basic concepts:

✅ SQL Tutorial – Intermediate concepts:

✅ SQL Tutorial – Advance concepts:

✅ Practice Solving Basic SQL Queries:

✅ Practice Solving Intermediate SQL Queries:

✅ Practice Solving Complex SQL Queries:

✅ Data Analytics Career guidance:

✅ SQL Course, SQL Training Platform Recommendations:

✅ Python Tutorial:

THANK YOU,
Thoufiq