Joins in MySQL | Intermediate MySQL

Full MySQL Course: www.analystbuilder.com/course...
In this lesson we are going to take a look at Joins in MySQL!
GitHub Code: github.com/AlexTheAnalyst/MyS...
____________________________________________
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.io/5bBd62
📖Data Analysis with Python - coursera.pxf.io/BXY3Wy
📖IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
📖Tableau Data Visualization - coursera.pxf.io/MXYqaN
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/AlexTheAnalyst
📱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

[@kcmauceri]

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

[@duurduranto]

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

[@momohtimothy6898]

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

[@user-kq3tc5tu1c]

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! 🤠

[@fredericnicholson80]

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.

[@Mister_Garibaldi]

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

[@AlexTheAnalyst]

:(

[@j__o__e__2739]

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

[@alkhemist6631]

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.

[@user-wv2ii3dq4j]

Hey I Was Looking For This Video Thanks

[@NoluthandoMthethwa-ei9fp]

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

[@palesampe]

Are you in the ALX programme?

[@kanchanachristopher5465]

Alex kindly make a playlist on azure.

[@MikeJones-ql3db]

Thanks a lot you make learning very easy

[@Rianne421]

Thanks this is great!

[@MinatoJunior-hl8tb]

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

[@ar8abdul]

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

[@AlexTheAnalyst]

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

[@newenglandnomad9405]

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

[@realdealisai]

hey Alex do you still have the patreon page ?

[@varunchamoli9742]

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

[@abrahammoruti5967]

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]

A solid concept up to Intermediate.

[@sohaibamjad2878]

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

[@ashutoshpandey9105]

Hey, please bring more project based videos.

[@AlexTheAnalyst]

I always do :)

[@albertayeh-sarpong1264]

Which version kf SQL is this

[@Monica14560]

where i can download these data

[@Earthlighte]

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

[@AlexTheAnalyst]

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 :)

[@pragatheeshm.sc.577]

Why are you deleting or hiding videos ?

[@joshuafriday5357]

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

[@SareyFarah]

Have you ever Prepared already for Trigger?

[@KylianMbappe07303]

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

[@beslandaur7729]

“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]

Honestly, the self join looks complicated to me.

[@userwheretogo]

People just keep producing identical content on KZbin. Quite a waste of time

[@TalkdatawithJain]

Don't watch

[@KylianMbappe07303]

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]

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