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.



Become a Patron!

Follow us on Facebook and Twitter for latest update.

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