Show HN: SQL Trainer – Learn SQL by doing live data exercises

Re:Show HN: SQL Trainer – Learn SQL by doing live data exerc... by eumm on Tuesday October 30, 2018 @01:39PM (#18339282)

Hi, My name is Eugene and we made this little online SQL language trainer to help non-programmers to learn basic SQL queries. And more important, it shows the result of query entered.

Any suggestions and comments are welcome!

and many thanks for all the suggestion already made! And seems like we should better remove MySQL specific command from the very first question.

[ Parent | on HN ]

Re:Show HN: SQL Trainer – Learn SQL by doing live data exerc... by evo_9 on Tuesday October 30, 2018 @01:54PM (#18339457)

Maybe not remove it but perhaps have a choice of SQL 'flavor'.

That would be very useful, aka user chooses Oracle, MySQL, MS-SQL, etc.

[ Parent | on HN ]

Re:Show HN: SQL Trainer – Learn SQL by doing live data exerc... by rolleiflex on Tuesday October 30, 2018 @03:40PM (#18340585)

Hey Eugene! In the last question, it seems you can get the same result by doing top 3, or limit 3, but only limit 3 is accepted as valid. You might either want to, if there's a valid reason for the distinction (execution order?), want to highlight as the difference between top and limit, or if there isn't, accept both.

[ Parent | on HN ]

Re:Show HN: SQL Trainer – Learn SQL by doing live data exerc... by eumm on Tuesday October 30, 2018 @03:51PM (#18340678)

thanks for the suggestion! yes, definitely will need to update the way it checks for correct answer as there can be multiple variations.

[ Parent | on HN ]

Re:Show HN: SQL Trainer – Learn SQL by doing live data exerc... by kevinjoling on Tuesday October 30, 2018 @03:05PM (#18340254)

Nice! Would love to see this, but for complex queries.

[ Parent | on HN ]

Re:Show HN: SQL Trainer – Learn SQL by doing live data exerc... by z3t4 on Tuesday October 30, 2018 @04:45PM (#18341132)

Make sure it's virtualized/sandboxed, SQL basically guarantees HDD write access.

[ Parent | on HN ]