How alextheanalyst/mysql-youtube-series works
This repository is a collection of MySQL tutorial and portfolio SQL files, rather than an application with a runtime pipeline. Its apparent learning progression spans database setup and beginner queries, intermediate query techniques, advanced database features, and portfolio work on data cleaning and exploratory analysis. The tree also includes a layoffs CSV. The README gives only the series name, and no SQL excerpts are available, so the graph shows learner access to the materials but does not assume execution order, script dependencies, or which files use the CSV.
Main entry points: Beginner - Parks_and_Rec_Create_db.sql Database Setup · Beginner - Select Statement.sql SELECT · Beginner - Where Statement.sql WHERE · Beginner - Group By + Order By.sql Grouping and Ordering
Components 20
Beginner SQL
- Database Setup
Beginner - Parks_and_Rec_Create_db.sql - SELECT
Beginner - Select Statement.sql - WHERE
Beginner - Where Statement.sql - Grouping and Ordering
Beginner - Group By + Order By.sql - HAVING and WHERE
Beginner - Having vs Where.sql - Limits and Aliases
Beginner - Limit and Aliasing.sql
Intermediate SQL
- Joins
Intermediate - Joins.sql - CASE Statements
Intermediate - Case Statements.sql - String Functions
Intermediate - String Functions.sql - Subqueries
Intermediate - Subqueries.sql - Unions
Intermediate - Unions.sql - Window Functions
Intermediate - Window Functions.sql
Advanced SQL
- CTEs
Advanced - CTEs.sql - Stored Procedures
Advanced - Stored Procedures.sql - Temporary Tables
Advanced - Temp Tables.sql - Triggers and Events
Advanced - Triggers and Events.sql
Portfolio Project
- Data Cleaning
Portfolio Project - Data Cleaning.sql - Exploratory Analysis
Portfolio Project - EDA.sql - Layoffs CSV
layoffs.csv
Other components
- Learner
Connections 18
- Learner → Database Setup: studies
- Learner → SELECT: studies
- Learner → WHERE: studies
- Learner → Grouping and Ordering: studies
- Learner → HAVING and WHERE: studies
- Learner → Limits and Aliases: studies
- Learner → Joins: studies
- Learner → CASE Statements: studies
- Learner → String Functions: studies
- Learner → Subqueries: studies
- Learner → Unions: studies
- Learner → Window Functions: studies
- Learner → CTEs: studies
- Learner → Stored Procedures: studies
- Learner → Temporary Tables: studies
- Learner → Triggers and Events: studies
- Learner → Data Cleaning: studies
- Learner → Exploratory Analysis: studies