Navigate Select ESC Close

Joins in MySQL | Intermediate MySQL

2024-01-16 Education
385.6k
5.3k
205
Alex The Analyst
Alex The Analyst
1.4m subscribers

Unlock all features

FREE: Get instant access to 10 AI summaries, chats, or transcripts per day.

Description

Full MySQL Course: https://www.analystbuilder.com/courses/mysql-for-data-analytics In this lesson we are going to take a look at Joins in MySQL! GitHub Code: https://github.com/AlexTheAnalyst/MySQL-YouTube-Series/blob/main/Intermediate%20-%20Joins.sql ____________________________________________ 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: https://coursera.pxf.io/5bBd62 📖Data Analysis with Python - https://coursera.pxf.io/BXY3Wy 📖IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR 📖Tableau Data Visualization - https://coursera.pxf.io/MXYqaN Udemy Courses: 📖Python for Data Science - https://bit.ly/3Z4A5K6 📖Statistics for Data Science - https://bit.ly/37jqDbq 📖SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij 📖Tableau A-Z - http://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! https://www.youtube.com/channel/UC7cs8q-gJRlGwj4A8OmCmXg/join ____________________________________________ Websites: 💻Website: AlexTheAnalyst.com 💾GitHub: https://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*

Top Comments (10)

@Mister_Garibaldi 2024-01-16

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

147 10 replies
@duurduranto 2024-03-24

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

71
@dataandengineering 2024-07-29

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

60
@Lavishjt 2024-07-23

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

56 1 replies
@gunfugames7430 2024-09-26

It's starts to get wild

35
@aalanaa 2024-10-03

joins are used to combine rows from two or more tables based on a related column between them. types of joins: - INNER JOIN: Returns rows with matching values in both tables. - LEFT JOIN (LEFT OUTER JOIN): Returns all rows from the left table and matched rows from the right table. If no match, returns NULL for right table. - RIGHT JOIN (RIGHT OUTER JOIN): Similar to LEFT JOIN but returns all rows from the right table. - FULL OUTER JOIN: Returns rows when there is a match in either table, or NULL when no match exists. Each join serves different purposes based on the relationships between your data tables.

25 1 replies
@MrKenneth009 2024-07-18

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

20 2 replies
@kcmauceri 2024-05-28

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

14
@QuangNguyen-md8ky 2025-05-15

First watch I could code along but only understand half. Second watch and I fully understand the content. Thanks Alex

9
@futaba6461 2024-10-21

I didn't understand anything at first but then it all fell into place. thank you

7

Unlock the Data Inside
Turn Videos into Knowledge

  • Get FREE 10/day: transcripts, summaries, chats
  • Chat with videos, export text & PDF
  • $1 free API credit for RAG, chatbots & research

Free forever plan • All features unlocked

App screenshot