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

Software as a Service
University of California, Berkeley via Coursera Software Defined Networking
Georgia Institute of Technology via Coursera Pattern-Oriented Software Architectures: Programming Mobile Services for Android Handheld Systems
Vanderbilt University via Coursera Web-Technologien
openHPI Données et services numériques, dans le nuage et ailleurs
Certificat informatique et internet via France Université Numerique