Hands-On Amazon Redshift for Data Warehousing [Video]

Hands-On Amazon Redshift for Data Warehousing [Video]

image description

Course Description

Build scalable, serverless data warehouses with machine learning and massively parallel processing in the cloud with Amazon Redshift

Amazon Redshift is a low-cost cloud data platform that can scale from gigabytes to petabytes on a high-performance, column-oriented SQL engine. Amazon Redshift brings the power of scale-out architecture to the world of traditional data warehousing.

In this course, you will explore this low-cost, cloud-based storage, which can be scaled up or down to meet your true size and performance needs. You will learn to configure a sample data warehouse. Next, you will explore Redshift's internal workings and architecture, and learn what makes it so fast. You will get hands-on experience connecting, querying, and building BI and data viz products and learn how to secure, maintain, and administer your new platform.

By the end of this course, you will be able to scale from gigabytes to petabytes on this high-performance, column-ori

ented SQL engine.

All the code files related to this course are available on Github at - https://github.com/PacktPublishing/Hands-On-Amazon-Redshift-for-Data-Warehousing-V-

What you will learn

  • Understand data warehousing principles and how Redshift is challenging the traditional way of thinking

  • See how Redshift integrates with the AWS Cloud ecosystem

  • Learn how Redshift leverages the latest technology to provide up to 10x the performance of competing technologies

  • Create a cloud native, fully managed data warehouse and use it to join together disparate data sets

  • Connect your new data warehouse with disjointed data stored on Amazon S3 with Redshift Spectrum

  • Visualise your newly connected data sets with Amazon Quicksight

  • Dive headfirst into building a Redshift data warehouse using a diversified data set

  • Connect to and optimize your data warehouse and join data sets together

  • Connect data in your data warehouse with data on Amazon S3 with Redshift spectrum

Curriculum

Section 1: Data Warehousing for the Internet Age

Section 2: Getting Started with Redshift

Section 3: Creating a Redshift Data Warehouse from Disparate Datasets

Section 4: Optimizing Redshift for Scale

Section 5: Connecting Redshift with Disconnected Data Using Redshift Spectrum

Section 6: Visualizing Your Results with Amazon QuickSight