Amazon Redshift Workshop

2 Day Classroom  •  2 Day Live Online
2 Day Training at your location.
Adjustable to meet your needs.
Individual:
$1550.00
Group Rate:
$1350.00
When training eight or more people, onsite team training offers a more affordable and convenient option.
Register Now
Request Quote
Individual
Onsite
Overview

This Amazon Redshift training prepares attendees for success with the Amazon Redshift data warehouse in the AWS cloud. Redshift offers particular value when it comes to handling enormous datasets and large repositories of data which underpin big data applications and large-scale database migrations. Beginning with the fundamentals of Redshift, you’ll cover data loading, data distribution, tuning query performance, data large-scale clusters. Led by an expert engineering instructor, you’ll learn the benefits of Redshift and how Redshift compares to other tools available for handling the data warehouse.

In this Amazon Redshift Training Course, You Will Learn How to:

  • Create an AWS account
  • Create a Redshift Cluster
  • Configure SQL Workbench
  • Load data into S3
  • Load data into a Redshift Cluster
  • Query a Redshift Cluster
  • Connect with and use Tableau
Upcoming Dates and Locations
Guaranteed To Run

There aren’t any public sessions currently scheduled for this course, but if you fill out the form below, we can tell you about how we can bring this course to you!

Course Outline
  • Introduction
    • What Is A Data Warehouse?
    • Shortcomings Of Self-Owned Data Warehouses
    • Benefits Of A Public Cloud Data Warehouse
    • Benefits Of Redshift
    • How Companies Use Redshift
    • Third Party Visualization Tools Overview
    • How Redshift Compares To Other Analytics Tools
    • How To Use The Working Files
  • Redshift Basics
    • Architecture
    • Data Loading
    • Data Distribution Concepts
    • Basic Redshift Usage
  • Advanced Topics
    • Data Loading Best Practices
    • Tuning Query Performance
  • Conclusion
Who should attend
  • Business Intelligence (BI) Analyst
  • Cloud Data Engineer
  • Cloud Infrastructure Engineer
  • Data Architect 
  • Data Governance Manager
  • Data Modeler
  • Data Scientist
  • Database Engineer
  • Site Reliability Engineer
  • Software Engineer
Bonus Materials

All Amazon Redshift training students receive comprehensive courseware in electronic format

Pre-Requisites

No prior experience is required.

Download the brochure