SQL Projects (Real Data, Real Portfolio)

The best SQL projects are real queries on real data, not exercises. These are real SQL problems you solve in a live cloud workspace - window-function rankings, a slow query to tune, a schema to model - each one a portfolio piece.

Why real data beats exercises

Exercises teach syntax; real data teaches the judgment that gets you hired - the right query, why it is slow, how to model the schema. These practice that.

18 projects to start with

Add a NOT NULL Column With a Zero-Downtime BackfillBackend · Senior Build a Kimball Star SchemaData · Senior Replace LIKE Search With Postgres Full-Text SearchFullstack · Senior Fix the N+1 QueryBackend · Mid Stop a Double-Charge Race ConditionBackend · Mid Build a Staging-to-Marts dbt ProjectData · Mid Implement SCD2 With dbt SnapshotsData · Mid Implement the Outbox Pattern (At-Least-Once)Data · Mid Plug a Postgres Connection Pool LeakDevOps · Mid Index a Slow Postgres Search QueryDevOps · Mid Make an App Wait for Postgres on StartupDevOps · Mid Migrate a Postgres Database With Zero DowntimeDevOps · Mid Wire React to Supabase (CRUD + Realtime)Fullstack · Mid Repair Broken API PaginationBackend · Junior Add a Health Check Endpoint in GoBackend · Junior Switch to Cursor-Based PaginationBackend · Junior Make an ETL Pipeline IdempotentData · Junior Speed Up a Slow SQL Report QueryData · Junior

Pick by the skill to show

Analytics depth? The window-function and aggregation ones. Performance? The tuning ones. Each finished fix is evidence on your portfolio.

Build your portfolio free. You are in a real cloud workspace in 30 seconds - fix real systems, show real work.

Start free →