In this course, you’ll learn to create cloud-based data warehouses. You’ll sharpen your data warehousing skills, deepen your understanding of data infrastructure, and be introduced to data engineering on the cloud using Amazon Web Services (AWS).
Overview
Syllabus
- Introduction to Cloud Data Warehouses
- Welcome to Cloud Data Warehouse with Amazon Web Services. In this lesson, you'll learn more about the course and set yourself up for success!
- Introduction to Data Warehouses
- In this lesson, you'll be introduced to the business case for data warehouses as well as architecture, extracting, transforming, and loading data, data modeling, and data warehouse technologies.
- ELT and Data Warehouse Technology in the Cloud
- In this lesson, you'll learn about ELT, the differences between ETL and ELT, and general cloud data warehouse technologies.
- AWS Data Warehouse Technologies
- In this lesson, you'll learn about AWS Services and how to set up Amazon S3, IAM, VPC, EC2, and RDS. You'll build a Redshift data warehouse cluster and learn how to interact with it.
- Implementing a Data Warehouse on AWS
- In this lesson, you'll learn to implement a data warehouse on AWS
- Project: Data Warehouse
- In this project, you'll build an ETL pipeline that extracts data from S3, stages data in Redshift, and transforms data into a set of dimensional tables for an analytics team.
Taught by
nd073 Matt Swaffer and nd073 Valerie Scarlata
