Data Warehousing on AWS (AWS-DATA-WH)

PT22254
Training Summary
Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates 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 S3. Additionally, this course demonstrates how to use business intelligence tools to perform analysis on your data.
Prerequisites
  • Courses taken: AWS Technical Essentials (or equivalent experience with AWS)
  • Familiarity with relational databases and database design concepts
Duration
3.0 Days/Lecture & Lab
Audience
  • Database architects
  • Database administrators
  • Database developers
  • Data analysts and scientists
Course Topics
  • Introduction to Data Warehousing
  • Introduction to Amazon Redshift
  • Launching Clusters
  • Designing the Database Schema
  • Identifying Data Sources
  • Loading Data
  • Writing Queries and Tuning Performance
  • Amazon Redshift Spectrum
  • Maintaining Clusters
  • Analyzing and Visualizing Data

Related Scheduled Courses