Chapter01_03_databases

Chapter 1 - Video # 3

Introduction to the Sample Databases and Data Sources Used Chapter 1: Course Introduction and How to Get Started Course: SQL Server 2008/R2 Analysis Services Course Id: 165 Presented by Scott Whigham 1 1

p. 1

Course Databases

• This course makes extensive use of the SQL Server sample databases – Known collectively as “Adventure Works” – Multiple databases – Multiple samples for each product – Integrated samples

2 p. 2

Our databases

• Let’s talk about AdventureWorks – A fictional company from Microsoft – Manufactures and sells bicycles and bicycle parts via brick-and-mortar and online stores “Coming off a successful fiscal year, Adventure Works Cycles is looking to broaden its market share by targeting their sales to their best customers, extending their product availability through an external Web site, and reducing their cost of sales through lower production costs.”

3 p. 3

Our databases

• Adventure Works has four main parts – Sales and marketing – Products – Purchasing and vendors – Manufacturing

4 p. 4

Our databases

• Adventure Works has evolved from using just a relational database to needing: – Relational database – Relational data warehouse – Multidimensional database – Complex business rules to ensure data integrity

5 p. 5

Our databases

• The sample databases and applications cover many scenarios featured in this course: – Relational databases as a data source – Relational data warehouses – Multidimensional databases – SSIS package flow

6 p. 6

Our databases

• “Okay, Scott – those sound great. Where do I get them?”

– Two ways: 1. They are attached to this video in a file called Course165Samples.zip 2. You can locate the “SQL Server Product Samples” on http://www.codeplex.com

7 p. 7

Our databases

• In a future exercise, we will install the course samples – This allows you to follow along throughout the course

8 p. 8

Next up

• Operating Systems, SQL Server Versions, and Differences “The harder you work, the harder it is to surrender.”

Vince Lombardi

9 p. 9