SQL Joins - Beginner to PRO Masterclass with 10 Examples

Рет қаралды 16,830

Күн бұрын

Left, right, inner, outer, anti, no matter what you call them, Joins are an important part of the SQL for data analysis. In this comprehensive video, learn how to create your first join and more with easy, clear and relevant explanation of the concepts.
💻 Get the data:
==============
Visit chandoo.org/wp/learn-sql-for-... to get the dataset. Use the instructions on that page to set up the data in SQL Server or MySQL.
Topics covered in this video:
=======================
Why we need joins in the first place?
Joins explained visually
Join with a one table
Join with two tables
Joins and where clauses
Join and group by
Solving complex business questions using join and CTE
⏱ Video Chapters:
================
0:00 - What is a join and why we need them?
2:22 - Our first join in SQL
3:58 - Join Example #2 - Shipments by name & team
4:56 - Example #3 - Joins with where clause
5:51 - Example #4 - another Join with where clause
6:28 - Using where vs writing the condition in the join itself (#5)
7:22 - Using 3 tables in a join - Example #6
9:24 - Bonus tip with joins
9:52 - Joins and Grouping example (#7)
12:51 - Left, Right and Anti joins explained
14:30 - Left join example (#8)
17:29 - Anti join example (#9)
19:24 - A complex join example with real business problem
~
💡 Learn more SQL
===============
SQL for beginners: • SQL Basics for people ...
SQL Beginner to PRO video: • Learn SQL for Data Ana...
Using SQL with Power BI: • How to use SQL with Po...
50 Example SQL Queries - chandoo.org/wp/learn-sql-for-...
😎 SQL Alternatives:
=================
Using Power Query: • Learn Power Query & Au...
Using Pandas: • Learn how to use PANDA...
~
#SQL #joins

Пікірлер: 43

@Drkalaamarab 2 ай бұрын

❤❤❤❤❤❤❤❤❤ Loved it sir, your demonstrate is so easy simple to understand.

@richaagrawal376 Ай бұрын

You are my favourite teacher!! In every field ,Excel ,SQL ,financial concepts, power bi, your videos are the best. your way of teaching is the best!!!

@pruthviraj8864 2 ай бұрын

Left-join and anti-joins are very informative. Thank you !!

@simonvaughan5654 2 ай бұрын

Another brilliant video Chandoo. You explain everything so perfectly. Thank you :)

@alexrosen8762 2 ай бұрын

Extremely useful stuff, especially the Pro part which was really well explained (the shipped vs not shipped example) 👌

@abdanomer 2 ай бұрын

Lovely video as usual CHANDOO. I would love to see more and more of SQL. The 'awesome chocolates' need to be updated to be the same as the video, I needed to add data to understand the left joint as there is not in the data.

@nojoodal-ghamdi5579 Ай бұрын

This was perfect! And explained very well, thank you so much

@snehalsuryawanshi1403 2 ай бұрын

Could you please make video on stored procedures and triggers as I love the way you teach and explain the stuff.

@rajeshmajumdar4999 2 ай бұрын

Thank you Chandoo!

@aparnapandravada5073 2 ай бұрын

Super useful tutorial… Thank you for providing such detailed explanation

@konata_fan 2 ай бұрын

Great video, thank you 🎉

@xsaitama4383 2 ай бұрын

I have my data analytics job interview approaching and I am preparing from your videos, thanks man I appreciate your work.

@chandoo_ 2 ай бұрын

You can do it!

@xsaitama4383 2 ай бұрын

@@chandoo_ thank you so much

@Sirigineedi_Navann 2 ай бұрын

Chandu anna super ga chepparu mee abhimani from West Godavari 😊

@user-cy1eo9jh3v 2 ай бұрын

I hope you do different datasets for the upcoming tutorials.

@christinecandelario4580 2 ай бұрын

Hi Chandoo. Can i reuse the pivot charts and dashboard even when data source changes? And, is there a way to automatically update or change the data source of multiple pivot tables?

@user-lm5wb8vi1x 2 ай бұрын

Finished watching

@NickMaverick4 2 ай бұрын

Sir please make a video on SQL sub query, correlation subquery and window function

@DeepakKumar-ws3ed 6 күн бұрын

Sir, this database is not running in pgadmin software. Can you provide us the, create table statement for all the tables used in this video ?

@ExcelWithChris 2 ай бұрын

Please please help. Power Query. Somewhere I saw you can get a result in a step, then export that result to another query, come back to this query and ref the step before "exporting" and carry on with the current query.

@preetshah3793 2 ай бұрын

Make more videos on sql

@bilalsiddique8001 2 ай бұрын

Sir i want to add month in excel when ever number repeat for example if in serial number 1 month will march whenever number 1 repeat next month automatically display like april and so on. kindly guide regarding the same

@andrewdove342 2 ай бұрын

I want to be part of the yummies team 😁. Thanks Chandoo awesome stuff. PS. I hope Barr Faughny is well 😁

@chandoo_ 2 ай бұрын

😂 Sure. Answer this hiring question and you are in. How many Spicy Special Slims can you sell on Saturdays while Skipping stones on a sandy beach?

@andrewdove342 2 ай бұрын

@@chandoo_ as many are the sand upon the seashore, so shall be my sales of the awesome "Spicy special slims" on a Saturday whilst skipping stones 😄

@bp2807 2 ай бұрын

Hi sir. Is relationship between two table required to apply joins or it can work with out relationship between table. Please answer🙏🙏

@chandoo_ 2 ай бұрын

You don't need relationships. Technically, SQL tables don't really have relationships. They have referential integrity constraints. But these don't apply for SELECT clause.

@abdanomer 2 ай бұрын

With statements is not working for me in MySQL? Do you know why?

@rajkumarraj7139 2 ай бұрын

Is there any new course for Advanced Excel sir?

@ravindracomedyzone3027 2 ай бұрын

Sir please post same videos in Telugu language also because we addict ur videos please Sir😢

@harireddy1328 2 ай бұрын

Bro How to create a template in power bi, I have one M query, i would like to make this as example to someone, so if possible do a video that how to create a template please 😊