Amazon AWS Redshift Training

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