Show HN: SQL Trainer – Learn SQL by doing live data exercises • Hacker News Board

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

#11

Post by codeulike » Tue, Oct 30, 2018, 3:08 PM UTC

moolcool wrote: post #3

Pretty nice! It would be cool if this also had some basic joins added as well.

No 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 hate figuring out how to write those

https://app.bytescout.com/generate-payment-reminder-email/ge...

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

#12

Post by michaelmior » Tue, Oct 30, 2018, 3:14 PM UTC

arendtio wrote: post #9

michaelmior wrote: post #2

This is nice, but it's unfortunate that it starts off with commands specific to MySQL.

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

No, 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 option in the future to select what DBMS you're using. I wasn't intending to bash the work, but sticking to a single DBMS really limits the utility of what seems like it could be very general resource.

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

#13

Post by mettamage » Tue, Oct 30, 2018, 4:03 PM UTC

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 web development ;)

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

#14

Post by pier25 » Tue, Oct 30, 2018, 4:13 PM UTC

This is great. I'm mostly a front end dev and my SQL is rather poor...

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

#15

Post by ediardo » Tue, Oct 30, 2018, 4:53 PM UTC

pier25 wrote: post #14

This is great. I'm mostly a front end dev and my SQL is rather poor...

This is common in front end devs. The higher you go in the stack the less you worry about these operations.

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

#16

Post by cneumuel » Tue, Oct 30, 2018, 4:54 PM UTC

For Oracle, there is https://livesql.oracle.com

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

#17

Post by evo_9 » Tue, Oct 30, 2018, 5:02 PM UTC

Here is another: https://sqlbolt.com

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

#18

Post by pedrosorio » Tue, Oct 30, 2018, 5:06 PM UTC

try-perforate wrote: post #10

It would be nice if I could hit continue from the keyboard so that I could do the whole tutorial without using the mouse.

https://vimium.github.io/

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

#19

Post by gravy » Tue, Oct 30, 2018, 5:17 PM UTC

try-perforate wrote: post #10

It would be nice if I could hit continue from the keyboard so that I could do the whole tutorial without using the mouse.

You can tab to the continue button

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

#20

Post by eumm » Tue, Oct 30, 2018, 5:34 PM UTC

moolcool wrote: post #3

Pretty nice! It would be cool if this also had some basic joins added as well.

joins will be added soon!