SQL Exercises, Practice, Solution - exercises on AdventureWorks Database
SQL Queries of AdventureWorks Database:
The AdventureWorks Database is a Microsoft product sample that provides an example of an online transaction processing (OLTP) database. Adventure Works Cycles is a fictitious multinational manufacturing company that is supported by the AdventureWorks Database.
Exercises:
List of Schemas and Tables and ER Diagram in the AdventureWorks database:
Schema: humanresources
E R Diagram of humanresources Schema:
Schema: person
- address
- addresstype
- businessentity
- businessentityaddress
- businessentitycontact
- contacttype
- countryregion
- emailaddress
- person
- personphone
- phonenumbertype
- stateprovince
E R Diagram of person Schema:
Schema: production
- location
- illustration
- productcategory
- productcosthistory
- productlistpricehistory
- productmodelproductdescriptionculture
- productreview
- scrapreason
- productsubcategory
- transactionhistory
- transactionhistoryarchive
- productmodelillustration
- unitmeasure
- productmodel
- workorderrouting
- billofmaterials
- productdescription
- productdocument
- culture
- product
- productphoto
- productinventory
- productproductphoto
- workorder
E R Diagram of production Schema:
Schema: purchasing
E R Diagram of purchasing Schema:
Schema: sales
- salesorderheadersalesreason
- customer
- countryregioncurrency
- currencyrate
- creditcard
- specialoffer
- specialofferproduct
- currency
- store
- personcreditcard
- salestaxrate
- salespersonquotahistory
- salesreason
- salesterritoryhistory
- salesterritory
- salesperson
- salesorderheader
- salesorderdetail
- shoppingcartitem
E R Diagram of sales Schema:
Download Postgre verseion of AdventureWorks Database. Clickhere.
It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.
https://www.w3resource.com/sql-exercises/adventureworks/index.php
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics