Nice! I like the tutorial format. I made this along similar lines: http://konsumer.js.org/learnsql/
Show HN: SQL Trainer – Learn SQL by doing live data exercises
41–50 of 50 posts
Re: Show HN: SQL Trainer – Learn SQL by doing live data exercises
#42This is great, lots of my classes are using textbooks similar to this. On (13) "Please type SQL query to get 3 largest orders from orders table", it doesn't really tell you what column to order the results by.
Re: Show HN: SQL Trainer – Learn SQL by doing live data exercises
#43Just to toot my own horn - I wrote a book called SQL Practice Problems (available on Amazon), plus I also have an expanded problem set on my website SQLPracticeProblem.com.
The framework for the problems is that you get the problem statement, the expected results, and then you figure out how to write the SQL to get the results. I have lots of hints if you get stuck, but there's also a hint-free version, which some people prefer.
It really helps for people who like a "learn-by-doing" approach.
Re: Show HN: SQL Trainer – Learn SQL by doing live data exercises
#44It would be nice if I could hit continue from the keyboard so that I could do the whole tutorial without using the mouse.
tab tab enter will do it, but yes, they might want to add a handler for enter in the text input.
Re: Show HN: SQL Trainer – Learn SQL by doing live data exercises
#45Looks cool. But in my experience, theoretical understanding and some simple proofs are quite important in mastering SQL. I would suggest the intro to DB online course offered by Stanford.
Re: Show HN: SQL Trainer – Learn SQL by doing live data exercises
#46discussion on Product Hunt: https://www.producthunt.com/posts/bytescout-sql-trainer
Re: Show HN: SQL Trainer – Learn SQL by doing live data exercises
#47Looks cool. But in my experience, theoretical understanding and some simple proofs are quite important in mastering SQL. I would suggest the intro to DB online course offered by Stanford.
thanks for the suggestion! I found the the theory can work great after some doing. Stanford course looks great for this purpose!
Re: Show HN: SQL Trainer – Learn SQL by doing live data exercises
#48> In some popular databases like MySQL and others you may get the list of available tables just by typing: SHOW TABLES;
Is there any database other than MySQL that does that?
Re: Show HN: SQL Trainer – Learn SQL by doing live data exercises
#49Some other similar tools I added to my notes from a similar thread: https://news.ycombinator.com/item?id=17905666 Interactive PostgreSQL SQL Tutorial - https://chartio.com/learn/sql/ Select STAR SQL - https://selectstarsql.com/ SQL Bolt - https://sqlbolt.com/ - Learn SQL with simple, interactive exercises SQL Window functions - https://www.windowfunctions.com/ PostgreSQL Exercises - https://pgexercises.com/ SQL Zoo -…
Schemaverse - https://schemaverse.com/ - The Schemaverse is a space-based strategy game implemented entirely within a PostgreSQL database.
I saw that before. It's pretty crazy.
Re: Show HN: SQL Trainer – Learn SQL by doing live data exercises
#50Would be cool if you didn't have to use your mouse so much. Kept having to click the next box to select it.