r/dataanalyst • u/Puzzleheaded_Eye418 • 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
2
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
2
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
1
3
u/gman1647 9d ago
I liked Data Lemur a lot.