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.

Prerequisite

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;

https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2014

For Step by Step installation of SQL Server 2014

http://social.technet.microsoft.com/wiki/contents/articles/23878.installing-sql-server-2014-step-by-step-tutorial.aspx

To download AdventureWorks2014 Database

https://msftdbprodsamples.codeplex.com/releases/view/125550

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.

https://msftdbprodsamples.codeplex.com/downloads/get/880669

 

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 has 8 years of industry experience in Software development. He has a head down experience in Data Science, Database, Data Warehouse, Big Data and cloud technologies and has implemented end to end solutions. He has extensively worked on SQL Server, Python, Hadoop, Hive, Spark, Azure, Machine Learning, and MSBI (SSAS, SSIS, and SSRS). He also has good experience in windows and web application development using ASP.Net and C#.

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

  • Patan

    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.

    Regards,
    Patan

  • Chandradip

    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 .