Link Search Menu Expand Document

Module 1: SQL Introduction Step-by-Step

Previous Tutorial - Next Tutorial

In this course, we will play with t-SQL queries and its core concept under one simple transactional database, which is known as Adventure Works. This database is provided by Microsoft and is free to download. So you can download this adventure work database from this website.

I have a SQL server 2014 installed on my local machine, so I will download the adventure works 2014bak file. So here you can see the various bak file of this database as per the SQL server version. I have already downloaded this bak file as per my requirement over here.

SQL Introduction Image

Let's try to restore it using this SQL server management studio. Now select this database option, Right-click on it, and select this restored database option.

SQL Introduction Tutorial Image

It will open the restore database window in the source group box, select the device radio button and then click on this ellipsis button on the right side. Now click on the add button and look at your path where you download the bak file, select the bak file. Click on OK.

SQL Introduction Tips Image

Now, in this restored database window, the database name will be populated. Click on the OK to begin the restoration process. Our progress bar will appear at the top of the window.

SQL Introduction Guide Image

Our database is restored successfully. Now let's expand it and click on the refresh button. So over here you can see our database. Our database is now ready to play.

Now, in the next tutorial, we will learn about the foundation of t-SQL and the logical processing of queries in detail. We will explore the various options available to manipulate data in SQL Server.

Web API for developers Free Trial Offline SDK

SQL video tutorial:

Other useful tutorials:

Back to top

© , Learn SQL 24 / 7 — All Rights Reserved - Terms of Use - Privacy Policy