Iron Query app icon
SQL for aspiring data analysts

Learn SQL the way analysts actually use it

Take your first steps toward becoming a data analyst by using SQL to solve real business problems. Practice the PostgreSQL queries analysts rely on, from joins and aggregates to CTEs and window functions, each checked against a realistic dataset with instant, honest feedback.

Download on the Mac App Store

Free for 7 days, then $29.99 one-time.

Iron Query in dark mode Iron Query showing a monthly revenue query and results
Why Iron Query

Every task starts with a real business question

"Which retention offers are actually working?" "What's our net revenue after refunds?" "Who are our highest-value customers by plan?" You write the SQL to answer it — against a realistic dataset of customers, subscriptions, invoices, and campaigns.

Curriculum

102 hands-on tasks, four tiers

Structured like a career path, from your first filter to multi-CTE queries with window functions.

  • Jr. Analyst — filtering, aggregation, single-table queries
  • Analyst — joins, date bucketing, HAVING
  • Sr. Analyst — window functions, gaps-and-islands, cohort analysis
  • Lead Analyst — multi-CTE queries and the advanced patterns working analysts use daily
Iron Query curriculum and task detail Iron Query monthly revenue query with results Iron Query complex multi-CTE window function query Iron Query completed task with result code
Under the hood

Learn PostgreSQL, the open-source SQL the industry runs on

Iron Query runs on a fast, embedded database, with a translation layer that converts common PostgreSQL syntax automatically — so the SQL you practice here is the SQL you'd write as a professional Data Analyst. A built-in reference documents exactly what works as-is, what's translated, and what isn't supported, so there's never any guesswork about the dialect you're learning.

✓

Instant correctness checks

Every task is checked against a validated reference answer, so you know your query actually solved the problem — not just that it ran.

✓

Built for the Mac

A genuinely native macOS app — fast, offline, no ads, no account required, nothing sent anywhere.

✓

Free 7-day trial

Every tier is unlocked from the start. Take the full week to work through the tasks before deciding it's for you.

Start answering business questions with SQL

Free for 7 days on the Mac App Store.

Download on the Mac App Store