
Already know some of this? A 2-minute test skips the lessons you know.
Take the placement testA free 22-lesson course built from Alex The Analyst's 4h 05m of YouTube video. 3 days at 90 minutes a day, with study notes and a quiz in every lesson. A 2-minute placement test skips what you already know.
Taught by Alex The Analyst on YouTube. Videos play in YouTube's own player, so the creator keeps every view.
Download and install MySQL Community Server and Workbench, configure the server as a Windows service, and create the Parks and Recreation sample database with employee tables.
Write SELECT queries to retrieve specific columns, use aliases, perform arithmetic with PEMDAS order, and apply DISTINCT to find unique values.
Filter rows using comparison operators, combine conditions with AND/OR/NOT, use parentheses for precedence, and apply LIKE with wildcards for pattern matching.
Group rows by one or more columns, calculate aggregates like COUNT, AVG, MIN, MAX, and understand how grouping changes result granularity.
Join tables on matching keys using INNER, LEFT, and RIGHT joins, resolve ambiguous columns with aliases, and perform a self-join for a Secret Santa assignment.
Chain joins through a bridge table (employee_salary) to connect employee_demographics to parks_department using department_id.
Manipulate text data using length, case conversion, trimming, substring extraction, replacement, position location, and concatenation.
Apply IF/ELSE logic in queries to calculate salary raises, department bonuses, and categorize ages into brackets.
Nest queries inside WHERE (IN operator), SELECT (scalar subquery), and FROM (derived table) to filter, compare, and aggregate in steps.
Compute aggregates without collapsing rows, partition data for row numbers, ranks, and dense ranks, and add running totals with ORDER BY.
Create named, readable subqueries with WITH, chain multiple CTEs, alias output columns, and query the CTE like a temporary view.
Create session-scoped temp tables via CREATE TEMPORARY TABLE or CTAS, insert filtered data, and use them for multi-step transformations.
Encapsulate reusable logic in stored procedures, change delimiters for compound statements, add input parameters, and call procedures with CALL.
Automate actions on INSERT with BEFORE/AFTER triggers, synchronize tables via self-joins, and schedule recurring tasks with CREATE EVENT.
Import raw layoffs CSV into a staging table, remove exact duplicates with ROW_NUMBER and a temp table, trim company names, standardize industry values, convert blanks to NULL, populate missing industries via self-join, drop rows with missing layoff counts, and remove helper columns.
Import raw layoffs CSV into a staging table, remove exact duplicates with ROW_NUMBER and a temp table, trim company names, standardize industry values, convert blanks to NULL, populate missing industries via self-join, drop rows with missing layoff counts, and remove helper columns.
Import raw layoffs CSV into a staging table, remove exact duplicates with ROW_NUMBER and a temp table, trim company names, standardize industry values, convert blanks to NULL, populate missing industries via self-join, drop rows with missing layoff counts, and remove helper columns.
Import raw layoffs CSV into a staging table, remove exact duplicates with ROW_NUMBER and a temp table, trim company names, standardize industry values, convert blanks to NULL, populate missing industries via self-join, drop rows with missing layoff counts, and remove helper columns.
Import raw layoffs CSV into a staging table, remove exact duplicates with ROW_NUMBER and a temp table, trim company names, standardize industry values, convert blanks to NULL, populate missing industries via self-join, drop rows with missing layoff counts, and remove helper columns.
Explore cleaned layoffs data with max layoffs, failed companies, group by company/year for totals, extract month with SUBSTRING for monthly trends, compute rolling sums with window functions, and build a multi-CTE query to rank top-5 layoff companies per year using DENSE_RANK.
Explore cleaned layoffs data with max layoffs, failed companies, group by company/year for totals, extract month with SUBSTRING for monthly trends, compute rolling sums with window functions, and build a multi-CTE query to rank top-5 layoff companies per year using DENSE_RANK.
Explore cleaned layoffs data with max layoffs, failed companies, group by company/year for totals, extract month with SUBSTRING for monthly trends, compute rolling sums with window functions, and build a multi-CTE query to rank top-5 layoff companies per year using DENSE_RANK.