Live data from Hacker News

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

app.bytescout.com

31–40 of 50 posts

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

#31

Some 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 -…

Also GalaXQL http://sol.gfxile.net/g3/

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

#33
post #29
post #21

Earlier quoted context omitted.

thanks for the feedback! Will change it

Maybe just an INFO block stating when a command is specific to a subset of DB engines and/or limited in applicability

thanks! added info that it is available in MySQL only. MySQL is pretty popular so this query can be good to know anyway.

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

#34
Something that all of these tools (?) are missing are tutorials around concurrency, allowing multiple sessions to be in progress, interfering with each others operation. TBH this is an under-taught area of databases in general.

I have vague ideas about building a browser-based tool that allowed the user to queue up operations to be performed in order in multiple concurrent database sessions, allowing exact locking & blocking behaviour to be experimented with, but have never had time to work on this.

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

#35
post #22

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.

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.

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

#36
post #22

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.

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.

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

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

#38

Some 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.

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

#39
post #22

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.

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