Download AdventureWorks

In this training we will be using the sample transactional database known as "AdventureWorks". This database is provided by Microsoft and is free to download. For more for more info and detailed instruction see the Adventureworks Github page here.

Instructions for downloading and installing the AdventureWorks Database:

  1. Download the .bak file attached and save it to the C: drive. not in a sub-folder.
  2. Open SQL Server Management Studio and connect to your SQL Server instance.
  3. Restore the database using the SQL Server Management Studio user interface.
    1. Right-click Databases and select Restore Database...
    2. On the General page, use the Source section to specify the source and location of the backup sets to restore.
    3. Select Device
    4. Click the browse (...) button to open the Select backup devices dialog box.
    5. Click Add
    6. Navigate to the C:\ drive and select the .bak file.
    7. Click OK in each dialog box until the restore process is completed

A data dictionary for AdventureWorks can be found here:

The Entity Relationship Diagram can be found attached below.