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

Joins image: https://www.got-it.ai/solutions/sqlquerychat/sql-help/data-query/how-to-join-tables-in-sql-querychat/

____________________________________________

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:

Favorite Courses:
Coursera Data Analysis Specialization - https://bit.ly/3dYJ6w0
Coursera Tableau Data Visualization - https://bit.ly/2AHCNPd
Coursera Database and SQL for Data Science - https://bit.ly/2zUk0zL
Coursera Data Analysis with Python - https://bit.ly/3geiVDG

Favorite Books:
Python for Data Analysis Book - https://amzn.to/3dDneGq
SQL Beginner's Guide to Managing and Analyzing With SQL Book - https://amzn.to/2X5341B

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

Websites:
GitHub: https://github.com/AlexTheAnalyst

____________________________________________

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

Видео Intermediate SQL Tutorial | Inner/Outer Joins | Use Cases канала Alex The Analyst