SQL Trainer
Learning and science
sql tutorial
SHOW HN2018
303points
49comments
#86of 2,155 in 2018
Top 4%of 2018 by points
How HN took it
CuriousMostly questions and neutral comments
6 positive, 18 neutral or asking, 2 mixed, 4 critical, out of 30 comments about the project. Thread score +0.04.
Idea: 3 for, 2 againstDocs: 0 for, 2 againstExecution: 1 for, 0 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
Objections
Starts with MySQL-specific commands like SHOW TABLES and LIMIT
From 3 comments
This is nice, but it's unfortunate that it starts off with commands specific to MySQL.
michaelmior on HNI like this, but as mentioned, it's a shame that it starts of with a MySQL specific command, SHOW tables
tomca32 on HNNo, there isn't. But I don't see the need to start with these commands anyway. Or if the OP really feels like that's a necessary starting point, it would be great to have an…
michaelmior on HN
Lacks joins
From 2 comments
Pretty nice! It would be cool if this also had some basic joins added as well.
moolcool on HNNo joins? Its a bit trivial then. Otoh, explaining joins is pretty complicated compared to the basics. This 'Late Payment Email generator' by same person is pretty good : ) I…
codeulike on HN
Exercise instructions can be unclear about the expected column
From 1 comment
This 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…
bytematic on HN
Heavy mouse use; no keyboard flow
From 2 comments
It would be nice if I could hit continue from the keyboard so that I could do the whole tutorial without using the mouse.
zebrafish on HNWould be cool if you didn't have to use your mouse so much. Kept having to click the next box to select it.
trevz on HN
Requests
Support selecting SQL dialect
From 3 comments
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.
evo_9 on HNNo, there isn't. But I don't see the need to start with these commands anyway. Or if the OP really feels like that's a necessary starting point, it would be great to have an…
michaelmior on HNI like the idea of being able to select which dialect one wants to learn and maybe a table listing the most prominent differences (like LIMIT vs. TOP) at the end, would be nice…
arendtio on HN
Add joins exercises
From 2 comments
Pretty nice! It would be cool if this also had some basic joins added as well.
moolcool on HNAgreed, just add a few more steps to do joins as that's probably one of the most common requests that people need to do. Even providing a few basic inner or left joins could be…
SnowingXIV on HN
Keyboard navigation
From 2 comments
It would be nice if I could hit continue from the keyboard so that I could do the whole tutorial without using the mouse.
zebrafish on HNtab tab enter will do it, but yes, they might want to add a handler for enter in the text input.
voltagex_ on HN
Accept equivalent query variants such as TOP and LIMIT
From 2 comments
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…
rolleiflex on HNthanks for the suggestion! yes, definitely will need to update the way it checks for correct answer as there can be multiple variations.
eumm on HN
Questions
Is there a way to list tables in databases other than MySQL?
From 2 comments
> 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?
paulddraper on HNIs there an alternative (like a command to list all tables and which works on all DBMS)? I mean using a specific sqlite/oracle/tsql/... command wouldn't be any better.
arendtio on HN
Alternatives named
SQLBolt
From 2 comments
Here is another: https://sqlbolt.com
evo_9 on HNSome other similar tools I added to my notes from a similar thread: https://news.ycombinator.com/item?id=17905666 Interactive PostgreSQL SQL Tutorial -…
knight17 on HN
Select Star SQL
From 2 comments
This is another one I found a couple of weeks ago: https://selectstarsql.com/
Double_a_92 on HNSome other similar tools I added to my notes from a similar thread: https://news.ycombinator.com/item?id=17905666 Interactive PostgreSQL SQL Tutorial -…
knight17 on HN
SQL Teaching
From 2 comments
I learned everything from: sqlteaching.com It was created in a hackathon and uses sql.js, you can also create your own exercises through sql.js if you know a thing or two about…
mettamage on HNSome other similar tools I added to my notes from a similar thread: https://news.ycombinator.com/item?id=17905666 Interactive PostgreSQL SQL Tutorial -…
knight17 on HN
PostgreSQL Exercises
From 1 comment
Some other similar tools I added to my notes from a similar thread: https://news.ycombinator.com/item?id=17905666 Interactive PostgreSQL SQL Tutorial -…
knight17 on HN
SQL Zoo
From 1 comment
Some other similar tools I added to my notes from a similar thread: https://news.ycombinator.com/item?id=17905666 Interactive PostgreSQL SQL Tutorial -…
knight17 on HN