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.



Share this Tutorial / Exercise on : Facebook and Twitter

SQL: Tips of the Day

How to drop all tables from a database with one SQL query?

USE Databasename

SELECT  'DROP TABLE [' + name + '];'
FROM    sys.tables

Ref: https://bit.ly/3PIUmPL