SQL GRITDIRTY DATA ONLY

The 300 MAANG & Startup Interview Curriculum

Zero Fake Toy Schemas • 100% Free Forever

STOP WRITING QUERIES ON FAKE CLEAN DATA.

Solving 500 simple queries on a clean, single-table tutorial database will teach you less than solving 30 messy multi-table business problems with missing values, duplicate keys, and performance bottlenecks.

The 300 Questions Master Roadmap
▶Level 1: 100 Basic Questions (SELECT, WHERE, NULLs, dirty JOINs)
▶Level 2: 100 Intermediate Questions (CTEs, Window Functions, DENSE_RANK)
▶Level 3: 100 Advanced Questions (Shitty schemas, recursive CTEs, cohorts)
Real MAANG Questions No Expensive Paywalls Dedicated Level Badges
REALITY CHECK SIMULATOR
WHAT HAPPENS AT REAL JOBS & MAANG INTERVIEWS:🔥💀
-- Shitty schema alert: No foreign keys, trailing spaces, duplicate IDs!
WITH deduplicated_orders AS (
SELECT order_id, TRIM(both ' ' from user_id) as uid,
DENSE_RANK() OVER (PARTITION BY uid ORDER BY timestamp DESC)
)
URGENT SLACK MESSAGE FROM VP OF FINANCE:

"@here The board meeting is in 12 minutes! The investor deck says our ARR is negative $3.2M because of webhook double-charging and duplicate currency conversions! Exclude refunded transactions with missing dates and fix this query NOW!"

✓ This is what SQL GRIT trains you to solve across 300 real levels.
Real Interview Tested
The Master Curriculum

3 TIERS • 100 QUESTIONS EACH • 300 TOTAL

Complete these 300 levels on messy real-world databases and you can crack any SQL technical screen in the world.

Level 1 Milestone100 Curated Challenges

Tier 1: The Mud Scrapper (Basic)

Foundations on Dirty Real-World Schemas

Writing SELECT, WHERE, aggregates, GROUP BY, HAVING, and multi-table JOINs on un-sanitized operational data with NULLs, whitespace, and duplicate keys.

Core SQL Concepts Mastered
  • ✓SELECT, WHERE filtering, and logical operators with NULL quirks
  • ✓String normalization (TRIM, LOWER, LIKE regex patterns)
  • ✓Aggregations: COUNT(DISTINCT) vs COUNT(*), SUM, AVG with COALESCE
  • ✓GROUP BY and HAVING on dirty categorical fields
  • ✓INNER, LEFT, and RIGHT JOINs avoiding accidental fanouts
  • ✓Basic scalar and correlated subqueries in WHERE/FROM clauses
The Real Messy Data Traps You Will Face
  • ⚠User IDs formatted inconsistently (e.g. 'USR-001' vs 'usr_1')
  • ⚠Amounts stored as text with stray currency symbols ('$14.50')
  • ⚠Null and empty string ambiguity in country/status fields
  • ⚠Order items with missing foreign keys due to deleted accounts
Target Companies:AmazonShopifyDoorDashAirbnbSpotify
🎯 Crushes any junior Data Analyst / BI Analyst SQL technical screen.
Dedicated Progression Badges

EARN YOUR DEDICATED BADGE FOR EACH LEVEL

View All Badges & Trophies →
🚜
Level 1 Dedicated Badge

The Mud Scrapper

Complete all 100 basic messy questions (SELECT, NULLs, dirty JOINs).

100 QUESTIONS
🧙‍♂️
Level 2 Dedicated Badge

The Window Wizard

Complete all 100 intermediate questions (CTEs, DENSE_RANK, LEAD, LAG).

100 QUESTIONS
👹
Level 3 Dedicated Badge

The Schema Exorcist

Complete all 100 advanced nightmare queries (recursive CTEs, sessionization).

100 QUESTIONS
⚡
All 300 Completed

SQL Demigod

100% mastery. Guaranteed to crack any SQL interview on Earth.

ALL 300 SOLVED
Global Hall of Fame

REAL LEADERBOARD: TOP 300 CHALLENGE SOLVERS

See Full Live Standings →
🏆

Hall of Fame is Live!

No users have solved levels on this platform deployment yet. Sign up, solve your first dirty challenge, and be the first to claim the #1 spot!

THE SQL GRIT HONOR CODE: HUMAN MUSCLE ONLY

There are no proctors, no browser locks, and no webcam spyware. If you feed these 300 questions to ChatGPT, you will get a green checkmark on our site and then fail your live technical screen in front of an interviewer. Solve them yourself, wrestle with the dirty schemas, and build real muscle.

Built for serious Data Analysts, Analytics Engineers, and Data Scientists.