To start with this tutorial, you need to download and install SQL Server (Latest version recommended) from Microsoft and to do some hands-on throughout this tutorial and for assignments purposes, you need to download and attach AdventureWorksDatabase also. Below you have some links, which might help you out in these prerequisites.
Just two things for this “SQL Server Tutorial” and you all set to go with this tutorial.
- Install SQL Server – [Recommended – SQL Server 2014 or 2012]
- Download and attach “AdventureWorksDatabase”
If you don’t have installed SQL Server yet, no worries, here are the links which may help you.
To download SQL Server 2014;
For Step by Step installation of SQL Server 2014
To download AdventureWorks2014 Database
How to restore “AdventureWorks2014” Database
Download the MS Word file from below link and follow the instructions mentioned in “Install Adventure Works 2014 OLTP database from a backup” section to restore the downloaded database.
Hope you have downloaded and attached the AdventureWorksDatabase and ready to proceed with this tutorial. First we will be familiar with Database concepts and then we will have a deep dive into T-SQL.