SQL Server - Adventure Works Sample Schema

Table of Contents

Installation

https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks

Datawarehouse

DWH

OLTP

Schema

From Schema in AdventureWorks

Schema Contains objects related to Examples
HumanResources Employees of Adventure Works Cycles. Employee Table, Department Table
Person Names and addresses of individual customers, vendors, and employees. Contact Table, Address Table, StateProvince Table
Production Products manufactured and sold by Adventure Works Cycles. BillOfMaterials Table, Product Table, WorkOrder Table
Purchasing Vendors from who parts and products are purchased. PurchaseOrderDetail Table, PurchaseOrderHeader Table, Vendor Table
Sales Customers and sales-related data. Customer Table, SalesOrderDetail Table, SalesOrderHeader Table

Documentation / Reference


Data (State)
Data (State)
DataBase
Data Processing
Data Quality
Data Structure
Data Type
Data Warehouse
Data Visualization
Data Partition
Data Persistence
Data Concurrency

Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Modeling
Process
Logical Data Modeling
Relational Modeling
Dimensional Modeling
Automata

Data Type
Number
Time
Text
Collection
Relation (Table)
Cube
Tree
Key/Value
Graph
Spatial
Color
Log

Measure Levels
Order
Nominal
Discrete
Distance
Ratio

Code
Compiler
Lexical Parser
Grammar
Function
Testing
Debugging
Shipping
Data Type
Versioning
Design Pattern

Infrastructure
Operating System
Monitoring
Cryptography
Security
File System
Network
Process (Thread)
Computer
Infra As Code

Marketing
Advertising
Analytics
Email

Web
Html
Dom
Http
Url
Css
Javascript
Selector
Browser
Web Services
OAuth

Contact
[email protected]
Privacy Policy
Status

Powered by ComboStrap