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 Servicesdefine additional configuration options when provisioning a Redshift cluster by using the default clusterrecognize the various tool configuration options available for a Redshift cluster and use the metrics available to optimize a cluster configurationcreate 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 CLIinstall the AWS command line interface and use it to create and delete Redshift clustersuse the Redshift Query Editor to create tables, load data, and run queriesrecall the features of Amazon Redshift and the commands and configurations needed to work with Redshift using the CLI
IN THIS COURSE
-
1.Course Overview2m 35sUP NEXT
-
2.Provisioning a Redshift Cluster Using Quick Launch7m 42s
-
3.Creating a Redshift Cluster With Additional Detail5m 55s
-
4.Exploring the Redshift Configs and Metrics5m 17s
-
5.Attaching an IAM Role to a Redshift Cluster4m 29s
-
6.Creating an AWS User to Work With Redshift6m 48s
-
7.Installing and Configuring the AWS CLI7m 38s
-
8.Running Queries from the Redshift Query Editor8m 47s
-
9.Exercise: An Introduction to Amazon Redshift5m 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.