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

Published: 06 January 2022
on channel: techTFQ

1,453,686

30k

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.

If you’d like to practice SQL queries or explore my recorded SQL courses, check out my all-in-one SQL learning platform, SQLNest 👇
https://sqlnest.com/

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=thoufiqmoha...

Join my Discord Server:   / discord

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/305d73...

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/185a13...

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 - Basic concepts

✅ SQL Tutorial - Intermediate concepts:
   • SQL Tutorial - Intermediate concepts

✅ SQL Tutorial - Advance concepts:
   • SQL Tutorial - Advance concepts

✅ Practice Solving Basic SQL Queries:
   • Practice Solving BASIC SQL Queries

✅ Practice Solving Intermediate SQL Queries:
   • Practice Solving INTERMEDIATE SQL Queries

✅ Practice Solving Complex SQL Queries:
   • Practice Solving COMPLEX SQL Queries

✅ Data Analytics Career guidance:
   • Data Analytics career and more

✅ SQL Course, SQL Training Platform Recommendations:
   • SQL Course / Training

✅ Python Tutorial:
   • Python Tutorial

THANK YOU,
Thoufiq

On this page of the site you can watch the video online SQL JOINS Tutorial for beginners | Practice SQL Queries using JOINS - Part 1 with a duration of hours minute second in good quality, which was uploaded by the user techTFQ 06 January 2022, share the link with friends and acquaintances, this video has already been watched 1,453,686 times on youtube and it was liked by 30 thousand viewers. Enjoy your viewing!

481

00:00:00