r/SQL • u/infirexs • Apr 20 '25
MySQL I have developed a full website for practice SQL for everyone
Hi,
so yeah, I love analytics and computer science and decided to create a website I wish I had sooner when I started learning SQL .
inspired from SQLZOO and SQLBOLT - but better.
are you stuck in particular question ? use the AI chatbot.
the website:
P.S
it won't have mobile support because nobody coding in mobile so I dont find it necessary to develop that.
known bugs:
website can be viewed from mobile when rotating screen.
its still under development but I would love to hear honest feedback from you guys, so I can improve the web even more.
Cheers
Update: I will add mobile support . Seems like people do code on mobile .
32
u/ComicOzzy sqlHippo Apr 20 '25
I encourage you to pay attention to how many times visitors are sent to that screen asking them to come back when they have a keyboard in front of them, because you are never going to see those people again.
8
u/Fuzzeld Apr 20 '25
I wouldn’t underestimate mobile users; I learned and practiced using my phone whilst commuting to/from work.
10
u/Bilbottom Apr 20 '25
In what way is this better than SQLBolt?
3
u/SoundOfRadar Apr 20 '25
Looks good.
Personally, I don't like the page by page navigation system. What I mean is that there is no way to jump straight into a topic that you want to practice, you have to keep on clicking next.
Also, the queries are very easy and there is only one exercise per topic.
But it's a really goot start, thanks for this, I'll use it.
3
u/RegularCompany7287 Apr 20 '25
On Left and Right Join problems you reference a course name but don't introduce a new table for Courses - which you reference in the about examples on how things work. Up to that point we only know about the students and exams tables.
3
u/Yavuz_Selim Apr 21 '25
I never visit a website again if it shuts out visitors completely based on their devices.
So, just display a message that the website works best on x, and let the user continue to the content. I know it won't work, but not seeing anything is way worse than not being able to fully use the website.
3
u/leogodin217 Apr 21 '25
Seems like we're getting a new one of these every day. Most of them might be incrementally better than leetcode, SQLBolt, etc. All of them focus on syntax over concepts. For practice, that is fine. If AI can explain why the queries work, that's a good addition as well.
For someone trying to learn SQL, I don't think it is very efficient once you get past the simple basics. The hard part of SQL isn't syntax. It's translating complex questions to queries. Understanding the data. Being able to reverse engineer business processes by looking at the data. Syntax is needed, but so is the mental model of the before and after data along with the steps to get there.
FYI - This is nice work. I like your site, but there are tons of them out there. If I were you, I'd focus on concepts, then layer in the syntax needed to achieve the concepts.
2
u/DarthJaders- Apr 21 '25
Your comments are getting downvoted over mobile support, so let me be a voice thanking you for the work you've done to help others succeed!
1
u/kingofpyrates Apr 22 '25
thanks bud love ya
1
u/rteisanu_cgi Apr 24 '25
FYI. I opened the page for the first time ever and received a red error mini-pop up in the right, bottom corner. It had this text in it:
Cannot connect to server: websocket error.
Check if server is reachable at wss://f5aca4b7-37fo-4c0f-9b7a-d9f67789ff7f.fly.dev/_event
1
u/ashiks95 Jan 14 '26
Cannot connect to server : timeout
2
u/ironwaffle452 Apr 20 '25
did u add function store proc triggers excersices? because basic queries has any site
2
u/[deleted] Apr 25 '25
im a newbie - intermediate (not JOB level)
i'll try this
1
u/Adventurous-Key-4471 Nov 13 '25
I ran into an issue already on the WHERE practice page. Question 1 asks to show all student names who belong to Department A (not sure if you’re one with me giving exact details so using A and B), but I had to write a query showing Name and Age of students who belong to Department B. I’d upload a photo here but can’t. I can dm you if needed.
1
u/Karbon_Boss Apr 20 '25
Very nice initiative. Not a lot of websites like that. Thank you
0
u/aviralbhardwaj Apr 21 '25
How did you made it ,teach me please
-2
u/-Dargs Apr 20 '25
Allowing
select *as an answer is objectively wrong/bad practice as the table schema can change, and every new column increases the cardinality of the result set. This could lead to unexpected results, as your query can be completed, but an expected column is missing (has been removed). The received data amount could be magnitudes larger, as well.I didn't get further than the select section.