Last post May 03, 2017 05:08 PM by Kulrom
May 03, 2017 04:54 AM|anderson7777|LINK
I am willing to learn Sql Server.
I will probably pick Sql Server 2016 but there are very important books available that talks onyl about
SS 2012 or SS 2014.
I wanna know that if those books of older versions are still usefull.
May 03, 2017 05:25 AM|kaushalparik27|LINK
They are not that old, these versions are quite in use and if you are to learn from basic SQL Server (like writing queries, syntaxes, procedure & functions etc) then I believe the books which are available to you that talks on 2012/2014 are good enough to
Beside, you may would like to refer below online tutorials :
for online practice on queries, you may would like to consider SQL Fiddle, capable to write SQL queries in right pane on schema that you define in left pane. Select SQL Server (version) on top left side and you are good to go:
May 03, 2017 05:08 PM|Kulrom|LINK
As Kaushal told you the older versions are still in use and actually they are widely distributed and thus more popular than 2016.
Meaning all those books about 2k12 and 2k14 are absolutely useful as long as you are not interested about some of the features that came to 2016 e.g.
Dynamic Data Masking, Always Encrypted, JSON Support, R Support and few more.
However, the language (T-SQL) remains the same as well as the designing, querying, optimizing and tuning the databases.