Scalable Data Architectures: Using Amazon Redshift
Data Architecture
| Beginner
- 9 videos | 54m 14s
- Includes Assessment
- Earns a Badge
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 42sIn 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
-
3. Creating a Redshift Cluster With Additional Detail5m 55sTo find out how to define additional configuration options when provisioning a Redshift cluster, use the default cluster. FREE ACCESS
-
4. Exploring the Redshift Configs and Metrics5m 17sUpon 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
-
5. Attaching an IAM Role to a Redshift Cluster4m 29sLearn how to create an IAM role on AWS that includes the necessary permissions to interact with the Redshift and S3 services. FREE ACCESS
-
6. Creating an AWS User to Work With Redshift6m 48sIn 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
-
7. Installing and Configuring the AWS CLI7m 38sIn this video, you will install the AWS command line interface and use it to create and delete Redshift clusters. FREE ACCESS
-
8. Running Queries from the Redshift Query Editor8m 47sIn this video, you will use the Redshift Query Editor to create tables, load data, and run queries. FREE ACCESS
-
9. Exercise: An Introduction to Amazon Redshift5m 4sUpon 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.
