Adventure Works Databases for Sql Server
Microsoft released a sample database which can be used to explore and practice using the various features of Sql Server. Adventure Works is a fictitious, multinational bicycle manufacturing company. The database is an enterprise solution which covers Sales/Marketing, Product, Purchasing/Vendor and Manufacturing scenarios.
Sales and Marketing
Adventure Works sells the manufactured cycles to stores for them to resell, and also direct to individuals through the website:
- View individual customers
- View individual customer address data
- View retail and wholesale store customers
- View sales by store
- View stores by locations
Product
The product scenarios describe the bikes that are actually manufactured by Adventure Works as well as replacement components, clothing and accessories that are also sold along with the manufactured bikes:
- View products by category, subcategory and model
- View product descriptions by product model
- View single single-level bill of materials list for a parent product
Purchasing and Vendor
Adventure Works buys raw materials as well as the clothing and accessories from particular vendors. The database also models this scenario.
- View products supplied by vendors
- View vendor contracts by vendor
- View purchases by vendor
Manufacturing
The Manufacturing scenario has data which supports the manufacturing activities, in particular Bill of Materials, Locations, Assembly, Inventory and Engineering Documentation:
- View multilevel bill-of-materials for a parent product
- View product inventory
- View work orders by product
References
There are Databases for each release of Sql Server and they are designed for OLTP as well as data warehouse solutions:
- Download Databases (Github)
- AdventureWorks Business Scenarios (MSDN - retired)
- Schema Diagram
