Introduction to Data Warehouses

Offered By: LinkedIn Learning

Tags

Business Intelligence Courses Cloud Computing Courses Data Lakes Courses ETL Courses Dimensional Modeling Courses Star Schema Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Discover the basics of data warehouses, how they function and differ from other solutions, and how to implement them in your current or future role.

Syllabus

Introduction

Introduction to data warehouses

1. Introduction to Data Warehouses

Data warehouse key concepts
Importance of data warehouses
Data lake vs. data warehouse
Data mart vs. data warehouse
ETL process
Traditional data warehouse options

2. Dimension Modeling

Dimensional modeling
Dimensional modeling vs. a traditional approach
Facts
Dimensions
Star schema
Snowflake schema

3. Create Your First Data Warehouse

How to install SQL Server
How to connect SSMS to SQL Server
How to create a data warehouse using SQL Server

4. Modern Data Warehouses

Cloud data warehouse
Cloud vs. on-premises data warehouse
Cloud data warehouse options

Conclusion

Next steps

Taught by

Deepak Goyal

Related Courses

Learn OBIEE 12C Part 1 of 6
Udemy Data Warehousing and BI Analytics
IBM via edX Data Warehouse Concepts: Basic to Advanced concepts
Udemy Curso de Power BI + Dax + Projetos na prática.
Udemy SSAS Tabular Model with Power BI - A comprehensive training
Udemy