Textbook References:

Textbook: Beginning Microsoft SQL Server 2012 Programming
ISBN: 978-1-1181-0228-2
Authors: Paul Atkinson, Robert Vieira

Software Requirements:

SQL Server Express Edition 2014 (free)
https://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx

AdventureWorks Sample Databases and Scripts for SQL Server 2016 CTP3 (free)
http://msftdbprodsamples.codeplex.com/