Amazon Redshift brings the power of scale-out architecture to the world of traditional data warehousing. In Building Your First Amazon Redshift Data Warehouse, you will explore this low cost, cloud based storage that can be scaled up or down to meet your true size and performance needs. First, you will learn to stand up and configure a sample data warehouse. Next, you will explore the internal workings and architecture of Redshift and what makes it so fast. Finally, you will get hands on experience connecting, querying, and building BI and data viz products as well as 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.
Author Name: Russ Thomas
Author Description:
Currently an IT leader in Denver Colorado’s FinTech sector Russ has focused on database engineering, modelling, administration, and BI since 1997. Russ is a passionate trainer and community volunteer presenting regularly at tech events and local user groups around the US. In 2019 much of Russ’ focus turned to cloud based data lakes specifically on Google BigQuery, and the emerging world of large language models.

Table of Contents

• Course Overview
  1min
• Answering the Question: “Why Amazon Redshift?”
  40mins
• Populating Redshift
  41mins
• Connecting, Querying, and Consuming Data
  34mins
• Securing Your Data Warehouse
  27mins
• Exploring Advanced System Topics
  15mins