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

Building Batch Data Pipelines on GCP auf Deutsch
Google Cloud via Coursera Building Batch Data Pipelines on GCP en Français
Google Cloud via Coursera Mastering Azure Data Factory: From Basics to Advanced Level
Udemy Data Science de A a Z - Extraçao e Exibição dos Dados
Udemy Building Batch Data Processing Solutions in Microsoft Azure
Pluralsight