Scalable Data Architectures: Using Amazon Redshift & QuickSight

Data Architecture    |    Beginner
  • 12 videos | 1h 17m 37s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 18 users Rating 4.6 of 18 users (18)
In this 12-video course, explore the loading of data from an external source such as Amazon S3 into a Redshift cluster, as well as configuration of snapshots and resizing of clusters. Discover how to use Amazon QuickSight to visualize data. Key concepts covered in this course include using the AWS console to load data sets to Amazon S3 and then into a table provisioned on a Redshift cluster; running queries on data in a Redshift cluster with the query evaluation feature; and working with SQL Workbench to connect to and query data in a Redshift cluster. Learn how to disable automated snapshots for a Redshift cluster and configure a table to be excluded from snapshots; recover an individual table from the snapshot of an entire cluster; and create a security group rule enabling access from Amazon's QuickSight servers to a Redshift cluster. Next, configure Amazon QuickSight to load data from a table in a Redshift cluster for analysis; and use the QuickSight dashboard to generate a time series plot to visualize sales at a retailer over time.

WHAT YOU WILL LEARN

  • Use the aws console to load datasets to amazon s3 and then load that data into a table provisioned on a redshift cluster
    Run queries on data in a redshift cluster and use the query evaluation feature to analyze the query execution metrics
    Work with the sql workbench client to connect to and query data in a redshift cluster
    Disable automated snapshots for a redshift cluster and configure a table to be excluded from snapshots
    Recover an individual table from the snapshot of an entire cluster
    Add more nodes to a redshift cluster
  • Scale up each individual node of a redshift cluster and scale down the number of nodes
    Create a security group rule to enable access from amazon's quicksight servers to a redshift cluster
    Configure amazon quicksight to load data from a table in a redshift cluster for analysis
    Use the quicksight dashboard to generate a time series plot to visualize sales at a retailer over time
    Configure snapshots of redshift clusters and recall the steps involved in analyzing data in redshift using quicksight

IN THIS COURSE

  • 2m 49s
  • 8m 28s
    Learn how to use the AWS console to load datasets to Amazon S3 and then load that data into a table on a Redshift cluster. FREE ACCESS
  • Locked
    3.  Running Queries and Evaluating Their Execution
    4m 58s
    During this video, you will learn how to run queries on data in a Redshift cluster and use the query evaluation feature to analyze query execution metrics. FREE ACCESS
  • Locked
    4.  Querying a Redshift Cluster Using a SQL client
    9m 5s
    In this video, you will work with the SQL Workbench client to connect to and query data in a Redshift cluster. FREE ACCESS
  • Locked
    5.  Working with Automated Snapshots
    8m 57s
    In this video, you will learn how to disable automated snapshots for a Redshift cluster and configure a table to be excluded from snapshots. FREE ACCESS
  • Locked
    6.  Restoring Tables from a Snapshot
    7m 47s
    Learn how to recover an individual table from a snapshot of an entire cluster. FREE ACCESS
  • Locked
    7.  Horizontal Scaling of a Redshift Cluster
    8m 44s
    In this video, you will learn how to add more nodes to a Redshift cluster. FREE ACCESS
  • Locked
    8.  Vertical and Horizontal Scaling of a Cluster
    3m 37s
    To scale up each individual node of a Redshift cluster, find out how to scale down the number of nodes. FREE ACCESS
  • Locked
    9.  Configuring Access from QuickSight to Redshift
    8m 38s
    In this video, you will learn how to create a security group rule to enable access from Amazon's QuickSight servers to a Redshift cluster. FREE ACCESS
  • Locked
    10.  Loading a Dataset to QuickSight
    5m 30s
    In this video, you will learn how to configure Amazon QuickSight to load data from a table in a Redshift cluster for analysis. FREE ACCESS
  • Locked
    11.  Creating Visualizations with QuickSight
    3m 50s
    In this video, you'll learn how to use the QuickSight dashboard to generate a time series plot to visualize sales at a retailer over time. FREE ACCESS
  • Locked
    12.  Exercise: Working with Redshift and QuickSight
    5m 16s
    In this video, you will learn how to configure snapshots of Redshift clusters and recall the steps involved in analyzing data in Redshift using QuickSight. 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

Course AWS Solutions Architect Associate 2022: Managing S3 Buckets
Rating 4.5 of 328 users Rating 4.5 of 328 users (328)
Course AWS Developer Associate 2022: Storage Services
Rating 4.6 of 70 users Rating 4.6 of 70 users (70)
Course AWS Solutions Architect Professional 2022: Databases & Caching
Rating 4.5 of 19 users Rating 4.5 of 19 users (19)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Modern Data Management: Data Management Systems
Rating 3.9 of 267 users Rating 3.9 of 267 users (267)
Course AWS Associate Solutions Architect 2020: EC2 Instance Management
Rating 4.7 of 135 users Rating 4.7 of 135 users (135)
Course Data Pipeline: Process Implementation Using Tableau & AWS
Rating 3.4 of 8 users Rating 3.4 of 8 users (8)