Joins in MySQL | Intermediate MySQL

Подписаться 872 тыс.

Просмотров 122 тыс.

50% 1

Full MySQL Course: www.analystbui...
In this lesson we are going to take a look at Joins in MySQL!
GitHub Code: github.com/Ale...
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Coursera Courses:
📖Google Data Analyst Certification: coursera.pxf.i...
📖Data Analysis with Python - coursera.pxf.i...
📖IBM Data Analysis Specialization - coursera.pxf.i...
📖Tableau Data Visualization - coursera.pxf.i...
Udemy Courses:
📖Python for Data Science - bit.ly/3Z4A5K6
📖Statistics for Data Science - bit.ly/37jqDbq
📖SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
📖Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
BECOME A MEMBER -
Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!
/ @alextheanalyst
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: github.com/Ale...
📱Instagram: @Alex_The_Analyst
____________________________________________
All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for

Опубликовано:

28 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 80

@dataandengineering 2 месяца назад

The summary for the outer join is : ○ LEFT JOIN § You take everything from the left table , and the matches of the right table ○ RIGHT JOIN § You take everything from the right table and the matches of the left table

@alkhemist6631 4 месяца назад

Glad im in the intermediate now. I doubt I understood everything in Beginner. I will go back and come when I understand 90% of it.

@Mister_Garibaldi 8 месяцев назад

Poor Leslie Knope isn't getting a present this year! 🤣

@AlexTheAnalyst 8 месяцев назад

@j__o__e__2739 5 месяцев назад

@@AlexTheAnalyst Why does craig show up in list 2, but not list 1? Is it because Ron isnt on list 1?

@RMIVfitness 3 месяца назад

What I wanna know is how Leslie is making more money even though Ron is her boss?

@braydj 2 месяца назад

@@RMIVfitness I make more than my bosses do. Though I am in a different industry.

@taiebxr 3 месяца назад

thank you for this, loved the beginner series- concise amd clear!

@HeinHtetAung-vh3uu Месяц назад

Thank you so much, Alex. Awesome lesson

@sunnysisodhya 8 месяцев назад

Hey I Was Looking For This Video Thanks

@ashutoshpandey9105 8 месяцев назад

Hey, please bring more project based videos.

@AlexTheAnalyst 8 месяцев назад

I always do :)

@IhuomaGeraldine 3 месяца назад

Please I need help.. I don’t think I have the data for parks department

@varunchamoli9742 8 месяцев назад

Sir should I Start my career in data analytics with python or sql

@albertayeh-sarpong1264 6 месяцев назад

Which version kf SQL is this

@glenmartin952 3 месяца назад

I have notice something when he is renaming or assigning names, He uses AS sometimes and not in the others, Am I missing somthing?

@Hirenkn 2 месяца назад

Pls refer to limit + aliasing inmy sql video....

@joshuafriday5357 4 месяца назад

Nahh. I think Mark got one. No santa for Leslie 😅😂

@sarkersaadahmed 4 месяца назад

JOINS inner join ->inner join simply joins two database tables based on ->just like AND gate [ SELECT * FROM [chemical thermodynamic and polarizability table].[dbo].[Chemical] AS c INNER JOIN [SQL Tutorial].[dbo].[quantum_research_papers] AS q ON [SQL Tutorial].[dbo].[quantum_research_papers].categories = [chemical thermodynamic and polarizability table].[dbo].[Chemical].Energy; ] D1 denotes database 1 and D2 denotes database 2 will “merge” and excliude the databases that either of the tables do not have [simply the inner join] based on the common column name between the two databases tables Note: Its best to mention the [DATABASE_NAME].[dbo].[QUERY_NAME].column_name LEFT JOIN is like OR gate where everything on the left will output but everything on the right will show NULL and everything on the right will only be shown if there are datas that have the same value as the values of the left VISE VERSA FOR RIGHT JOIN FULL OUTER JOIN IS EVERYTHING LITERALLY

@amrabdelatyfathallah2487 3 месяца назад

can i ask a question in self join you add 1 ON emp1.employee_id + 1 = emp2.employee_id, However the one added to 'emp2.employee_id ' not 'emp1.employee_id ' ? and another question we apply here self join using inner join , he should return for me only matches emp_id, i mean 2 Leslie Knope 2 Ron Swanson 3 Ron Swanson 3 Tom Haverford 4 Tom Haverford 4 April Ludgate 5 April Ludgate 5 Jerry Gergich ======================================= like this all over until he finished them why he returned for me like self join using left join like result appear in 13:00

