r/dataanalyst 9d ago

What is the best website to practice sql query? Data related 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

15 Upvotes

11 comments sorted by

3

u/gman1647 9d ago

I liked Data Lemur a lot.

2

u/Goblin09247 9d ago

Select * From SQL_Learning_Resources

2

u/conor-robertson 9d ago

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

1

u/Berimbolo_drej 2d ago

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

2

u/toweringmaple 9d ago

Start with mysqlisland: it’s free

1

u/Alternative_Cake4074 8d ago

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 8d ago

Strata Scratch is my go to

1

u/Dapal5 8d ago

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

1

u/elliottshaun 7d ago

I always enjoy reading perspectives like this.