Course details

Scalable Data Architectures: Introduction to Amazon Redshift

Scalable Data Architectures: Introduction to Amazon Redshift


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Using a hands-on lab approach, explore how to use Amazon Redshift to set up and configure a data warehouse on the cloud in this 9-video course. Discover how to interact with Redshift service with both the console and Amazon Web Services (AWS) Command Line Interface (CLI). Key concepts covered here include how to use the Amazon Redshift Quick Launch feature to provision a data warehouse; provisioning a Redshift cluster with the default cluster; and tool configuration options for a Redshift cluster, and metrics available to optimize a cluster configuration. Next, learn how to create Identity and Access Management (IAM) roles on AWS that include necessary permissions to interact with Redshift and S3 services; to provision an IAM user that can connect to and interact with AWS using the CLI; and to install the AWS command-line interface to create and delete Redshift clusters. Then learn to use Redshift Query Editor to create tables, load data, and run queries; and learn features of Amazon Redshift and commands and configurations needed to work with Redshift by using the CLI.



Expected Duration (hours)
0.9

Lesson Objectives

Scalable Data Architectures: Introduction to Amazon Redshift

  • Course Overview
  • 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
  • Course Number:
    it_dssdarcdj_02_enus

    Expertise Level
    Beginner