Cloud Data Warehouses

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).

• 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
• 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.