Learn SQL Beginner to Advanced in Under 4 Hours

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!

@22:00 where clause @26:30 logical operators @29:55 Like clause @34:30 Group By @40:00 Order BY @45:15 Having @47:45 Limit & Aliasing @51:10 Joins @57:20 Outer Joins @1:11:25 UNIONs @1:15:14 String Functions @1:26:40 CASE Statements @1:35:15 Sub Queries @1:46:00 Windows Functions @1:59:16 CTEs - Common Table Expressions @2:09:11 Temp Tables @2:16:38 Stored Procedures @2:29:10 Triggers and Events @2:42:50 Data Cleaning Project @3:32:20 Exploratory Data Analysis Project

I'm a data analyst in training, and this tutorial is all I need to get started with SQL. I can't thank you enough, Alex

This January has been about recalibration — navigating layoffs and transitioning toward a Data Analyst role with a BA degree and 3 years of IT experience. Still figuring things out, learning, and staying hopeful. Open to insights from anyone who’s been through a similar transition.

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

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

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.

I am so glad to have SELECT(ed) this video !

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

As a 41 year old trying to get a job using SQL you really didn't give me hope when you did a query about pushing "old" people out of the company and the old age was 40...