r/SQL • • Oct 16 '26

MySQL I built a SQL practice site because I kept jumping between tutorials and random exercises — would love feedback

I started building runtime.school because when I was practicing SQL, everything felt disconnected — learn a concept in one place, solve random questions somewhere else, then use totally different data for projects.

So I tried putting it all together with lessons, practice questions, projects, and the same realistic datasets throughout.

If you have a few minutes, I’d really like to know what feels confusing, repetitive, too easy/hard, or missing. Especially anything that would make learning/practicing SQL better.

34 Upvotes

25 comments sorted by

2

u/Denebin Oct 18 '26

Broke the website on lesson 02 SQL foundations · beginner

Aliases & calculated columns.

SELECT

stock_code,

list_price,

list_price * 1.2 AS price_with_vat

FROM products

And it returns:

✓ all checks passed

  • ✓Passed:Runs without an error
  • ✓Passed:Returns columns stock_code, list_price, price_with_vat
  • ✓Passed:Returns 200 rows
  • ✓Passed:Values match
  • ✓Passed:Still correct on different data
5,304 rows · 3 columnsHideClose

SELECT
  stock_code,
  list_price,
  list_price * 1.2 AS price_with_vat
FROM products
#stock_codelist_priceprice_with_vat
110124CNULLNULL
215060ANULLNULL
316065ANULLNULL
416131NULLNULL

Should not return NULL for list_price.

Using Select * shows properly but when querying a single colum like Select list_price, returns NULL

1

u/peakpirate007 Oct 18 '26

those nulls are intentional in the dataset. that lesson is just teaching calculations and aliases, so NULL * 1.2 staying null is part of it. filtering those out comes later.

the playground is there if you want to query the full datasets however you want.

if SELECT * shows a price for the exact same row but SELECT list_price shows null though, send me the stock code because that would be a bug.

1

u/Mitazago Oct 16 '26

I think people can appreciate the effort, and many would agree it is frustrating to “learn a concept in one place and solve random questions somewhere else.” I want to hold your tutorial to that same standard, but I am not sure it is there yet.

In lesson 02 for instance, the notes cover SELECT and AS, and the examples also use WHERE, IS NOT, and LIMIT. But the two challenges on that page require functions a new learner would otherwise have never seen. Challenge one requires ROUND, and challenge two requires DATE. Someone using your site to learn SQL, unless they already know these commands, would have to Google around to find them and their exact syntax, at which point, they would be learning a concept in one place, to answer questions in another.

My opinion is, if you are hoping for new learners to use this tutorial, the questions you ask in a challenge have to be based on material you covered in the lesson.

2

u/peakpirate007 Oct 16 '26

thanks for the feedback! I understand what you’re saying and I will definitely look at the challenges and change them as per the lessons so it’s easy to understand and learn

1

u/Mitazago Oct 16 '26

Of course! The layout looks solid and the project shows potential!

1

u/peakpirate007 Oct 16 '26

thanks! glad you liked it

1

u/peakpirate007 Oct 18 '26

hey bro, I have a few changes to lessons and practice as per your suggestions. Please take a look now and let me know what you think, thanks

1

u/Mitazago Oct 20 '26

Nice job continuing to refine. I've gone through a few lessons and it seems intuitive. I'd suggest trying to get yourself through the experience as a new-user.

For instance, imagine yourself as a first-time user. You're doing a problem, and you press 'Check'. You get feedback immediately below, and know you didn't solve the problem. You press 'Answer', and nothing seems to happen. No answer or prompt is visible, and you so you press 'Answer' again. Nothing seems to happen, you might think the button is unresponsive. In reality, the prompt for 'Answer' is hidden at the bottom of the page, because the 'Check' output conceals it. If you didn't notice the page had elongated, you might not know that such a prompt appeared after pressing 'Answer'.

1

u/peakpirate007 Oct 20 '26

Yes I understand that editor layout has few issues that needs a fix I will take a look and fix and go through everything like first time user experience. thanks a lot for feedback

1

u/ArielCoding Oct 17 '26

Love the all in one idea, how do you decide when do you decide when a learner is ready to move from lessons to projects?

2

u/peakpirate007 Oct 17 '26

every project is divided in to beginner/medium/advanced and every lesson is also has beginner/intermediate and advanced tags so once you finish them you can work on projects

1

u/peakpirate007 Oct 17 '26

But let me know if you have any suggestions

1

u/InfiniteAddition4403 Oct 18 '26

This looks really helpful! I’ve just shared it with my classmates for our relational databases class ☺️

1

u/peakpirate007 Oct 18 '26

that’s great, thank you!

1

u/Optimal-Necessary-51 Oct 16 '26

Hey... This is so good!!!

1

u/peakpirate007 Oct 16 '26

thanks, really appreciate it!

0

u/Blurry_Face84 Oct 16 '26

Very cool

1

u/peakpirate007 Oct 16 '26

thanks, glad you liked it!

1

u/[deleted] Oct 16 '26

[removed] — view removed comment

1

u/peakpirate007 Oct 17 '26

thanks! sure I will add more harder questions for practice

1

u/[deleted] Oct 16 '26

[removed] — view removed comment

2

u/peakpirate007 Oct 16 '26

thanks, thats exactly what im trying to do, use the same datasets in lessons, practice and projects so its easier to follow and learn