Back to All CourseworkDatabase Management System
Individual Practice & CurriculumFeb 2026Interactive Web Demo

38 SQL Exercises on PostgreSQL Analytics

A curriculum of 38 progressive SQL queries written for PostgreSQL over a normalized job-postings schema covering aggregation, windowing, subqueries, and CTEs.

My Contribution: I authored all thirty-eight analytical queries, edge-case fixes, and query plan notes.
PostgreSQLPostgreSQLSQLRelational AlgebraCTEsAnalytics
Live Browser Simulation

Analytical Query Catalog & Solutions

Client-Side Engine
Try this: Browse queries from fundamental filtering to multi-level CTE aggregations.

Loading simulation engine...

Architecture verification: PostgreSQL compliant queries authored and benchmarked against relational datasets.

Implementation Highlights

  • Normalized star/snowflake schema: job_postings_fact, company_dim, skills_dim, and skills_job_dim.
  • Complex aggregations: salary trends by skill combinations, remote posting ratios, and year-over-year demand.
  • Advanced techniques: recursive Common Table Expressions (CTEs), CASE branching, and date-truncation grouping.
  • Comparative query analysis highlighting index utilization and NULL handling nuances.

Algorithm & System Mechanics

  • Bridges fact and dimension tables through associative link tables to model many-to-many skill requirements.
  • CTEs modularize multi-pass aggregation for clear query plan evaluation.