Scalable Data Architectures: Using Amazon Redshift & QuickSight

Data Architecture    |    Beginner
  • 12 Videos | 1h 22m 37s
  • Includes Assessment
  • Earns a Badge
Likes 23 Likes 23
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

  • Playable
    1. 
    Course Overview
    2m 49s
    UP NEXT
  • Playable
    2. 
    Loading Data from Amazon S3 to a Redshift Cluster
    8m 28s
  • Locked
    3. 
    Running Queries and Evaluating Their Execution
    4m 58s
  • Locked
    4. 
    Querying a Redshift Cluster Using a SQL client
    9m 5s
  • Locked
    5. 
    Working with Automated Snapshots
    8m 57s
  • Locked
    6. 
    Restoring Tables from a Snapshot
    7m 47s
  • Locked
    7. 
    Horizontal Scaling of a Redshift Cluster
    8m 44s
  • Locked
    8. 
    Vertical and Horizontal Scaling of a Cluster
    3m 37s
  • Locked
    9. 
    Configuring Access from QuickSight to Redshift
    8m 38s
  • Locked
    10. 
    Loading a Dataset to QuickSight
    5m 30s
  • Locked
    11. 
    Creating Visualizations with QuickSight
    3m 50s
  • Locked
    12. 
    Exercise: Working with Redshift and QuickSight
    5m 16s

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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE