Unions in MySQL | Intermediate MySQL

Full MySQL Course: www.analystbuilder.com/course...
In this lesson we are going to take a look at Unions 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

[@obed_m16]

Apart from learning Data Analysis, I'm also learning satire. Thank you man.😄

[@qamaruddinkhichi904]

Hello Alex, let me thank you with the core of my heart from Pakistan. The way you teach SQL is the best way I have ever experienced. I have completed your SQL Server courses (Beginners - Advanced) and beginners series of MySQL, now, eagerly waiting for complete intermediate and advanced series of MySQL.

[@IzzyChopChop]

Very helpful and clear tutorial about Unions, so thank you! Your videos are very helpful to refresh my SQL knowledge and learn new stuff to help me prep for my data analyst job search

[@SomeStatus]

Love these! Went through the Business Analyst MySQL course on Udemy, started to do some more project learning now. These snippets of information are a great help.

[@dakshbhatnagar]

I loved it when he said “so that our job is still secure” 😂

[@ifeomajames8702]

Yea the job market is tough these days 😂

[@rootyroot]

Used SQL for years when I was younger (mainly for web development projects - PHP) but not really used it for a good few years (Still use it slightly for PowerBi but have not had to write queries for ages), just refreshing my SQL knowledge before my Data Engineer interview, I forgot about UNIONS and WINDOW functions.. oops. Thanks for the great content it's all coming back to me

[@juwonoluwole5609]

big up Alex, great course!

[@walk4754]

"If someone is over 50 years old, we're gonna try to push them out" Sir that's ILLEGAL 🤣

[@ramazanali1367]

This nice program of yours is so good & has been a very nice help for me in many ways, especially MySQL Database Management Currier. I have been learning a lot through Your KZbin Channel. I have downloaded most of the SQL courses from beginners to Advanced courses. Thanks a million, man. You became a nice teacher for me.

[@AlexTheAnalyst]

Great to hear!

[@aaron-evans-cruz]

Most thorough tutorial on what a UNION can actually do, just love these videos as always Alex. Also, notice from previous video on JOINS, there is no FULL OUTER JOIN in MySQL. You need to do it via a UNION I'm guessing by combining a LEFT and RIGHT join?

[@onazeumoru162]

THANK YOU ALEX😊😊

[@Robert-sb1fp]

Can you do a video on BI analyst vs data analyst

[@user-kq3tc5tu1c]

[NOTE: Just copied this comment from the STRING FUNCTIONS lesson where I had entered it by mistake. 😜] Well, that was fun! Ending my day with Alex the Analyst while my lovely Bride is preparing dinner (I'm one lucky 'Wanna-Be-Data-Nerd'). Somehow UNION just makes more sense than JOINS for me. I just need more exposure and practice - like this Intermediate MySQL Series for example. Thanks again Alex!

[@mjb070781]

Don't push out those older employees LOL

[@AlexTheAnalyst]

It’s corporate - I can’t control it. Sorry. 😞

[@KylianMbappe07303]

quick note if you have UNEQUAL ROWS set the columns which are present on the econd database table but not the fist database table as NULL set the columns which are present on the first database table but not the second database table as NULL since union actually merges so it will create additional rows to merge those columns NOW IF WE PUT NUILL IT WILL MATCH THE UMBER OF ROWS

[@preetshah3793]

Please sir make a video on SPSS

[@user-lm9di2cw2z]

hello alex, where can we get this dataset for practice

[@riomouris4767]

If you go back to his SQL Studio setup video, he manually creates the table using CREATE TABLE, then I think you'd have to add the first/last name columns to salary table

[@ifeomajames8702]

You’re making more than 70 sure the parks department is gonna try and get rid of you 😂😂😂😂

[@efloop6335]

wow

[@Dhikrdua]

What's the use of Union? To fire people😂😂😂

[@MikeM-uy6qp]

What a weird use case, discriminating against employees over 40 ( 'Old men" and 'Old Ladies') and cutting salaries or firing high-paid employees. "i've done something similar to this in my real job.' Charming.