Hands On Lab: Your First Look at the SQL Server 2008 R2 Sample Databases Version: 1.0 Description This Hands On Lab introduces the AdventureWorks Sample Databases. These sample databases are ideal for learning how to build Microsoft BI solutions. Overview This lab introduces the Adventure Works sample databases. The lab scenarios in this course center around the sales activites of the Adventure Works company. Adventure Works manufactures and sells bicycles and related products to various global markets via reseller and internet channels. Objectives The objectives of this exercise are to: Explore the AdventureWorks2008R2 database Explore the AdventureWorksDW2008R2 database Create a database diagram for the Reseller Sales subject area of the AdventureWorksDW2008R2 database System Requirements You must have installed the following items to complete this lab: Microsoft SQL Server 2008 R2 Express or higher: Database Engine SQL Server Management Studio SQL Server AdventureWorks2008 R2 sample databases AdventureWorksDW2008R2 Note: The Full-text search and File Stream features must be installed and enabled in the SQL instance in order to successfully install the AdventureWorks 2008 R2 databases. For more information about enabling the File Stream feature, see: https://msdn.microsoft.com/en-us/library/cc645923.aspx Setup All the requisites for this lab are verified using the Configuration Wizard. To make sure that everything is correctly configured, follow these steps. Note: To perform the setup steps you need to run the scripts in a command window with administrator privileges. Launch the Configuration Wizard for this lab by double-clicking the Dependencies.dep file located under the Source\Setup folder of this lab. Install any pre-requisites that are missing (rescanning if necessary) and complete the wizard. Cleanup There is no need to cleanup if you intend to continue the sequence of labs in this training kit. To restore the original state of the AdventureWorksDW2008R2 database, execute the Cleanup.cmd script located under the Setup folder in the Source folder of this lab. Exercises This Hands-On Lab comprises the following exercise: Exploring the Adventure Works Databases Estimated time to complete this lab: 15 minutes. next >

Downloads Download The Offline Training Kit Download Hands-on Lab Document (DOCX) Download Hands-on Lab Source Files Contents Overview Exercise 1: Exploring the Adventure Works Databases Summary