• Online, Self-Paced
Course Description

Explore the loading of data from an external source such as Amazon S3 into a Redshift cluster, as well as the configuration of snapshots and the resizing of clusters. Discover how to use Amazon QuickSight to visualize data.

Learning Objectives

Scalable Data Architectures: Working with Amazon Redshift & QuickSight

  • use the AWS console to load datasets to Amazon S3 and then load that data into a table provisioned on a Redshift cluster
  • run queries on data in a Redshift cluster and use the query evaluation feature to analyze the query execution metrics
  • work with the SQL Workbench client to connect to and query data in a Redshift cluster
  • disable automated snapshots for a Redshift cluster and configure a table to be excluded from snapshots
  • recover an individual table from the snapshot of an entire cluster
  • add more nodes to a Redshift cluster
  • scale up each individual node of a Redshift cluster and scale down the number of nodes
  • create a security group rule to enable access from Amazon's QuickSight servers to a Redshift cluster
  • configure Amazon QuickSight to load data from a table in a Redshift cluster for analysis
  • use the QuickSight dashboard to generate a time series plot to visualize sales at a retailer over time
  • configure snapshots of Redshift clusters and recall the steps involved in analyzing data in Redshift using QuickSight

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Architecture