Duration

3 days.

Prerequisites

  • Taken AWS Technical Essentials (or equivalent experience with AWS)
  • Familiarity with relational databases and database design concepts

Skills Gained

This course teaches you how to:

  • Discuss the core concepts of data warehousing, and the intersection between data warehousing and big data solutions
  • Launch an Amazon Redshift cluster and use the components, features, and functionality to implement a data warehouse in the cloud
  • Use other AWS data and analytic services, such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3, to contribute to the data warehousing solution
  • Architect the data warehouse
  • Identify performance issues, optimize queries, and tune the database for better performance
  • Use Amazon Redshift Spectrum to analyze data directly from an Amazon S3 bucket
  • Use Amazon QuickSight to perform data analysis and visualization tasks against the data warehouse

Who Can Benefit?

  • Database Architects
  • Database Administrators
  • Database Developers
  • Data Analysts
  • Data Scientists

Outline for Data Warehousing on AWS Training

Day 1

  • Introduction to Data Warehousing
  • Introduction to Amazon Redshift
  • Launching Clusters

Day 2

  • Designing the Database Schema
  • Identifying Data Sources
  • Loading Data

Day 3

  • Writing Queries and Tuning Performance
  • Amazon Redshift Spectrum
  • Maintaining Clusters
  • Analyzing and Visualizing Data
01/23/2024 - 01/25/2024
09:00 AM - 05:00 PM
Eastern Standard Time
Online Virtual Class
USD $2,185.00
Enroll
03/05/2024 - 03/07/2024
09:00 AM - 05:00 PM
Eastern Standard Time
Online Virtual Class
USD $2,185.00
Enroll
04/16/2024 - 04/18/2024
12:00 PM - 08:00 PM
Eastern Standard Time
Online Virtual Class
USD $2,185.00
Enroll