Downloads
Bicycle manufacturer

AdventureWorks

The classic Microsoft sample: people, employees, products, purchasing and sales for a bicycle manufacturer, in a normalized transactional design.

adventureworksSQL ServerMariaDB 82 tables
Sales_SalesOrder…Sales_SalesOrder…Production_Produ…Sales_CustomerPerson_Person

Good for

Many-table joinsNormalizationBuilding a star schema

Questions to try

  • Which products sell the most?
  • How many employees are in each department?
  • What is the sales per territory?

Write each as a query in the SQL editor, or ask an AI assistant to walk you through it.

Connect to it

Server learnsql.cpetoday.com,1433, database adventureworks, in Excel or Power BI (Import mode) or DBeaver. In queries use the schema-qualified name shown for each table (for example adventureworks.HumanResources_Department).

Download the Excel connection (.odc)

How to use it: download the file and open it. Excel opens it as a connection to adventureworks and asks for the SQL Server username and password from your CPE Today course. The file holds no password. The first table is selected by default, and you can pick others from the Data window. Setup details for other tools are on Connect.

Tables (82)

Click a table to preview it in the Playground.

HumanResources_DepartmentHumanResources_EmployeeDepartmentHistoryHumanResources_EmployeePayHistoryHumanResources_JobCandidateHumanResources_ShiftHumanResources_vEmployeeHumanResources_vEmployeeDepartmentHumanResources_vEmployeeDepartmentHistoryPerson_AddressPerson_AddressTypePerson_BusinessEntityPerson_BusinessEntityAddressPerson_BusinessEntityContactPerson_ContactTypePerson_CountryRegionPerson_EmailAddressPerson_PasswordPerson_PersonPerson_PersonPhonePerson_PhoneNumberTypePerson_StateProvincePerson_vAdditionalContactInfoPerson_vStateProvinceCountryRegionProduction_BillOfMaterialsProduction_CultureProduction_IllustrationProduction_LocationProduction_ProductProduction_ProductCategoryProduction_ProductCostHistoryProduction_ProductDescriptionProduction_ProductInventoryProduction_ProductListPriceHistoryProduction_ProductModelProduction_ProductModelIllustrationProduction_ProductModelProductDescriptionCultureProduction_ProductPhotoProduction_ProductProductPhotoProduction_ProductReviewProduction_ProductSubcategoryProduction_ScrapReasonProduction_TransactionHistoryProduction_TransactionHistoryArchiveProduction_UnitMeasureProduction_vProductAndDescriptionProduction_vProductModelCatalogDescriptionProduction_vProductModelInstructionsProduction_WorkOrderProduction_WorkOrderRoutingPurchasing_ProductVendorPurchasing_PurchaseOrderDetailPurchasing_PurchaseOrderHeaderPurchasing_ShipMethodPurchasing_VendorPurchasing_vVendorWithAddressesPurchasing_vVendorWithContactsSales_CountryRegionCurrencySales_CreditCardSales_CurrencySales_CurrencyRateand 22 more (see the schema explorer)

← All databases