Adventure Works Database Crash Course

Name: Adventure Works Database Crash Course
Rating: 5.0 (1 reviews)

Learn about the Adventure Works sample databases in just 1 hour following along this crash course.

Created byTKO ‎

Last updated 7/2022

English

What you'll learn

Gain an understanding of how to download, install and use SQL/SSMS.
Cover both OLTP and Data Warehouse Adventure Works databases.
Understand business intelligence datasets that programs use such as Microsoft's Power BI.
Gain a better understanding of the documentation behind the Adventure Works databases.

4 sections • 19 lectures • 1h 11m total length

Introduction and setup of SQL/SSMS3:16
Downloading and importing Adventure Works backup databases3:25
Download the three Adventure Works backup databases (OLTP, data warehouse, and lightweight) from the official Microsoft site, then restore them using the SQL Server Management Studio.

Data Warehousing4:27
Normalization and Denormalization3:38
Documentation5:06
Trace the origins of Adventure Works data from OLTP to the data warehouse. Learn how documentation, including Microsoft 2008 data warehouse references, clarifies structure amid outdated resources.
DimDate and FactResllerSales Analysis2:18
DimReseller Analysis3:15
Explore how etl transfers oltp data into data warehouse tables to build the reseller data warehouse, tracing columns from the person phone, person address, sales store, and product lines.
DimProduct Analysis2:13
FactInternetSales Analysis and Outro2:14

Adventure Works Cycles is a fictional business developed and provided by Microsoft as a sample for learning business intelligence.
In this course, I will provide you with knowledge that could be beneficial to anyone diving into the world of business intelligence and is going to use the adventure works sample databases to learn.
First, this course will learn you how to download and install SQL/SSMS and restore database backup files if you are a total beginner when it comes to using Microsoft database programs. This course covers all three of the databases provided by Microsoft: The LT (Lite) version, the OLTP (Online Transaction Process) version, and the DW (Data Warehouse) version of the 2019 Edition of Adventure Works.
In the LT section of the course, bridge tables will be explained as well as rowguids.
In the OLTP section, the schema for the entirety of the OLTP database is covered and the relationships are explained.
The Data Warehouse section covers terms such as the snowflake and star architectures. This section is also going to dwell deeper into the principles of normalization and denormalization. The documentation will be explained as well and finally the analysis of the different tables featured in the Data Warehouse.

People trying to understand Adventure Works and learn how to use Microsoft Power BI with the Adventure Works sample databases.