SQL JOINS Tutorial for beginners | Practice SQL Queries using JOINS - Part 1
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.
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:
https://www.youtube.com/playlist?list=PLavw5C92dz9HQQ_COgGb7kf_1H8UWUBxO
✅ SQL Tutorial - Intermediate concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9FD9XspliRM_HZM_jK7tkii
✅ SQL Tutorial - Advance concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9GbmgiW4TWVnxhjMFOIf0Q7
✅ Practice Solving Basic SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9F66P3GFo5O6nJ4DfZNhVsp
✅ Practice Solving Intermediate SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9EIYmNXJ8ZtQ1bmLIpt0SpV
✅ Practice Solving Complex SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9Fahr7taauUx5RnTfuGyL--
✅ Data Analytics Career guidance:
https://www.youtube.com/playlist?list=PLavw5C92dz9FDsr995DjwCy9XNaIukb8P
✅ SQL Course, SQL Training Platform Recommendations:
https://www.youtube.com/playlist?list=PLavw5C92dz9GqF1Q_zn8KnYvFgtEOh-2n
✅ Python Tutorial:
https://www.youtube.com/playlist?list=PLavw5C92dz9FePZXIo4jpsupqp3X0w2SW
THANK YOU,
Thoufiq
Видео SQL JOINS Tutorial for beginners | Practice SQL Queries using JOINS - Part 1 канала techTFQ
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:
https://www.youtube.com/playlist?list=PLavw5C92dz9HQQ_COgGb7kf_1H8UWUBxO
✅ SQL Tutorial - Intermediate concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9FD9XspliRM_HZM_jK7tkii
✅ SQL Tutorial - Advance concepts:
https://www.youtube.com/playlist?list=PLavw5C92dz9GbmgiW4TWVnxhjMFOIf0Q7
✅ Practice Solving Basic SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9F66P3GFo5O6nJ4DfZNhVsp
✅ Practice Solving Intermediate SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9EIYmNXJ8ZtQ1bmLIpt0SpV
✅ Practice Solving Complex SQL Queries:
https://www.youtube.com/playlist?list=PLavw5C92dz9Fahr7taauUx5RnTfuGyL--
✅ Data Analytics Career guidance:
https://www.youtube.com/playlist?list=PLavw5C92dz9FDsr995DjwCy9XNaIukb8P
✅ SQL Course, SQL Training Platform Recommendations:
https://www.youtube.com/playlist?list=PLavw5C92dz9GqF1Q_zn8KnYvFgtEOh-2n
✅ Python Tutorial:
https://www.youtube.com/playlist?list=PLavw5C92dz9FePZXIo4jpsupqp3X0w2SW
THANK YOU,
Thoufiq
Видео SQL JOINS Tutorial for beginners | Practice SQL Queries using JOINS - Part 1 канала techTFQ
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Top 10 SQL Interview Queries | Popular SQL Queries for SQL InterviewSQL Cricket Match Problem | Solving SQL Interview ProblemFrom 16 years of CAREER GAP To becoming a Software Engineer | How to get a JOB after a career gap3 SQL Queries Asked in Interview for Business Analyst - SolvedCourses You Can Take To Get Into Data AnalyticsSolving a Real SQL Interview Problem | Job Vacancies SQL QueryPython Bootcamp for Beginners | Python Course | Live TrainingSQL Data Analytics Project (PART 3) | Data Analyst Portfolio ProjectSQL Data Analytics Project (PART 2) | Data Analyst Portfolio ProjectSQL Data Analytics Project (PART 1) | Data Analyst Portfolio ProjectLearn SQL from me | Live SQL Training | SQL BootcampLearn Python here | Learn Python Programming hereSolving a Complex SQL Interview problem | Practice SQL QueriesREAL SQL Interview Problem | Hierarchical data in SQLComplete guide to Database Normalization in SQLSQL Live class on Lighthall | Learn SQL from Basic to Advance in SQL BootcampHow to learn SQL for free | Roadmap to learning SQLSolving an SQL Interview ProblemSolving SQL Interview Query | Find Tree Node type using SQLSolving SQL Interview Query for Data Analyst asked by a Product based companySolving a tricky SQL Interview Query