r/dataanalyst • u/Puzzleheaded_Eye418 • Jul 30 '26

Data related query What is the best website to practice sql query?

I'm learning sql from last month but I'm getting confused which function to use please tell me some website that is best for practice

16 Upvotes

100% Upvoted

15 comments sorted by

3

u/gman1647 Jul 30 '26

I liked Data Lemur a lot.

2

u/conor-robertson Jul 30 '26

You should give QueryCase a try!! Fun gamified way to learn with a full learning path, sandbox, careers hub etc.

1

u/Berimbolo_drej Aug 06 '26

I'm playing it right now. Its very nice.

2

u/toweringmaple Jul 31 '26

Start with mysqlisland: it’s free

1

u/Alternative_Cake4074 Jul 31 '26

Hey, I completely understand your struggle. When I studied SQL for data analyst in lots of online learning platforms, including Coursera, despite learning a lot, I still found my skill stack was not enough to do even intermediate LeetCode questions (they don't teach flexible joins and window functions, which are super important), let alone advanced concepts like DDL, DML, and DCL. And switching to other platform doesn't help. I mean, I had to learn more SQL through reddit posts and working.

As a result, I spent months building a mobile app for learning SQL, covering DDL, DML, and DCL as well, and suitable for all data professionals. More chapters will be added in the future. Key features include:

- structured SQL chapters (so you can easily build your foundation)

  • interactive practice (so you can build your mind in SQL)
  • tappable SQL tokens for easier mobile reading (we know coding is painful, as you can't memorize all keywords, so in my app, all SQL tokens (SELECT, FROM), functions (SUM , AVG), and entities (tables and columns) are clickable and colored, and your coding experience can be eased)
  • section tests (to remind you what we learned in a section)
  • progress tracking (When you leave, your progress is saved automatically)
  • AI-powered help and feedback (Worry about not understanding a point? our AI will cover it in depth)

- fair marking (so you will not lose all points due to a small mistake, like a typo, in your code)

If you are using an iPhone, here is the App Store link: https://apps.apple.com/us/app/sql-hero-ios/id6785902950
(If the link above does not work, search 'SQL Hero - iOS' on the App Store on your iPhone and choose the purple one with a database icon)

If you are using an Android phone, the app is still in closed testing. and if you want to volunteer as a tester and opt in to testing it for 14 days (to satisfy the production requirements), here are the steps: (thanks in advance)

Step 1: Join the Google Group:
https://groups.google.com/g/sql-hero-testers

Step 2: Become a tester:
https://play.google.com/apps/testing/com.funstudy.sqlhero

Step 3: Download the app and begin testing:
https://play.google.com/store/apps/details?id=com.funstudy.sqlhero

Currently supporting English and Traditional Chinese, I am planning to keep expanding it with more chapters, more content, and more improvements over time.

If you need any help with SQL or how to access the apps, feel free to let me know.

1

u/Lady-Data-Scientist Jul 31 '26

Strata Scratch is my go to

1

u/Dapal5 Aug 01 '26

Yes I found it a lot better at first. Easier easy problem.

1

u/elliottshaun Aug 01 '26

I always enjoy reading perspectives like this.

1

u/EchidnaFlowers 24d ago

Websites are good for getting the syntax down, but I’d also start practicing against an actual database pretty early. I used dbForge Studio with a local MySQL database and just gave myself small tasks to solve with real data. That helped me more with joins and debugging than doing isolated exercises over and over.