Learn SQL Beginner to Advanced in Under 4 Hours

____________________________________________

RESOURCES:

Coursera Courses:

Udemy Courses:

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

____________________________________________

Websites:
📱Instagram: @Alex_The_Analyst
____________________________________________

0:00 Intro
0:52 Installing MySQL and Setting up Database
11:19 Select Statement
21:47 Where Clause
33:54 Group By
44:18 Having vs Where
47:41 Limit and Aliasing
51:10 Joins
1:08:04 Unions
1:15:10 String Functions
1:26:39 Case Statements
1:35:16 Subqueries
1:45:58 Window Functions
1:58:55 CTEs
2:09:07 Temp Tables
2:16:34 Stored Procedures
2:28:51 Triggers and Events
2:42:46 Data Cleaning Project
3:32:14 Exploratory Data Analysis Project

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

[palaceprincess]

This video SAVED ME. Yesterday I knew nothing about SQL (mind you, I am a biochemist with limited coding background). Had a technical job interview today that required me to write queries in SQL and I aced it, all thanks to this tutorial!

[joeychandel]

Timestamps
00:03 - Learn SQL fundamentals and advanced techniques through practical exercises.
01:52 - Installing MySQL with Developer Default Setup.
05:27 - Completing MySQL configuration and starting the local instance.
07:12 - Creating a sample database for SQL practice.
11:14 - Understanding the SELECT statement in MySQL for querying data.
13:11 - Understanding SQL query execution and database selection best practices.
17:24 - Understanding the order of operations in SQL calculations.
19:27 - Understanding unique values and distinct queries in SQL.
23:12 - Understanding salary comparison operators in SQL queries.
25:17 - Filtering data using 'not equal' and logical operators in SQL.
29:23 - The LIKE statement allows for pattern matching in SQL queries.
31:36 - Using wildcards in SQL for flexible string matching.
35:29 - Understanding non-aggregated columns in SQL grouping.
37:25 - Learn to group data by occupation and salary using SQL.
41:26 - Understanding SQL ordering by multiple columns impacts output results.
43:22 - Understand the risks of using column positions in SQL queries.
47:25 - Understanding SQL HAVING clause and LIMIT for data filtering.
49:18 - Understanding SQL aliasing for clearer query outputs.
53:08 - Joining tables with INNER JOIN requires specifying ambiguous column names.
55:07 - Using aliases simplifies SQL queries for better readability.
58:53 - Explains SQL joins: Left, Right, and Self Joins with practical examples.
1:00:46 - Understanding table joins and employee ID assignment in SQL.
1:04:49 - Understanding reference tables and joining in SQL.
1:06:49 - Using joins to tie multiple SQL tables together effectively.
1:10:35 - Using UNION to combine query results from different tables.
1:12:38 - Filtering and labeling employees based on salary and gender criteria.
1:16:40 - Data cleaning techniques include ensuring length and standardizing case.
1:18:31 - Learn string manipulation functions in SQL, including trim, left, right, and substring.
1:22:13 - Utilizing substring and replace functions for effective data extraction.
1:24:09 - Learn to use SQL functions for text manipulation.
1:27:55 - Using CASE statements to categorize age groups in SQL queries.
1:29:53 - Calculate pay increases and bonuses based on employee salaries.
1:34:13 - Learn to use CASE statements and subqueries for SQL logic and calculations.
1:36:15 - Using subqueries to filter employee demographics based on department IDs.
1:40:21 - Calculating the overall average salary from the employee data.
1:42:25 - Understanding SQL table naming and aggregations with examples.
1:46:18 - Comparing group by and window functions in SQL for salary analysis.
1:48:19 - Calculating average salary with and without partitioning by gender.
1:52:45 - Understanding rolling totals and window functions in SQL.
1:54:34 - Row numbering and partitioning in SQL helps organize data uniquely.
1:58:33 - Understanding Row Number, Rank, and Dense Rank in SQL.
2:00:20 - Using Common Table Expressions (CTE) improves SQL query readability and functionality.
2:04:04 - Common Table Expressions (CTEs) allow temporary data representation without storage.
2:06:18 - Combining data from common table expressions using SQL joins.
2:10:12 - Creating and using temporary tables in SQL.
2:12:09 - Creating and using temporary tables in SQL effectively.
2:16:08 - Understanding advanced CTEs and the creation of stored procedures.
2:18:00 - Created and executed a stored procedure successfully.
2:21:45 - Understanding stored procedures and best practices in SQL.
2:23:46 - Creating and managing stored procedures in SQL.
2:27:18 - Parameter naming conventions enhance SQL readability.
2:29:02 - Using triggers to automatically update related tables in SQL.
2:32:48 - Understanding SQL triggers for automated data insertion.
2:34:51 - Using triggers in SQL to automate actions on data changes.
2:38:38 - Creating an event to retire employees over 60 automatically.
2:40:37 - Creating and troubleshooting SQL events for data deletion.
2:44:04 - Learn how to import data into a new SQL table.
2:45:44 - Overview of data cleaning steps using a layoffs dataset.
2:49:31 - Ensure data integrity by removing duplicates in a staging database.
2:51:13 - Using SQL to identify duplicate entries with ROW_NUMBER() function.
2:55:21 - Removing duplicates in MySQL involves different strategies than in SQL Server.
2:57:08 - Creating and populating SQL tables with data and filtering rows.
3:01:17 - Learn how to update SQL tables and manage preferences for safe updates.
3:03:10 - Standardize industry labels for accurate data analysis.
3:07:20 - Fixing data issues in SQL by trimming unwanted characters.
3:09:33 - Updating country data and converting text to date format.
3:13:22 - Updating and formatting date columns in SQL.
3:15:11 - Modifying data types and handling null values in SQL.
3:19:28 - Updating travel industry data using SQL joins.
3:21:24 - Identifying companies with missing and non-null industry data.
3:25:42 - Resolved issues with null values in SQL queries for company layoffs.
3:27:47 - Cleaning data is crucial for accurate analysis of layoffs.
3:31:35 - Data cleaning is essential for effective exploratory data analysis.
3:33:17 - The basics of analyzing layoffs data using SQL.
3:37:13 - Analyzing employee layoffs among major companies from 2020 to 2023.
3:39:10 - Analysis of job layoffs by industry and country during COVID-19.
3:43:09 - Analyzing post-IPO layoffs and their implications.
3:45:04 - Calculating monthly rolling totals for layoffs using SQL.
3:49:12 - Creating a rolling total for layoffs by month in SQL.
3:51:18 - Job layoffs significantly increased from 2020 to 2023 globally.
3:55:07 - Ranking companies by employee layoffs over the years using SQL.
3:57:09 - Analyze company layoffs over the years using SQL ranking functions.
4:01:34 - Recap of complex SQL query using CTEs for analyzing layoffs.
4:03:25 - Explore advanced SQL projects and enhance your portfolio with real data analysis.

