How lukebarousse/sql_project_data_job_analysis works
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: 2_create_tables.sql Job Market Database · 1_create_database.sql Create Database · 3_modify_tables.sql Modify Tables · 1_top_paying_jobs.sql Top-Paying Jobs
Components 11
Database Setup
- Create Database
sql_load/1_create_database.sql - Create Tables
sql_load/2_create_tables.sql - Modify Tables
sql_load/3_modify_tables.sql
Market Analysis
- Top-Paying Jobs
project_sql/1_top_paying_jobs.sql - Skills for Top Jobs
project_sql/2_top_paying_job_skills.sql - In-Demand Skills
project_sql/3_top_demanded_skills.sql - Skills by Salary
project_sql/4_top_paying_skills.sql - Optimal Skills
project_sql/5_optimal_skills.sql
SQL Practice
- SQL Practice Queries
advanced_sql
Other components
- Analyst
- Job Market Database
sql_load/2_create_tables.sql
Connections 18
- 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