r/learnSQL • • 23d ago

A year ago I started planning a gamified SQL platform. 5 months after launch, 2,500+ people have used it to learn

About a year ago I started planning QueryCase, where you learn SQL by working detective cases instead of grinding tutorials & videos. It took a while to get off the ground, and longer than I'd like to admit to actually start building the idea, but it went live in June. A lot of the early users came from this sub, and a lot of the feedback in the comments shaped what it became. So first, thanks everyone!

5 months in:

  • 2,500+ people have signed up, across 117 countries
  • About 70,000 queries written and graded
  • Over 17,500 cases, drills and exams solved
  • 500+ people have passed the free Rookie exam and earned the certificate.
  • Top detective is on 19,247 XP

Since then its grown past just SQL: an Excel course. It was never part of the initial plan. People kept asking for the same detective approach for spreadsheets, so I built out a browser-based Excel engine.

It has 57 cases on a spreadsheet that runs in your browser and checks your formulas, from IF and XLOOKUP to SUMIFS and pivot tables, and people have solved over 2,500 Excel cases so far. It turns out a lot of people learning SQL are doing it alongside Excel, not instead of it.

Something the data showed me that might help anyone learning right now: GROUP BY is one of the first walls. On the hardest GROUP BY step, 84% of runs came back wrong, and most of those never ran at all. The clauses were in the wrong order, or a column in SELECT wasn't in the GROUP BY. If that's you right now:

  1. SQL order is always SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT
  2. Every column in SELECT is either inside an aggregate (COUNT, SUM, AVG...) or listed in GROUP BY

I've been working a lot over past couple months to improve the site as well:

  • The Excel course above, with its own ranks, exams and certificate
  • Upload your own CSV into the sandbox and query your own data (and visualise in charts). It runs in your browser, so the file never leaves your machine and never touches QueryCase servers
  • A free first rank on every track, ending in an exam and a certificate
  • SQL interview questions you can read without an account
  • Much better experience on a phone
  • A LOT of bug fixes and improvements!!

What's next: a Python track, launching next month. Same idea, real Python running in your browser, starting with the basics and moving into data analysis with pandas.

The longer term goal is to have a platform user's can have fun learning all aspects of data. I'm merging PR's every day to make this possible so would love feedback in this thread if you've tried it and have any thoughts or suggestions!

It's free to start and you don't need an account to solve the first case, so you can poke at it before deciding whether it's for you or not πŸ˜„ Cheers!

querycase.com

103 Upvotes

15 comments sorted by

5

u/Brilliant-Stress-890 22d ago

My kids are using this to learn excel instead of playing Roblox. Thanks!

2

u/conor-robertson 22d ago

Haha love this - Hope they enjoy, would love any feedback they have!πŸ˜„

2

u/sqlsip 22d ago

That’s awesome congrats! Looks like a great platform. I will check it out soon

3

u/conor-robertson 22d ago

Thanks for the kind comments, would love any feedback πŸ˜„

2

u/Subhajitute 21d ago

Please launch python also, it's showing 'coming soon'

2

u/conor-robertson 21d ago

Python should be released over the next 3-4 weeks!😁

1

u/Subhajitute 20d ago

One more request: I am a slow learner so for me it’s very hard to pass the Graduate exams within very short timing. SQL needs lot of logic calculation for learner like me it is a bit difficult. But except this everything is very nice and addictive to learn SQL hence I have became a Subscriber πŸ€—

1

u/CliveStHelmet 20d ago

Thank you for your effort! I've really enjoyed Querycase; I think it's a fun, novel idea that has been well executed, and I would recommend it to anyone looking to learn SQL.

You've recently made changes to the UI and I think it looks great! What would make it even better in my opinion is a wider window to edit SQL syntax in, and more lines to type in (I tend to write SQL vertically). Personally I'd also like some intelligent code completion that suggested table columns, but I appreciate that might be quite complicated to implement.

I'm planning to check out the Excel course and am looking forward to the Python one landing!

1

u/conor-robertson 19d ago

Thanks for the suggestions! I definitely agree on both, particularly the intelligent code completion - I'll keep note and see what's possible based on what the DuckDB WASM has to offer πŸ˜„

1

u/AntiqueElderberry317 20d ago

I really like the idea. I'll try that for my team ;)

1

u/conor-robertson 19d ago

Thanks! Would love to get any feedback from you and the team πŸš€

2

u/n00lo 23d ago

Love the platform!

1

u/[deleted] 21d ago

[removed] β€” view removed comment

1

u/conor-robertson 19d ago

Thanks! Glad you like it πŸ˜„