How to Install the AdventureWorks Database

Install SQL Server Express #

Note: Make sure go to SQL COnfiguration and set startup to manual .... TODO

Install Adventure Works Database #

AdventureWorks is a sample database that includes some test data, tables, stored procedures, and views. AdventureWorks has replaced other sample databases like contoso-data-warehouse or northwind.

MS Docs has a guide on AdventureWorks installation and configuration

1. Download the AdventureWorks2017.bak db backup and save it somewhere to your C: Drive (makes for easy finding).

   This is the db file for the OnLine Transaction Processing (OLTP) which handles the transactional data storage - as opposed to OnLine Analytic Processing (OLAP) databases intended for wharehousing and analytics

2. Open SQL Server Management studio and connect to your local server.

   DO NOT install remote or sample databases on our shared servers

3. In Object Explorer, right click on the Databases and select Restore Database

   

4. Select Device and click the ellipses (...)

   

5. In the Select Backup Devices Dialog, click Add, select the file you downloaded earlier, and click OK

   

The Database should now appear in your local databases and you can query or modify it just like any other DB

                    Copy
                    
                 
USE AdventureWorks2017

SELECT TOP 10 * FROM Person.Person

Here's a big ol' Database Diagram / Entity Relationship Diagram (ERD)