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.
- 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;
https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2014
For Step by Step installation of SQL Server 2014
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.
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
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 .