Book Image

Hands-On Amazon Redshift for Data Warehousing [Video]

By : James Cross
Book Image

Hands-On Amazon Redshift for Data Warehousing [Video]

By: James Cross

Overview of this book

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-oriented 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-
Table of Contents (6 chapters)
Chapter 4
Optimizing Redshift for Scale
Content Locked
Section 2
Optimizing Redshift Data Types for Query Performance at Scale
Understand the different data types Redshift can use and how they impact query performance. - Explore the Compression types - Learn what to use and when