How aritro19g/sql_project_data_jobs works
This repository is a PostgreSQL analysis project for identifying salary, skill-demand, and skill-pay patterns in India’s non-remote data analyst job market. The documented workflow prepares a database schema, then runs five separate SQL analyses whose results inform career decisions. The SQL files and README support the analysis scope and database relationship; no source excerpts show dataset loading or query execution wiring, so those links are omitted.
Main entry points: 1_create_database.sql Create database · 2_create_tables.sql Create tables · 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 - Highest-paying skills
project_sql/4_top_paying_skils.sql - Optimal skills
project_sql/5_optimal_skills.sql
Other components
- Career researcher
- Job postings data
- PostgreSQL database
Connections 16
- Career researcher → Create database: prepares schema
- Create database → PostgreSQL database: creates
- Career researcher → Create tables: prepares schema
- Create tables → PostgreSQL database: creates tables
- Career researcher → Modify tables: updates schema
- Modify tables → PostgreSQL database: alters tables
- Career researcher → Top-paying jobs: runs analysis
- Top-paying jobs → PostgreSQL database: queries
- Career researcher → Skills for top jobs: runs analysis
- Skills for top jobs → PostgreSQL database: queries
- Career researcher → In-demand skills: runs analysis
- In-demand skills → PostgreSQL database: queries
- Career researcher → Highest-paying skills: runs analysis
- Highest-paying skills → PostgreSQL database: queries
- Career researcher → Optimal skills: runs analysis
- Optimal skills → PostgreSQL database: queries