w3resource

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:

Adventureworks humanresources schema

Schema: person

E R Diagram of person Schema:

Adventureworks person schema

Schema: production

E R Diagram of production Schema:

Adventureworks production schema

Schema: purchasing

E R Diagram of purchasing Schema:

Adventureworks purchasing schema

Schema: sales

E R Diagram of sales Schema:

Adventureworks sales schema

Download Postgre verseion of AdventureWorks Database. Clickhere.



Follow us on Facebook and Twitter for latest update.