Hands on with AWS Redshift: Table Design – Sanjay Kotecha

Salepage link: At HERE. Archive:

A practical introduction to designing, creating, and analyzing tables on Amazon Redshift, AWS’s data warehousing solution.

01 – ABOUT THE COURSE

For decades, traditional data warehousing has been integral to business intelligence. But now, we have a new service category in this space: the cloud data warehouse. Cloud data warehouses like Amazon Redshift let you implement data warehousing solutions quickly, at scale, and at a lower cost than traditional data warehousing solutions … all with significant gains in performance.

In this introductory course, you’ll learn the ins-and-outs of designing, creating, and analyzing tables on Amazon Redshift.

Redshift makes it fast, simple, and cost-effective to analyze your data using standard SQL and your existing Business Intelligence tools. And in this age of Big Data, it’s no wonder that Amazon Redshift is one of AWS’ fastest-growing services.

Best of all, Redshift is “self-service.” It’s fully-managed by AWS, so you’ll never need to procure expensive hardware or worry about lengthy hardware deployment cycles. And disk management, hardware updates, and software patches are handled for you, freeing you to concentrate on finding and analyzing the data that matters to you. This self-service, “pay-as-you-go and grow” model helps companies avoid large capital expenditures and allows them to deploy data warehouses at much lower risk and cost. And Redshift scales almost infinitely: as your data grows, so can your Redshift data warehouse.

Redshift is an extremely powerful service. But, to take full advantage of everything it has to offer, effective table design is a must. And this introductory course will show you how that’s done.

In this course, you will learn:

• The basics of creating and launching a Redshift cluster
• Best practices for table design
• How to improve query performance
• How to perform analysis to determine if your queries are affected by poor table design

No SQL or coding experience is required. SQL queries and shell scripts are provided.

01 — ABOUT THE COURSE

For decades, traditional data warehousing has been integral to business intelligence. But now, we have a new service category in this space: the cloud data warehouse. Cloud data warehouses like Amazon Redshift let you implement data warehousing solutions quickly, at scale, and at a lower cost than traditional data warehousing solutions … all with significant gains in performance.

In this introductory course, you’ll learn the ins-and-outs of designing, creating, and analyzing tables on Amazon Redshift.

Redshift makes it fast, simple, and cost-effective to analyze your data using standard SQL and your existing Business Intelligence tools. And in this age of Big Data, it’s no wonder that Amazon Redshift is one of AWS’ fastest-growing services.

Best of all, Redshift is “self-service.” It’s fully-managed by AWS, so you’ll never need to procure expensive hardware or worry about lengthy hardware deployment cycles. And disk management, hardware updates, and software patches are handled for you, freeing you to concentrate on finding and analyzing the data that matters to you. This self-service, “pay-as-you-go and grow” model helps companies avoid large capital expenditures and allows them to deploy data warehouses at much lower risk and cost. And Redshift scales almost infinitely: as your data grows, so can your Redshift data warehouse.

Redshift is an extremely powerful service. But, to take full advantage of everything it has to offer, effective table design is a must. And this introductory course will show you how that’s done.

In this course, you will learn:

• The basics of creating and launching a Redshift cluster
• Best practices for table design
• How to improve query performance
• How to perform analysis to determine if your queries are affected by poor table design

No SQL or coding experience is required. SQL queries and shell scripts are provided.

02 — COURSE OUTLINE

CHAPTER 1:

Introduction

• Course Introduction
• Introduction to Redshift
• Lab Costs

CHAPTER 2:

Build core services and generate data

• Setting Up a Free Tier Account
• IAM
• Create a VPC
• Set up SQL Client
• Data Set
• Generating the Data

CHAPTER 3:

Implementing tables without design considerations

• Create a Redshift cluster
• Load data and run sql queries

03 — WHAT’S INCLUDED

• Access to the course
• Access to the course discussion forums

04 — WHAT PEOPLE SAY

05 — EXPECTED OUTCOMES

• You’ll be able to create and launch a Redshift cluster
• You’ll have a firm understanding of best practices in table design
• You’ll develop your skills in performing table analysis

06 — INTENDED AUDIENCE

• Developers who want to get hands-on with Redshift
• Database administrators who want to build their Redshift skills
• Big Data professionals who may not be familiar with Redshift
• Solutions architects looking to learn more about Redshift

07 — PREREQUISITES

• AWS account
• Computer with SSH client

08 — POPULAR DISCUSSIONS