Rating 5.0 out of 5 (1 ratings in Udemy)
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.
Description Rating 5.0 out of 5 (1 ratings in Udemy)
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.
DescriptionAdventure 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 filesif 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 OLTPsection, the schema for the entirety of the OLTPdatabase 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.
