New job-related factor in my life is MS SQL and learning syntax/how to query on T-SQL.
I've partitioned a 50gb drive and installed Server 2012 R2. I also installed SQL Server Management Studio 2012. I setup the AdventureWorks database and run a a few basic queries here and there.
There doesn't seem to be many training exercises online regarding this database. I'm looking for a great book that I can purchase which will include a detailed database and countless exercises for me to spend time querying, practicing, and learning the language. As I do that I'm sure I'll get a better grasp on the Management Studio program itself (but for the most part it's fairly intuitive).
Any pointers in the right direction? Something that is on Kindle is a plus because then I don't have to drop tons of cash on a book (but I will if I have to). I have a few days off and I want to cram as much in as possible. I'm picking up on it really quickly I just need something to get me going. Something with countless hours of exercises and a strong database to back it up.
System Administrator / DevOps guy
2015 passed: CCNA R/S, CCNA Sec, Project+, VCP5-DCV
2016 goals: MCSE Server 2012; continue to use/learn more Chef w/Ruby and Powershell on Azure