Amazon Redshift Getting Started

Overview

We have updated this course on April 19, 2024 to correct a problem that was impacting course completion. If you are enrolled in the course and have not completed it, your progress may be impacted. We apologize for any inconvenience this may cause.

In this course, you will learn the benefits, typical use cases, and technical concepts of Amazon Redshift. You can also try the service through a demonstration using the AWS Management Console. The cloud data warehouse service integrates with data lakes based on Amazon Simple Storage Service (Amazon S3). It also integrates with relational database services such as Amazon Relational Database Service (Amazon RDS) for PostgreSQL, Amazon Aurora PostgreSQL-Compatible Edition, Amazon RDS for MySQL, and Amazon Aurora MySQL-Compatible Edition. Amazon Redshift supports building and using machine learning (ML) models using familiar SQL commands, thereby reducing the skills needed to take advantage of ML.

Course level: Fundamental
Duration: 1 hour

Activities

This course includes presentations, graphics, and a demonstration with the option to follow along.

Course objectives

In this course, you will:

Understand how Amazon Redshift works.
Familiarize yourself with the technical concepts of Amazon Redshift.
List typical use cases for Amazon Redshift.
Specify what it would take to implement Amazon Redshift in a real-world scenario.
Recognize the benefits of Amazon Redshift.
Explain the cost structure of Amazon Redshift.
Use Amazon Redshift from the AWS Management Console.

Intended audience

This course is intended for:

Data warehouse engineers
Solutions architects

Prerequisites

We recommend that attendees of this course have:

One or more years of data warehouse management experience
Completed the AWS Technical Essentials course

Course outline

Section 1: Introductions

Introduction to Amazon Redshift
Architecture and Use Cases

Section 2: Using Amazon Redshift

How Do I Configure a Data Warehouse in Amazon Redshift?
How Do I connect to the Amazon Redshift Serverless Warehouse with Query Editor V2?
How Do I Use Materialized Views to Speed Up BI Queries?
How Do I Automate Complex, Repeated Tasks with Stored Procedures?
How Do I Clean Up Resources in Amazon Redshift?

Section 3: Getting Help