SQL Server Tutorial – Prerequisite

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.

  1. Install SQL Server – [Recommended – SQL Server 2014 or 2012]
  2. 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.

Rate This
[Total: 1    Average: 4/5]

Gopal Krishna Ranjan

About Gopal Krishna Ranjan

Gopal is a passionate Data Engineer and Data Analyst. He has implemented many end to end solutions using Big Data, Machine Learning, OLAP, OLTP, and cloud technologies. He loves to share his experience at https://www.sqlrelease.com/. Connect with Gopal on LinkedIn at https://www.linkedin.com/in/ergkranjan/.

Leave a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

2 thoughts on “SQL Server Tutorial – Prerequisite

  • Avatar

    HI Gopal,

    I have one query, I have table with huge transactions data, when I select any 4/5 columns in that and then do order by clause on varchar value in the same table it’s taking too much time. Please can you help me out what I need to do on this case ?

    Note: I have created clustred/nonclustred index on that specific column, but result was not expected.


  • Avatar

    Hi Gopal ,

    I could not go after the Inser statement query , when i google with outer apply i found it but within this state i could not find .
    kindly help me to find out the issue .