Scalable Data Architectures: Using Amazon Redshift

Data Architecture    |    Beginner
  • 9 videos | 54m 14s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 24 users Rating 4.7 of 24 users (24)
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

  • 2m 35s
  • 7m 42s
    In this video, you will learn how to use the Amazon Redshift Quick Launch feature to provision a data warehouse on Amazon Web Services. FREE ACCESS
  • Locked
    3.  Creating a Redshift Cluster With Additional Detail
    5m 55s
    To find out how to define additional configuration options when provisioning a Redshift cluster, use the default cluster. FREE ACCESS
  • Locked
    4.  Exploring the Redshift Configs and Metrics
    5m 17s
    Upon completion of this video, you will be able to recognize the various tool configuration options available for a Redshift cluster and use the metrics available to optimize a cluster configuration. FREE ACCESS
  • Locked
    5.  Attaching an IAM Role to a Redshift Cluster
    4m 29s
    Learn how to create an IAM role on AWS that includes the necessary permissions to interact with the Redshift and S3 services. FREE ACCESS
  • Locked
    6.  Creating an AWS User to Work With Redshift
    6m 48s
    In this video, you will learn how to provision an IAM user that can be used to connect to and interact with AWS using the CLI. FREE ACCESS
  • Locked
    7.  Installing and Configuring the AWS CLI
    7m 38s
    In this video, you will install the AWS command line interface and use it to create and delete Redshift clusters. FREE ACCESS
  • Locked
    8.  Running Queries from the Redshift Query Editor
    8m 47s
    In this video, you will use the Redshift Query Editor to create tables, load data, and run queries. FREE ACCESS
  • Locked
    9.  Exercise: An Introduction to Amazon Redshift
    5m 4s
    Upon completion of this video, you will be able to recall the features of Amazon Redshift and the commands and configurations needed to work with Redshift using the command line interface. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 4.7 of 840 users Rating 4.7 of 840 users (840)
Rating 4.6 of 14 users Rating 4.6 of 14 users (14)
Rating 4.9 of 9 users Rating 4.9 of 9 users (9)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 292 users Rating 4.4 of 292 users (292)
Rating 4.3 of 43 users Rating 4.3 of 43 users (43)
Rating 4.6 of 44 users Rating 4.6 of 44 users (44)