Scalable Data Architectures: Using Amazon Redshift

Data Architecture    |    Beginner
  • 9 Videos | 54m 14s
  • Includes Assessment
  • Earns a Badge
Likes 25 Likes 25
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
    FREE ACCESS
  • Locked
    4. 
    Exploring the Redshift Configs and Metrics
    5m 17s
    FREE ACCESS
  • Locked
    5. 
    Attaching an IAM Role to a Redshift Cluster
    4m 29s
    FREE ACCESS
  • Locked
    6. 
    Creating an AWS User to Work With Redshift
    6m 48s
    FREE ACCESS
  • Locked
    7. 
    Installing and Configuring the AWS CLI
    7m 38s
    FREE ACCESS
  • Locked
    8. 
    Running Queries from the Redshift Query Editor
    8m 47s
    FREE ACCESS
  • Locked
    9. 
    Exercise: An Introduction to Amazon Redshift
    5m 4s
    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 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

COURSE AWS Developer Associate 2021: Optimization
COURSE AWS Developer Associate 2021: AWS Analytics Services
COURSE AWS SysOps Associate 2021: Storage Management
Likes 6 Likes 6  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Data Lake Sources, Visualizations, & ETL Operations
Likes 32 Likes 32  
COURSE Data Architecture Getting Started
Likes 379 Likes 379  
COURSE Apache Spark Getting Started
Likes 193 Likes 193