HN Explorer

Ask HN: Resources for getting back up to speed on SQL

16 points by itselflove ↗ HN
I have accepted a new role that uses MSSQL, I have been using NoSQL at work for the past 4 years but have previously use SQL.

Does anyone have any suggestions on the best resources to use to get me back up to speed, ideally books?

Thanks

3 comments

[ 2.7 ms ] story [ 10.2 ms ] thread
quickthrower2
The Microsoft docs for MSSQL are great and I’d honestly just read through them.
twoquestions
To learn yourself, also go over the execution plan when running a query and Google absolutely everything it tells you, and look through the MSSQL documentation at what it all means. It won't lead you to what you don't know, but it will fill in everything you're a bit cloudy on.

One of my favorites to get the very basics is Select Star, especially because you work with real and meaningful data: https://selectstarsql.com/

Use the Index, Luke has also really helped me make queries that don't waste a ton of time: https://use-the-index-luke.com/

Microsoft also has a bunch of paid training classes for MSSQL, if you or your boss don't mind ponying up some $$$. MSSQL is an amazing tool, and it's worth it to really learn how to use it well.

Good luck!

tdr
https://sqlzoo.net/

By far, the best actionable resource I used. Google search for answers/explanations & theory