Data Warehousing on AWS

This course teaches participants how to design, build, and operate a cloud-based data warehousing solution using Amazon Redshift. Learners explore modern data warehousing concepts and best practices, focusing on how to collect, store, prepare, and analyze large-scale data in AWS. The course covers integrating Amazon Redshift with other AWS services such as Amazon S3, Amazon DynamoDB, Amazon EMR, and Amazon Kinesis Firehose to support diverse data ingestion and analytics workloads. By the end of the course, participants will be able to design scalable, high-performance data warehouses and use business intelligence tools to extract insights and support data-driven decision-making.

• Explain core data warehousing concepts and architectural approaches
• Describe Amazon Redshift architecture, components, and resources
• Launch, configure, and manage an Amazon Redshift cluster
• Identify data sources and define data warehousing requirements
• Design a scalable and efficient data warehouse schema
• Load data into Amazon Redshift from various AWS data sources
• Write and optimize SQL queries for performance and efficiency
• Monitor, maintain, and manage an Amazon Redshift data warehouse
• Integrate business intelligence tools to analyze and visualize data

• Database Architects
• Database Administrators
• Database Developers
• Data Analysts and Data Scientists
• IT professionals responsible for designing or managing data warehouse solutions

• Completion of AWS Technical Essentials or equivalent AWS experience
• Familiarity with relational databases and database design concepts
• Basic understanding of SQL and data analysis workflows