FREE Data Analytics Boot Camp Challenge #7 - SQL Joins
Channel: Albert Bellamy
Date: 02/08/2023

This is session number seven in our series of learning data analyst skills in the FREE Data Analyst Boot Camp with Alex Freberg, AKA Alex the Analyst. 

Today's video: SQL Intermediate Tutorial - simple JOINS!

Link to Alex's original video:   

 https://youtu.be/9URM1_2S0ho

Today we will learn how to use JOINs to combine tables in SQL and extract relevant data. 

The intermediate videos get a bit longer - this one is over 17 minutes. As a result, I've sped Alex up to 1.5 speed, and he's still understandable. 

We will pause and work through the commands, do a few sets of pushups, and just have a good time. 

This is the first video in the Intermediate series! 

As always, you will need MS SQL Server Management Studio and SQL Server downloaded to complete this exercise. 

Backstory: Recently, my friend Matias Baudino challenged me to do 50 pushups for every one of the 57 videos in this boot camp series. Welp, I am not one to back down from a challenge regarding either exercise or data. So here goes: Pushups 301-350 for this video. (I did the other 25 off camera - I'm out of practice on these videos, gimme a break)

Here is the script you will need to augment your data tables: 

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)

I will upload the full scripts to my Github: 

https://github.com/logdog0411