Note: This course is additionally enriched with content from the course Building Data Analytics Solutions using Amazon Redshift.
In this course, you will learn concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. We will demonstrate how to collect, store, and prepare data for the data warehouse by using other AWS services, such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis Firehose, and Amazon Simple Storage Service (Amazon S3). We will also explore how to use business intelligence (BI) tools to perform analysis on your data.
Module 1: Introduction to Data Warehousing
Module 2: Introduction to Amazon Redshift
Module 3: Launching clusters
Module 4: Designing the database schema
Module 5: Identifying data sources
Module 6: Loading data
Module 7: Writing queries and tuning for performance
Module 8: Amazon Redshift Spectrum
Module 9: Maintaining clusters
Module 10: Analyzing and visualizing data
This course and other courses in the Data Analytics Job Role track will prepare you for the AWS Data Analytics certification.
Instructor-led training, hands-on labs, demonstrations, and group exercises.
This course is intended for the following job roles:
We recommend that attendees of this course have the following prerequisites:
and have attended the following course (or have equivalent knowledge): Building Data Lakes on AWS
The training is carried out in cooperation with an authorized training partner.
For the purpose of implementation, participant data will be transferred to the training partner and the training partner assumes responsibility for the processing of these data.