Amazon Redshift Training Overview
Amazon Redshift is a high performance, petabyte-scale data warehouse platform. Accelebrate's Amazon Redshift Architecture and SQL training teaches participants the basic and advanced levels of Amazon Redshift Architecture and SQL, enabling them to take full advantage of the platform's capabilities.
Location and Pricing
Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for private corporate training on-site or online, please contact us.
In addition, some courses are available as live, instructor-led training from one of our partners.
Objectives
- Gain a detailed understanding of the Redshift architecture
- Create and manage tables and objects
- Utilize stored procedures and user-defined functions
- Master performance tuning
- Gain basic, intermediate, and advanced SQL skills
Prerequisites
No prior experience is required.
Outline
The Redshift Architecture
Best Practices For Table Design
System Tables
Compression
Workload Management (WLM)
Basic SQL Functions
The WHERE Clause
Distinct Vs. Group By AND TOP
AggregationCasting a Data Type
Join Functions
Date Functions
Analytics
Temporary Tables
Sub-query Functions
Strings
Interrogating the Data
View Functions
Set Operators Functions
Table Create and Data Types
Data Manipulation Language (DML)
EXPLAIN
User-Defined Functions
Stored Procedures
Statistical Aggregate Functions
Mathematical Functions
Conclusion
Training Materials
All Amazon Redshift training students receive comprehensive courseware in electronic format.
Software Requirements
Internet access via Firefox, Chrome, or Microsoft Edge is required in order to access the remote environment used for this training.
