Intermediate SQL Tutorial | Inner/Outer Joins | Use Cases

In today's Intermediate SQL lesson we walk through Joins. Joins allow us to combine several tables, choose columns from each table, and use them in a single output.

All Topics Covered: Joins, Unions, Case Statements, Updating/Deleting Data, Partition By, Data Types, Aliasing, Views, Having Clause, GetDate(), Primary vs Foreign Key
____________________________________________

LINKS

____________________________________________

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:

Udemy Courses:

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

Websites:

____________________________________________

*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*

[AlexTheAnalyst]

TimeStamps:
Inner Join - 2:08
Outer Join - 4:08
Use Cases - 11:17

[cristianburich]

If anyone was looking for the new data in this video:

Insert into EmployeeDemographics VALUES
(1011, 'Ryan', 'Howard', 26, 'Male'),
(NULL, 'Holly', 'Flax', NULL, 'Male'),
(1013, 'Darryl', 'Philbin', NULL, 'Male')

Insert into EmployeeSalary VALUES
(1010, NULL, 47000),
(NULL, 'Salesman', 43000)

[delightogwor]

was going through an SQL course as part of a certification from a top company, watched the video on join 4 times couldn't understand, came to Alex's free boot camp, and understood in one go. Your my hero

[RandhawaAdi]

I have actually learned way more and remember concepts from your videos than the google certificate.

[lizsilva]

I cannot thank you enough for taking the time of sharing this with the rest of the world. You are very talented!

[celebrityaccess]

one of the best tutorial for data analyst on YouTube. Been practicing the tutorial for a while now and figured the names used for the table was from my favorite show "the office". Thanks

[farhianesar]

I was part of a paid bootcamp but I learned and understood the concepts a lot better from your free bootcamp than that paid one. Thanks a lot Alex. Highly appreciate your work.

[fauzeeyaabubakarsadeeq]

I am done with the SQL Basics, moving to the intermediate, thank you so much Alex!

[nellyp]

I tried many ways to understand the joins in a comprehensive way, but Alex was the only one that was properly explain it.
Thanks Alex!!

[polinat]

I cannot thank you enough for this simple explanation. I nearly exhausted my resources for JOINs and nobody ever explained well enough for me to understand.

[annessaolmos]

@AlexTheAnalyst, I want to take the time and thank you for making and sharing these videos. I am pursuing a degree in Information Systems, and I took a class in SQL, but your tutorial videos are easier to comprehend. I learned more in your short videos than I did in my class. You are amazing!!!!

[rosinasharon]

After struggling to understand joins today I came across this video and it was so simple and straight to the point . Shukran!

[reynardtcloete]

Bro, you explain things PROPERLY. Thank YOU.

[kumihuilu]

Watched the SQL Basics Tutorials and now on this in one day. Learned beter and faster and than in my school! cheers.

[stevenjacobs]

Really love your style with these videos. Using the office as a template for looking at these problems and techniques is such a fantastic way of going about it.

[prakashperam]

It is one of the best tutorials. Crystal clear explanation with use cases.

[jenineleonen]

I have been using JOINS forever but this is the only time I officially understand it and will be able to explain it to others.

[OlayinkaOgunlade]

Understanding Joins in SQL has really been a challenge for me and I can say with this video, Its a solution. So exemplifying. Thanks Alex.

[FemiDanalyst]

Thank you for this great and informative teaching Alex. I call you my unseen mentor who is constantly showing me the part to greatness. One day, I would make you proud In Nigeria and every household will know your name. THANK YOU BOSS

[kellyluangrath]

I’m so glad you explained what was the left and right table. I tried to Google and really couldn’t understand anyone’s explanation. But you made it so simple that I want to laugh at myself for not realizing the diff between left and right before. Thank you Alex