• Post category:StudyBullet-9
  • Reading time:4 mins read


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

What you will 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.

Description


Get Instant Notification of New Courses on our Telegram channel.


  • 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.
English
language

Content

Introduction

Introduction and setup of SQL/SSMS
Downloading and importing Adventure Works backup databases

Adventure Works Lite Database

Adventure Works Lite and Bridge Tables
Rowguids

Adventure Works OLTP Database

dbo Schema
HumanResources Schema
Person Schema
Production Schema
Purchasing Schema
Sales Schema

Adventure Works Data Warehouse Database

Data Warehousing
Normalization and Denormalization
Documentation
DimReseller Analysis
DimDate and FactResllerSales Analysis
DimProduct Analysis
FactInternetSales Analysis and Outro