@beslandaur7729 8 месяцев назад

“Let’s look at a very serious use case for self-join”… Proceeds to funding secret santa. But what’s the real purpose of self-join in a real-world? Why would you want to join a table to itself? Just trying to understand

@momohtimothy6898 4 месяца назад

Honestly, the self join looks complicated to me.

@userwheretogo 8 месяцев назад

People just keep producing identical content on RU-vid. Quite a waste of time

@TalkdatawithJain 8 месяцев назад

Don't watch

@duurduranto 6 месяцев назад

i looked at several videos regarding joins and believe me, your way of explaining the topic is the best.

@mohannadhazem5117 2 месяца назад

been struggling to fuly understand joins for weeks until i stumpled on this boot camp, but in this self join xample i don't think Leslie got herself a secret santa 😂

@lifeasjt9584 2 месяца назад

6 minutes in and I already understand more than an online course I’m enrolled in. Subscribed!!😊

@johncyriligwe7538 Месяц назад

same here

@MrKenneth009 2 месяца назад

Ron Swanson redacting his birthday was a hilarious reference from the show hahaha

@kcmauceri 4 месяца назад

A gold mine of information. So happy I came across this boot camp.

@fredericnicholson80 6 месяцев назад

Hi Alex, thanks for these great introductions. You present great examples that show the essential concepts. There is one topic though that I believe deserves some attention: The differences between the different SQL dialects. For example, If I compare this video to your intermediate SQL video on "Join", then mySQL seems to be missing the "full outer join" option.

@abrahammoruti5967 8 месяцев назад

As a recruiter yourself Alex what level of skill set are you looking for when you're trying to look for a entry level analyst?

@AlexTheAnalyst 8 месяцев назад

A solid concept up to Intermediate.

@RogerAmanna Месяц назад

At 10:40 the +1 is added to the left table. But, when we run the query, it looks like the right table was added with one. How exactly does this work?

@RogerAmanna Месяц назад

I found the answer to this. The join condition is emp1.employee_id + 1 = emp2.employee_id. This means that for every row in emp1, SQL will add 1 to the employee_id and then look for a match in emp2 where the employee_id equals this modified value.

@NoluthandoMthethwa-ei9fp 4 месяца назад

Thank you, this is so helpful I’m so happy I found this boot camp

@palesampe 4 месяца назад

Are you in the ALX programme?

@Lifestudent- 2 месяца назад

@@palesampeExplore AI program

@AjayAnkit-bt8cp 3 месяца назад

indians attendence here🎉😂

@MikeJones-ql3db 6 месяцев назад

Thanks a lot you make learning very easy

@АртурКолован 17 часов назад

the only SQL video that explains JOIN in plain english) thanks))

@ar8abdul 8 месяцев назад

If you don't mind make videos about creating indexes, triggers, auto_increment in mysql

@AlexTheAnalyst 8 месяцев назад

Some of those will be in the advanced series next :)

@DadaCreative. 3 месяца назад

hello Sir Alex if I only write SELECT * FROM employee_demographics; its bring me Error have to write SELECT * FROM parks_and_recreation.employee_demographics; even if am inside demographics table.

@cassandraneall5484 2 месяца назад

He goes over this in the fourth video of this bootcamp (Select Statement in MySQL) but you may have the wrong schema selected in the navigator section on the side, if the parks_and_recreation isn't bolded then the data will not be automatically pulled from that data set. Hopefully this helps and I explained it in a way that makes sense, I'm still new myself so if it's not that then I don't know lol

@gunfugames7430 2 дня назад

It's starts to get wild

@BruceBeck-f1n 4 месяца назад

Great lesson Alex. It's been quite some time since I practiced any sort of JOIN in any flavor of SQL. Great review! Thanks for your outstanding work. Cheers! 🤠

@ShreyaSridharD 3 месяца назад

As a huge fan of parks and rec i enjoy learning from these video : )

@momohtimothy6898 3 месяца назад

Exactly the information i want, clear and simple...straight to the point.

@NohablaEspnaol 12 дней назад

Thank you so much!

@Rianne421 7 месяцев назад

Thanks this is great!

@sarkersaadahmed 4 месяца назад

lets put it in a logic gate INNER JOIN: AND GATE, IF ONE OF THE ROWS DOESNT EXIST WHILE THE OTHER DOES, ENTIRE THING GONE!! FULL OUTER JOIN: EVERYTHING LEFT OUTER JOIN:" OR gate where everything on the left will output but everything on the right will show NULL and everything on the right will only be shown if there are datas that have the same value as the values of the left RIGHT OUTER JOIN: VISE VERSA FOR LEFT OUTER JOIN

