Amazon Redshift Architecture and SQL

PT15195
Training Summary
In this course, students will learn the Amazon Redshift Architecture and SQL starting at the most basic level and going to the most advanced level with many examples.
Prerequisites
There are no prerequisites for this course.
Duration
2-3 Days/Lecture & Lab
Audience
This course is designed for anyone who has a desire to learn the Amazon Redshift Architecture and SQL from beginners to an advanced audience. This course is completely customizable by the client.
Course Topics
  • Basic SQL Functions
  • The WHERE Clause
  • Distinct Vs. Group By
  • Aggregation Function
  • Join Functions
  • Date Functions
  • OLAP Functions
  • Temporary Tables
  • Sub-query Functions
  • Strings
  • Interrogating the Data
  • View Functions
  • Set Operators
  • Data Manipulation Language (DML)
  • Statistical Aggregate Functions

Related Scheduled Courses