Hacker News new | ask | show | jobs
by qohen 1493 days ago
There are many free resources online for learning SQL. Here are some of them:

Khan Academy has a SQL course:

https://www.khanacademy.org/computing/computer-programming/s...

The one in the first link below is interesting in that it then sets you up for the SQL Murder Mystery in the second link:

https://mystery.knightlab.com/walkthrough.html

https://mystery.knightlab.com/

The "walkthrough" link above mentions that if you want to learn SQL more deeply to try selectstarsql.com, which looks good:

https://selectstarsql.com/

This looks interesting too:

https://sqlzoo.net/wiki/SQL_Tutorial

Most of the above have databases available for you to immediately try out what you're learning, which should be helpful (sqlzoo.net also seems to have some more advanced topics covered too).

There are also a bunch of (multi-hour) courses on YouTube:

https://www.google.com/search?q=site%3Ayoutube.com+sql+cours...

If you go the video route, there are sites like SqlFiddle.com and freedatabase.com, etc. that let you set up databases so you can practice what you learn from the videos without having to install anything (though you can do that too, of course):

https://www.google.com/search?online+sql+database

I hope you find at least some of the above to be useful. Good luck with it.

1 comments

This is amazing! Thank you so much
You're welcome. :-)

Also, there are some (legitimately) free SQL books that might be worth a look:

https://www.linuxlinks.com/excellent-free-books-learn-sql/

Then there's this freebie, which is interesting in that it's compiled from StackOverflow, whose content is licensed under Creative-Commons -- GoalKicker has a bunch of these on various tech topics. Anyway, the SQL one might have some useful tips/tricks:

https://books.goalkicker.com/SQLBook/SQLNotesForProfessional...

(It has gotten good ratings and reviews:

https://www.goodreads.com/book/show/40730648-sql-notes-for-p... )

They also have such books on specific databases: MySQL, Postgres, SQLServer and Oracle -- see all their books on their main page:

https://books.goalkicker.com

And, once you learn SQL, you might want to check out webpages (and YouTube videos) of SQL tips/tricks to pick up useful tidbits:

https://www.google.com/search?q=sql+tips

https://www.google.com/search?q=sql+tricks

> They also have such books on specific databases: MySQL, Postgres, SQLServer and Oracle -- see all their books on their main page:

https://books.goalkicker.com

Thank you for sharing :)