FREE Data Analytics Boot Camp Challenge #6 - SQL Basics
Channel: Albert Bellamy
Date: 21/02/2023

This is session number six 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 Basics Tutorial For Beginners - GROUP BY and ORDER BY statements! 

Link to Alex's original video: https://youtu.be/LXwfzIRD-Ds 

Today we will learn how to use the GROUP BY and ORDER BY statements to further refine the results returned from a query by grouping, aggregating and sorting those results. 

As with all the Basics videos, this one is quite short - 8 minutes for Alex's original. We will pause and work through the commands, do a few sets of pushups, and just have a good time. 

This is the last Basics video before starting 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 251-300 for this video. 

#data #datascience #dataanalytics #dataanalysis #dataanalyst #excel #SQL #Tableau #PowerBI #Python #bootcamp #datajobs