• Online, Self-Paced
Course Description

Using a hands-on lab approach, explore how to use Amazon Redshift to set up and configure a data warehouse on the cloud. Discover how to interact with the Redshift service using both the console and the AWS CLI.

Learning Objectives

Scalable Data Architectures: Introduction to Amazon Redshift

  • use the Amazon Redshift Quick Launch feature to provision a data warehouse on Amazon Web Services
  • define additional configuration options when provisioning a Redshift cluster by using the default cluster
  • recognize the various tool configuration options available for a Redshift cluster and use the metrics available to optimize a cluster configuration
  • create an IAM role on AWS that includes the necessary permissions to interact with the Redshift and S3 services
  • provision an IAM user that can be used to connect to and interact with AWS using the CLI
  • install the AWS command line interface and use it to create and delete Redshift clusters
  • use the Redshift Query Editor to create tables, load data, and run queries
  • recall the features of Amazon Redshift and the commands and configurations needed to work with Redshift using the CLI

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.