Joins in MySQL | Intermediate MySQL
Unlock all features
FREE: Get instant access to 10 AI summaries, chats, or transcripts per day.
Unlock all features
FREE: Get instant access to 10 AI summaries, chats, or transcripts per day.
Unlock all features
FREE: Get instant access to 10 AI summaries, chats, or transcripts per day.
Unlock all features
FREE: Get instant access to 10 AI summaries, chats, or transcripts per day.
Unlock all features
FREE: Get instant access to 10 AI summaries, chats, or transcripts per day.
Related videos
Learn Databricks in Under 2 Hours
Alex The Analyst
76.7k views
Intro to Databricks (Free Edition) | UI Walkthrough
Alex The Analyst
67.2k views
How to Become a Healthcare Analyst in 2025
Alex The Analyst
44.7k views
What is Healthcare Analytics?
Alex The Analyst
40.6k views
Learn Pandas in Under 3 Hours | Filtering, Joins, Indexing, Data Cleaning, Visualizations
Alex The Analyst
121.1k views
Learn SQL Beginner to Advanced in Under 4 Hours
Alex The Analyst
1.3m views
2 Hour Data Analyst Interview Masterclass | Interview Better Than The Competition
Alex The Analyst
135.4k views
MySQL Exploratory Data Analysis | Full Project
Alex The Analyst
169.7k views
Data Cleaning in MySQL | Full Project
Alex The Analyst
422.7k views
Triggers and Events in MySQL | Advanced MySQL Series
Alex The Analyst
156.7k views
Top Comments (10)
Poor Leslie Knope isn't getting a present this year! 🤣
i looked at several videos regarding joins and believe me, your way of explaining the topic is the best.
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
6 minutes in and I already understand more than an online course I’m enrolled in. Subscribed!!😊
It's starts to get wild
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.
Ron Swanson redacting his birthday was a hilarious reference from the show hahaha
A gold mine of information. So happy I came across this boot camp.
First watch I could code along but only understand half. Second watch and I fully understand the content. Thanks Alex
I didn't understand anything at first but then it all fell into place. thank you
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
Top Comments (10)
Poor Leslie Knope isn't getting a present this year! 🤣
i looked at several videos regarding joins and believe me, your way of explaining the topic is the best.
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
6 minutes in and I already understand more than an online course I’m enrolled in. Subscribed!!😊
It's starts to get wild
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.
Ron Swanson redacting his birthday was a hilarious reference from the show hahaha
A gold mine of information. So happy I came across this boot camp.
First watch I could code along but only understand half. Second watch and I fully understand the content. Thanks Alex
I didn't understand anything at first but then it all fell into place. thank you