How karanmallik65/sql_project_data_job_analysis works
Project type and purpose
• This is a data-analysis project built entirely around SQL scripts. There is no “application server” or UI code—rather it’s a repository of database-definition, table-creation, ETL, and exploratory query scripts plus generated visualization assets (PNG graphs).
• Its purpose is to load job-posting data into PostgreSQL, run a series of analytical queries to answer questions about salaries and in-demand skills, then produce charts and tables for reporting.
File structure
• Top-level files:
• .gitignore, README.md
• assets/ (contains output images)
• Two SQL script directories:
• sql_load/: database bootstrap and schema-modification scripts in execution order
• project_sql/: analytical queries (1_top_paying_jobs.sql … 5_optimal_skills.sql)
• There are no application code files, no frontend or backend folders—this is purely a data pipeline and analysis pipeline.
README for additional insights
• It describes five business questions, the stack (PostgreSQL, SQL, VSCode, GitHub) and shows sample queries and visuals.