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

Data Warehousing Essentials for Analytics and AI Support
Northeastern University via Coursera Data Warehousing: Schema, ETL, Optimal Performance
Coursera Instructor Network via Coursera Data Modeling in Power BI
DataCamp Introduction to Data Modeling in Snowflake
DataCamp Aspectos Introdutórios de Business Intelligence
FGV Educação Executiva