# lukebarousse/sql_project_data_job_analysis architecture

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

- Interactive diagram: https://gitdiagram.com/lukebarousse/sql_project_data_job_analysis
- Repository: https://github.com/lukebarousse/sql_project_data_job_analysis

## Overview

This repository is a PostgreSQL SQL project for exploring data-analyst job-market data, alongside a set of SQL practice queries. The main workflow is an analyst running schema setup, then queries covering top-paying jobs, their skills, skill demand, skill-linked salaries, and skills that balance demand and pay. The README documents these analyses and PostgreSQL use; no source excerpts were provided, so the graph reflects documented query and database relationships rather than unverified internal wiring.

Main entry points: [`sql_load/2_create_tables.sql`](https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/sql_load/2_create_tables.sql) (Job Market Database), [`sql_load/1_create_database.sql`](https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/sql_load/1_create_database.sql) (Create Database), [`sql_load/3_modify_tables.sql`](https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/sql_load/3_modify_tables.sql) (Modify Tables), [`project_sql/1_top_paying_jobs.sql`](https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/project_sql/1_top_paying_jobs.sql) (Top-Paying Jobs)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_setup["Database Setup"]
  node_create_db["Create Database"]
  node_create_tables["Create Tables"]
  node_modify_tables["Modify Tables"]
end

subgraph group_analysis["Market Analysis"]
  node_top_jobs["Top-Paying Jobs"]
  node_top_job_skills["Skills for Top Jobs"]
  node_demand_skills["In-Demand Skills"]
  node_salary_skills["Skills by Salary"]
  node_optimal_skills["Optimal Skills"]
end

subgraph group_practice["SQL Practice"]
  node_sql_practice["SQL Practice Queries"]
end

node_analyst(("Analyst"))
node_market_db[("Job Market Database")]

node_analyst -->|"executes"| node_create_db
node_analyst -->|"executes"| node_create_tables
node_analyst -->|"executes"| node_modify_tables
node_create_db -->|"creates"| node_market_db
node_create_tables -->|"defines tables"| node_market_db
node_modify_tables -->|"alters tables"| node_market_db
node_analyst -->|"runs"| node_top_jobs
node_top_jobs -->|"queries"| node_market_db
node_analyst -->|"runs"| node_top_job_skills
node_top_job_skills -->|"queries"| node_market_db
node_analyst -->|"runs"| node_demand_skills
node_demand_skills -->|"queries"| node_market_db
node_analyst -->|"runs"| node_salary_skills
node_salary_skills -->|"queries"| node_market_db
node_analyst -->|"runs"| node_optimal_skills
node_optimal_skills -->|"queries"| node_market_db
node_analyst -->|"runs"| node_sql_practice
node_sql_practice -->|"queries"| node_market_db

click node_create_db "https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/sql_load/1_create_database.sql"
click node_create_tables "https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/sql_load/2_create_tables.sql"
click node_modify_tables "https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/sql_load/3_modify_tables.sql"
click node_market_db "https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/sql_load/2_create_tables.sql"
click node_top_jobs "https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/project_sql/1_top_paying_jobs.sql"
click node_top_job_skills "https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/project_sql/2_top_paying_job_skills.sql"
click node_demand_skills "https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/project_sql/3_top_demanded_skills.sql"
click node_salary_skills "https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/project_sql/4_top_paying_skills.sql"
click node_optimal_skills "https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/project_sql/5_optimal_skills.sql"
click node_sql_practice "https://github.com/lukebarousse/sql_project_data_job_analysis/tree/main/advanced_sql"

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_create_db,node_create_tables,node_modify_tables toneBlue
class node_top_jobs,node_top_job_skills,node_demand_skills,node_salary_skills,node_optimal_skills,node_market_db toneAmber
class node_sql_practice toneMint
class node_analyst toneIndigo
```

## Components

### Database Setup

- [Create Database](https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/sql_load/1_create_database.sql): `sql_load/1_create_database.sql`
- [Create Tables](https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/sql_load/2_create_tables.sql): `sql_load/2_create_tables.sql`
- [Modify Tables](https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/sql_load/3_modify_tables.sql): `sql_load/3_modify_tables.sql`

### Market Analysis

- [Top-Paying Jobs](https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/project_sql/1_top_paying_jobs.sql): `project_sql/1_top_paying_jobs.sql`
- [Skills for Top Jobs](https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/project_sql/2_top_paying_job_skills.sql): `project_sql/2_top_paying_job_skills.sql`
- [In-Demand Skills](https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/project_sql/3_top_demanded_skills.sql): `project_sql/3_top_demanded_skills.sql`
- [Skills by Salary](https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/project_sql/4_top_paying_skills.sql): `project_sql/4_top_paying_skills.sql`
- [Optimal Skills](https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/project_sql/5_optimal_skills.sql): `project_sql/5_optimal_skills.sql`

### SQL Practice

- [SQL Practice Queries](https://github.com/lukebarousse/sql_project_data_job_analysis/tree/main/advanced_sql): `advanced_sql`

### Other components

- **Analyst**
- [Job Market Database](https://github.com/lukebarousse/sql_project_data_job_analysis/blob/main/sql_load/2_create_tables.sql): `sql_load/2_create_tables.sql`

## Connections

- Analyst → Create Database: executes
- Analyst → Create Tables: executes
- Analyst → Modify Tables: executes
- Create Database → Job Market Database: creates
- Create Tables → Job Market Database: defines tables
- Modify Tables → Job Market Database: alters tables
- Analyst → Top-Paying Jobs: runs
- Top-Paying Jobs → Job Market Database: queries
- Analyst → Skills for Top Jobs: runs
- Skills for Top Jobs → Job Market Database: queries
- Analyst → In-Demand Skills: runs
- In-Demand Skills → Job Market Database: queries
- Analyst → Skills by Salary: runs
- Skills by Salary → Job Market Database: queries
- Analyst → Optimal Skills: runs
- Optimal Skills → Job Market Database: queries
- Analyst → SQL Practice Queries: runs
- SQL Practice Queries → Job Market Database: queries