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 Lakes for Big Data
EdCast Distributed Computing with Spark SQL
University of California, Davis via Coursera Modernizing Data Lakes and Data Warehouses with Google Cloud
Google Cloud via Coursera Data Engineering with AWS
Udacity Preparing for Google Cloud Certification: Cloud Data Engineer
Google Cloud via Coursera