@mohdparvez9148 Месяц назад

One problem though, the first employee Leslie doesn't have a secret Santa. I guess no gift for her this Christmas ;)

@faithgaming8770 Месяц назад

I've completed all ur videos of this course till yet but didn't understand anything in sql. What the use of these functions in sql?

@lovamaxy3498 3 месяца назад

Thanks for the lesson, I keep having error problem (1046), how do i resolved it. Thanks

@nategraham3980 24 дня назад

this was posted on my birthday! thumbs up January babies!

@Mr.Arshad-oc1fd 2 месяца назад

On thing in my mind is that there is joining of two tables so the employee id column are showing double why should not there is only one employee id column

@realdealisai 8 месяцев назад

hey Alex do you still have the patreon page ?

@newenglandnomad9405 8 месяцев назад

What kind of answer would you get from joining 3 tables? What would you do with the answer?

@sohaibamjad2878 8 месяцев назад

Could you please let us know that can AI replace the data analytics job? I am going to end your course on data analytics but I have heard that soon AI can replace it. Thanks

@Mr.Arshad-oc1fd 2 месяца назад

Hi sir thanks for this great unforgettable teaching us

@MinatoJunior-hl8tb 8 месяцев назад

Hey can you make a video in how to download a program to practice data. Or is there a way for you to add it into your website for people to practice with data from outside like Jupyter but for sql

@pragatheeshm.sc.577 6 месяцев назад

Why are you deleting or hiding videos ?

@imvimalkumar007 3 месяца назад

Is it alright if I don't get it in the first go?

@SareyFarah 8 месяцев назад

Have you ever Prepared already for Trigger?

@shobolabenjamin4454 2 месяца назад

Thank you ALEX for all you do.

@Monica14560 6 месяцев назад

where i can download these data

@kanchanachristopher5465 8 месяцев назад

Alex kindly make a playlist on azure.

@mercyokwoli6837 Месяц назад

Thanks Alex

@hisokaamorou4211 3 месяца назад

awesome...

@ajithfrancis1992 Месяц назад

Sir in 16:49, the last query you wrote, you have added alias names for first two tables but you haven’t added alias name for parks_dept table; instead you wrote as pd. Why ??

@janvi2294 15 дней назад

pd is alias for parks_dept table ..we can directly write it after table name or can use "AS pd"

@mattchan5231 День назад

yeah seems to be used as a shortcut by skipping "AS" but I added that during my follow through so it makes sense to me

@Earthlighte 8 месяцев назад

Sir, you've recommended Udemy and Coursera.... what about Analyst Builder for certification?

@AlexTheAnalyst 8 месяцев назад

I think my courses are a little bit better than what you'll find on Udemy and there are practice questions integrated into the course too which Udemy doesn't have. It does have a Certificate at the end just like Udemy has :)

@jimieJimieMaverickstarz 9 дней назад

How much roughly your course fee@@AlexTheAnalyst?

@jatinmanhas4966 2 месяца назад

thank you so much Alex the Analyst

@HopeOverDebt 2 дня назад

Correct me if i am wrong but this is what i understood .......................... 3 TYPES OF JOINS : 1. INNER JOIN 2. OUTER JOIN [LEFT OUTER JOIN & RIGHT OUTER JOIN] 3. SELF JOIN ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1. INNER JOIN : RESULT WILL BE THE ONLY VALUES WHICH WILL MATCH IN BOTH TABLE1 & TABLE2 . 2.1 OUTER JOIN [LEFT] : RETURNS ALL THE VALUES FROM LEFT AND RIGHT TABLE , BUT IF THERE ARE ANY MISSING VALUES FROM RIGHT TABLE THEN IT REPRESENTS THEM AS NULL INSTEAD OF DELETING THAT ROW . 2.2 OUTER[RIGHT]: RETURNS ALL THE VALUES FROM RIGHT AND LEFT TABLE , BUT IF THERE ARE ANY MISSING VALUES FROM LEFT TABLE THEN IT REPRESENTS THEM AS NULL INSTEAD OF DELETING THAT ROW . 3. SELF : THE TABLE IS JOINED WITHIN ITSELF [TABLE1, TABLE1 SITUATION ] OR SELF JOINED TABLES 🤔🤔