Our notes on Alex The Analyst

We wrote these notes when we read the Alex The Analyst site for our SQL comparisons. For each note, you see the day of our check and a link to the page that we read.

Alex The Analyst query check and help

  • We found no check on your queries. You compare your result with the video yourself. Checked October 20, 2026 (source)

Alex The Analyst SQL topics

  • In the chapter list, Alex names "Group By", "Having vs Where", "Joins", "Unions", "Subqueries", "Window Functions", "CTEs", "Temp Tables", "Stored Procedures" and "Triggers and Events". Checked October 20, 2026 (source)
  • In the GitHub repository that the description links, Alex gives a lesson script with his comments for each of these topics: "Group By + Order By", "Joins", "Subqueries" and "Window Functions". In the window functions script, Alex writes: "windows functions are really powerful and are somewhat like a group by - except they don't roll everything up into 1 row when grouping." Checked October 31, 2026 (source)

Alex The Analyst SQL engines

  • MySQL. In the description, Alex links the MySQL installer, and the chapter after the intro is "Installing MySQL and Setting up Database". Checked October 20, 2026 (source)

Alex The Analyst content and size

  • Learn SQL Beginner to Advanced in Under 4 Hours Checked October 20, 2026 (source)
  • Alex The Analyst Checked October 20, 2026 (source)
  • 4:04:58 (4 h 5 min) Checked October 20, 2026 (source)
  • English. YouTube shows one caption track: English (auto-generated). Checked October 20, 2026 (source)
  • In the description, Alex links a free GitHub repository ("Download Datasets"). In it, Alex gives 18 SQL files and one data file, layoffs.csv. The SQL files are a script that you run to make the course database, 15 lesson scripts and two project scripts. Checked October 20, 2026 (source)
  • We found no practice chapter in the chapter list and no exercise file in the GitHub repository. Checked October 20, 2026 (source)
  • Two chapters are projects on the layoffs.csv data: "Data Cleaning Project" (about 49 minutes) and "Exploratory Data Analysis Project" (about 33 minutes). Checked October 20, 2026 (source)
  • In the GitHub repository, Alex gives the data of both projects as layoffs.csv. At the top of the data-cleaning script, Alex links the Kaggle dataset "layoffs-2022", and you query the table world_layoffs.layoffs. In the EDA script, you query the cleaned copy of the same table. Checked October 21, 2026 (source)
  • We read the 20 files of the GitHub repository. We found no exercise. In each lesson script, Alex gives the queries with his comments. Checked October 31, 2026 (source)

Alex The Analyst certificate

  • None in the video. In the description, Alex links his "Full MySQL Course" on Analyst Builder. On that course page, Analyst Builder shows a certificate that you unlock when you complete the course. Checked October 20, 2026 (source)

Alex The Analyst updates

  • October 8, 2024 Checked October 20, 2026 (source)

Alex The Analyst strengths and limits

  • In about 4 hours, you learn GROUP BY, joins, subqueries and window functions, and then you use them in two projects on one dataset. Checked October 20, 2026 (source)
  • You get no practice exercises and no check on your queries. You type along with the video. Checked October 20, 2026 (source)

Alex The Analyst in our SQL comparisons