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.
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.