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.

SQL: Tips of the Day

How to combine date from one field with time from another field - MS SQL Server

You can simply add the two.

  • if the Time part of your Date column is always zero
  • and the Date part of your Time column is also always zero (base date: January 1, 1900)

Adding them returns the correct result-

SELECT Combined = MyDate + MyTime FROM MyTable

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

 

We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook