Last revision: 2017-02-10

Source Code
-----------

The file ER 70-761 Scripts.zip contains the source code for the book.
Uncompress the content of this file to a local folder,
for example to C:\ER70761\.
Files named Chapter X - Skill Y.Z.sql contain the source code for
the corresponding chapter and skill.
The file TSQLV4.sql has the code to create the book's sample database TSQLV4.

Practice Environment
--------------------

Database server:
The code samples in this book can be executed in
SQL Server 2016 Service Pack 1 (SP1) or later and Azure SQL Database.
If you prefer to work with a local instance, SQL Server Developer Edition
is free if you sign up for the free Visual Studio Dev Essentials program:
https://myprodscussu1.app.vssubscriptions.visualstudio.com/Downloads?q=SQL%20Server%20Developer
In the installation's Feature Selection step, you need to choose
only the Database Engine Services feature.

SQL Server Management Studio (SSMS):
Download and install SQL Server Management Studio from here:
https://msdn.microsoft.com/en-us/library/mt238290.aspx

Sample database:
This book uses the TSQLV4 sample database.
It is supported in both SQL Server 2016 SP1 or later, and in Azure SQL Database.
Open and execute the script file TSQLV4.sql in SSMS to create the sample database.
