Resources for getting back up to speed on SQL

Question

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

twoquestions · Accepted Answer

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 · Answer

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

quickthrower2 · Answer

The Microsoft docs for MSSQL are great and I&rsquo;d honestly just read through them.

Resources for getting back up to speed on SQL

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

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

The Microsoft docs for MSSQL are great and I’d honestly just read through them.