All for Joomla All for Webmasters

AWS Redshift


Amazon Redshift Training Course Reviews

AWS-Course-ReviewsAverage of 4.9 out of 5 based on 14 Votes

About the Course

Duration: 30 hours class room program, 5 Weekends

Prerequisites: Good to have Basic Knowledge of UNIX, Database. 

  • Note: All topics will be covered with hands on lab exercises.
  • Below Course Content can be covered with no rush and 80% hands on.
  • You need AWS account for labs. Exercises shall use only free tier AWS offering.

For Details Syllabus, look to adjacent syllabus tab



Part 1: Introduction

  • Introduction to The Course
  • Getting Started, what you'll need.
  • AWS –A Look from Top Overview
  • The history of AWS so far
  • AWS - Overview
  • Mind Overload? Don't Stress!

Part 2:Data Warehousing on AWS

  • Need for Data Warehousing
  • 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

Part 3: Introduction to AWS Redshift

  • AWS Redshift- Data Warehouse-as-a-Service
  • Features
  • Pricing
  • AWS Management Console Walkthrough

Part 4: Redshift Architecture Overview

  • Architecture
  • Clusters
  • Leader and Compute Nodes
  • Node Slices
  • Columnar Storage for performance
  • Economics of Redshift
  • Key differentiators
  • Common use cases

Part 5: Redshift Fundamentals

  • Redshift Basics
  • Data Loading
  • Data Distribution Concepts
  • Basic Redshift Usage
  • Creating An AWS Account (Lab)
  • Creating A Redshift Cluster (Lab)
  • Configuring SQL Workbench (Lab)
  • Loading Data Into S3 (Lab)
  • Loading Data Into A Redshift Cluster (Lab)
  • Querying A Redshift Cluster (Lab)

Part 6: Monitoring cluster performance

  • Analysing Cluster performance data
  • Analysing query execution
  • Creating Alarm and working with performance metrics

Part 7:Unloading Data

  • Unloading Data to Amazon S3
  • Unloading Encrypted Data Files
  • Unloading Data in Delimited or Fixed-Width Format
  • Reloading unloaded data

Part 8: Performance Tuning

  • Query Processing
  • Query Planning &Execution
  • Query Analysis Workflow
  • Query PerformanceTuning –S1
  • Workload Management
  • Query Queues and Concurrency
  • WLM Configuration
  • WLM Queue Rules
  • Dynamic and Static Properties
  • Monitoring Workload Management
  • Query Performance Tuning – S2
  • Troubleshooting Queries
  • Admin queries to analyse performance

Part 9: Redshift Advance

  • Best Practices for Designing Tables
  • Best Practices Data Loading – S1
  • Best Practices Data Loading – S2
  • Unload query result
  • JSON Support
  • Loading data from EMR Cluster
  • User Defined Functions
  • Queries Troubleshooting
  • Timed Queries
  • Migration of Existing BI Systems to Redshift
  • Cross Region Data Copying
  • Data Loading from OLTP databases to Redshift and Limitations
  • ETL and ELT on Redshift
  • BI tools integration and limitation in Redshift
  • Designing Data warehouse