Scalable Data Architectures: Using Amazon Redshift

Data Architecture    |    Beginner
  • 9 Videos | 57m 44s
  • Includes Assessment
  • Earns a Badge
Likes 17 Likes 17
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 35s
    UP NEXT
  • Playable
    2. 
    Provisioning a Redshift Cluster Using Quick Launch
    7m 42s
  • Locked
    3. 
    Creating a Redshift Cluster With Additional Detail
    5m 55s
  • Locked
    4. 
    Exploring the Redshift Configs and Metrics
    5m 17s
  • Locked
    5. 
    Attaching an IAM Role to a Redshift Cluster
    4m 29s
  • Locked
    6. 
    Creating an AWS User to Work With Redshift
    6m 48s
  • Locked
    7. 
    Installing and Configuring the AWS CLI
    7m 38s
  • Locked
    8. 
    Running Queries from the Redshift Query Editor
    8m 47s
  • Locked
    9. 
    Exercise: An Introduction to Amazon Redshift
    5m 4s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE