Installing The Adventureworks LT2012 Database Into The SQL Environment

The first step was to download SQL Server 2012 Express Edition from Download SQL Server 2012 Express. The second step is to click big red button that says “Download SQL Server 2012 Express” and select the version that is appropriate. In this case I selected “Sql Server Express with Advanced Services” since it appeared to have everything I needed. The next step is to install a sample database to work with it(Codex Plex, 2012). In this case, AdventureWorks2012 sample database was installed. The downloaded is zip file, so it needs to be unzipped saved in SQL Server backup folder. Since there was no change made during installation process, the location of files was in C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012EXPRESS\MSSQL\Backup. The next step was go to SQL Server 2012 and open up the Object Explorer as shown in the screen shot below.

The database folder was right clicked and the context menu appear, Restore Database was selected as shown in the above screen shot. The common led to the Restore database window as shown in the screen shot below.

The next step was to click “Device”, followed by clicking the button behind it. Select backup devices window appeared. “Add” button was clicked and browsed to the .bak file which was previous unzipped. .bak file was selected and “OK” button clicked. Since there was no any other file selected in the Select backup device window. The command prompted to the Restore database window. The AdventureWork database was restored and ready for use as shown in the screen shot below.

 

Modifying Query

SQL stands for Structured Query Language, which means that it does not depend on ISO SQL and ANSI standard syntax for operations, instead it uses Transact-SQL (T-SQL). Also, it is important to understand that SQL Server is presented as relational database since it stores data in relations. The relations should not construed to mean relationship between one data set with another, but it is a mathematical term meaning a collection of unordered tuples and unique sets of values or attributes. Therefore, SQL Server are represented in tables, which is a collection of columns and rows. It is therefore the tables that need to be query.

Download full sample paper with screenshots or order a unique paper at an affordable price.

Share with your friends
Order Unique Answer Now

Add a Comment