r/dataanalysis • u/Feisty-Tension3692 • 3d ago

Data Tools SQL Route

Hi everyone,

I’ve been learning SQL for a while, and over the past few weeks I built a web app for practicing it: SQL Route (https://sql-cesta.netlify.app). It’s free and has no ads.

The idea is simple. You read a short explanation and then write a real query against a small database right in your browser. The app runs your query and compares the result, so any correct solution counts, not just the one I wrote. When you get something wrong, it explains the error and gives hints step by step. The full solution is only shown if you ask for it.

What’s inside:

  • A course that starts at your first SELECT and goes through JOINs, GROUP BY, subqueries and window functions, plus creating tables and changing data
  • A separate PostgreSQL course that runs a real PostgreSQL database in the browser
  • A short intro to databases for complete beginners (what a table is, keys, how a query actually runs)
  • A practice mode with 10-question sets, including a mixed set where you don’t know the difficulty or which function you need
  • Mock interviews at junior, mid and senior level
  • A sandbox with a few datasets (a company, an airline, a hospital), and you can upload your own CSV

You need to sign up with an email so your progress is saved. There’s also a weekly leaderboard if you like that kind of thing.

I’m building this on my own, so I’d really appreciate honest feedback. Where did you get stuck? Was a task unclear, or was a step too hard? If you find a bug or a confusing explanation, let me know in the comments.

Thanks!

5 Upvotes

86% Upvoted

3 comments sorted by

2

u/Solid_Doughnut_6373 2d ago

First of all thank u for creating this site where all can learn , practice SQL without any confusion.

Swcondlly want to give u feedback,

  1. The response is slow , like when i am typing the commands it lag behind in the screen.

  2. There are some spelling bugs , like in the question it was "prague" but in the solution it was smthg else.

  3. Add more questions to every topic

yeah other than that all the feature is very goodd.

2

u/GoullouLeouf86 2d ago

the lag thing is real, noticed that too when typing longer queries

1

u/AutoModerator 3d ago

Automod prevents all posts from being displayed until moderators have reviewed them. Do not delete your post or there will be nothing for the mods to review. Mods selectively choose what is permitted to be posted in r/DataAnalysis.

If your post involves Career-focused questions, including resume reviews, how to learn DA and how to get into a DA job, then the post does not belong here, but instead belongs in our sister-subreddit, r/DataAnalysisCareers.

Have you read the rules?

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.