# alextheanalyst/mysql-youtube-series architecture

> Architecture diagram of the GitHub repository alextheanalyst/mysql-youtube-series, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-27). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/alextheanalyst/mysql-youtube-series
- Repository: https://github.com/alextheanalyst/mysql-youtube-series

## Overview

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`](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Beginner%20-%20Parks_and_Rec_Create_db.sql) (Database Setup), [`Beginner - Select Statement.sql`](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Beginner%20-%20Select%20Statement.sql) (SELECT), [`Beginner - Where Statement.sql`](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Beginner%20-%20Where%20Statement.sql) (WHERE), [`Beginner - Group By + Order By.sql`](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Beginner%20-%20Group%20By%20%2B%20Order%20By.sql) (Grouping and Ordering)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_beginner["Beginner SQL"]
  node_setup["Database Setup"]
  node_select["SELECT"]
  node_where["WHERE"]
  node_group_order["Grouping and Ordering"]
  node_having["HAVING and WHERE"]
  node_limit_alias["Limits and Aliases"]
end

subgraph group_intermediate["Intermediate SQL"]
  node_joins["Joins"]
  node_case["CASE Statements"]
  node_strings["String Functions"]
  node_subqueries["Subqueries"]
  node_unions["Unions"]
  node_windows["Window Functions"]
end

subgraph group_advanced["Advanced SQL"]
  node_ctes["CTEs"]
  node_procedures["Stored Procedures"]
  node_temp_tables["Temporary Tables"]
  node_triggers["Triggers and Events"]
end

subgraph group_portfolio["Portfolio Project"]
  node_cleaning["Data Cleaning"]
  node_eda["Exploratory Analysis"]
  node_layoffs_data["Layoffs CSV<br/>[layoffs.csv]"]
end

node_learner(("Learner"))

node_learner -->|"studies"| node_setup
node_learner -->|"studies"| node_select
node_learner -->|"studies"| node_where
node_learner -->|"studies"| node_group_order
node_learner -->|"studies"| node_having
node_learner -->|"studies"| node_limit_alias
node_learner -->|"studies"| node_joins
node_learner -->|"studies"| node_case
node_learner -->|"studies"| node_strings
node_learner -->|"studies"| node_subqueries
node_learner -->|"studies"| node_unions
node_learner -->|"studies"| node_windows
node_learner -->|"studies"| node_ctes
node_learner -->|"studies"| node_procedures
node_learner -->|"studies"| node_temp_tables
node_learner -->|"studies"| node_triggers
node_learner -->|"studies"| node_cleaning
node_learner -->|"studies"| node_eda

click node_setup "https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Beginner%20-%20Parks_and_Rec_Create_db.sql"
click node_select "https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Beginner%20-%20Select%20Statement.sql"
click node_where "https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Beginner%20-%20Where%20Statement.sql"
click node_group_order "https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Beginner%20-%20Group%20By%20%2B%20Order%20By.sql"
click node_having "https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Beginner%20-%20Having%20vs%20Where.sql"
click node_limit_alias "https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Beginner%20-%20Limit%20and%20Aliasing.sql"
click node_joins "https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Intermediate%20-%20Joins.sql"
click node_case "https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Intermediate%20-%20Case%20Statements.sql"
click node_strings "https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Intermediate%20-%20String%20Functions.sql"
click node_subqueries "https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Intermediate%20-%20Subqueries.sql"
click node_unions "https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Intermediate%20-%20Unions.sql"
click node_windows "https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Intermediate%20-%20Window%20Functions.sql"
click node_ctes "https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Advanced%20-%20CTEs.sql"
click node_procedures "https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Advanced%20-%20Stored%20Procedures.sql"
click node_temp_tables "https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Advanced%20-%20Temp%20Tables.sql"
click node_triggers "https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Advanced%20-%20Triggers%20and%20Events.sql"
click node_cleaning "https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Portfolio%20Project%20-%20Data%20Cleaning.sql"
click node_eda "https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Portfolio%20Project%20-%20EDA.sql"
click node_layoffs_data "https://github.com/alextheanalyst/mysql-youtube-series/blob/main/layoffs.csv"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_setup,node_select,node_where,node_group_order,node_having,node_limit_alias toneBlue
class node_joins,node_case,node_strings,node_subqueries,node_unions,node_windows toneAmber
class node_ctes,node_procedures,node_temp_tables,node_triggers toneMint
class node_cleaning,node_eda,node_layoffs_data toneRose
class node_learner toneIndigo
```

## Components

### Beginner SQL

- [Database Setup](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Beginner%20-%20Parks_and_Rec_Create_db.sql): `Beginner - Parks_and_Rec_Create_db.sql`
- [SELECT](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Beginner%20-%20Select%20Statement.sql): `Beginner - Select Statement.sql`
- [WHERE](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Beginner%20-%20Where%20Statement.sql): `Beginner - Where Statement.sql`
- [Grouping and Ordering](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Beginner%20-%20Group%20By%20%2B%20Order%20By.sql): `Beginner - Group By + Order By.sql`
- [HAVING and WHERE](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Beginner%20-%20Having%20vs%20Where.sql): `Beginner - Having vs Where.sql`
- [Limits and Aliases](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Beginner%20-%20Limit%20and%20Aliasing.sql): `Beginner - Limit and Aliasing.sql`

### Intermediate SQL

- [Joins](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Intermediate%20-%20Joins.sql): `Intermediate - Joins.sql`
- [CASE Statements](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Intermediate%20-%20Case%20Statements.sql): `Intermediate - Case Statements.sql`
- [String Functions](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Intermediate%20-%20String%20Functions.sql): `Intermediate - String Functions.sql`
- [Subqueries](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Intermediate%20-%20Subqueries.sql): `Intermediate - Subqueries.sql`
- [Unions](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Intermediate%20-%20Unions.sql): `Intermediate - Unions.sql`
- [Window Functions](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Intermediate%20-%20Window%20Functions.sql): `Intermediate - Window Functions.sql`

### Advanced SQL

- [CTEs](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Advanced%20-%20CTEs.sql): `Advanced - CTEs.sql`
- [Stored Procedures](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Advanced%20-%20Stored%20Procedures.sql): `Advanced - Stored Procedures.sql`
- [Temporary Tables](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Advanced%20-%20Temp%20Tables.sql): `Advanced - Temp Tables.sql`
- [Triggers and Events](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Advanced%20-%20Triggers%20and%20Events.sql): `Advanced - Triggers and Events.sql`

### Portfolio Project

- [Data Cleaning](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Portfolio%20Project%20-%20Data%20Cleaning.sql): `Portfolio Project - Data Cleaning.sql`
- [Exploratory Analysis](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/Portfolio%20Project%20-%20EDA.sql): `Portfolio Project - EDA.sql`
- [Layoffs CSV](https://github.com/alextheanalyst/mysql-youtube-series/blob/main/layoffs.csv): `layoffs.csv`

### Other components

- **Learner**

## Connections

- 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