[Nathaniel-codecity]

thank you so much for your free youtube course with your bootcamp, I'm now a data analytics instructor in Lagos, Nigeria.

[amazingme]

Hey alex, please never die or delete your channel, I'm lost with what career to get after getting a useless degree and have no technical skills for a job, currently unemployed and living with aging mom, so I'm considering following your channel in the near future after i get over my mental slump. APPRECIATE YOU!!

[ZaulT-jp]

Dude, this is the greatest SQL tutorial on Youtube. Covers all the important topics with great examples and communication. Thank you so much!

[zohraserhenova]

Wow! I was just looking for a comprehensive SQL tutorial which was not 10 years old lol. Thank you! Right on time :)

[MwishaLudack]

Your tutorials are the best. Let me just say that I watched the others, but you are by far the most clear instructor I've watched so far. Thank you

[Kirito_]

I am Starting my Data Analyst/Science Journey with this (Big Thanks from me to Alex, he is the best to give us such course for free, that would really help alot of us to learn), i am sharing my progression (if no one mind)

My Progress 17/03/2025, i will go slowly:

Day 1:
#1 (0:00) - (0:51) Intro
#2 (0:52) - (11:18) Installing MySQL and Setting up Database
#3 (11:19) - (21:46) Select Statement

Day 2:
#4 (21:47) - (33:53) Where Clause

Day 3:

[YannikSpeath]

I literally have an SQL Joints test tomorrow and have to binge this entire thing. Thank you so much for this awesome Course!

[willyamwambugu]

Hello Alex, thank you for your continued support in helping me(us) a beginner in SQL understand it in pursuit of upskilling. Just an observation, I don't know if it's me only or anyone else, but while installing the MySQL on my laptop, the workbench, router and samples execution were absent, though I followed your steps, opened the installer again, it prompted me to a UI with add, upgrade, modify and catalog buttons, chose the catalog option and selected the MySQL workbench, router and samples and installed them manually from the catalog. If anyone else experienced this too leave a comment here to help others learn.

[Harold]

Thank you Alex, You are by far one of my favorite youtube channels about data and technical skills. I am still in the learning process and I am thankful for your free resources. Thanks a lot!

[MR.JAM_]

By the way i have completed your EXCEL TUTORIAL FOR DATA ANALYST and i was about to go for SQL and finally you posted this video today 😅

[randomytnametonotshowrealname]

Hey @Alex The Analyst,
thank you very much for this video. It was really easy to follow and I actually had fun learning SQL. SQL just seems so easy to understand and all the commands make so much sense. I noticed at 3:07:11 that there were two locations that appeared twice in the data set, Malmo/Malmö and Dusseldorf/Düsseldorf. It seems like the person who inserted these data rows used the umlaut from the native spelling which causes problems if it is not imported through the right encoding method. It's a very detailed and minor thing but if you want to calculate with this data, e.g. which cities in Germany or Sweden had the highest layoffs, and be 100% accurate then the locations need to be combined. Anyway, thank you for this condensed SQL tutorial.

[kartikarorayt]

Thank God I found your channel. I purchased a BootCamp but found nothing worth learning about data analysis. Keep inspiring like this. God bless.

[kshmaysdiary]

hey alex,
just completed this course.
loved and understood every bit of it.
cool, concise and just gets the job done.
thank you for providing this for free.
on course to cover more of your playlists..
python is next 🐍

[tibetanbuddhismstudy]

The basic and advance SQL are clearly explained! super helpful! Thanks!

[RohitGupta-yehe]

Thank You So much Alex, I was just in search of a quick revision of SQL for my upcoming interview, this video just came on time :)

[alexgraham]

Nearing the end of this as a refresher, not a SQL admin by any stretch but been great to remind myself due to being an Solution Arch of all these data aspects to a solution which allows me to have enough of an understanding when speaking with engineers, especially when my background before cloud was really Infra ( I'll build you a datacentre ). Thanks for the effort Alex.

[Jennifer_]

How'd you know i wanted to learn SQL??? Thank you Alex for this video!!! I cant wait to watch it, take notes, and actually be able to do stuff in SQL!!!! I'm so excited!!!! ☺️ Thank you, thank you and big thank you!!!!

[Sankalp-sdfm]

34:10 group by, order by
44:18 having vs where