**** New Regular,Weekend and Online Batches Going To Start this week..! ENROLL NOW for FREE DEMO..!Call us For more Details@9704455959****

Amazon Redshift Online Training

Hands-on with Amazon Redshift

In this Hands-on with Amazon Redshift training course, you will learn everything you need to know to be able to work with Redshift. This course is designed for the absolute beginner, meaning no previous knowledge of Amazon Redshift is required.
You will start with an introduction to the course, learning what a data warehouse is, the benefits of Redshift, and Amazon Redshift Architecture. From there, will guide you with the core concepts of Redshift, including data loading, data distribution concepts, and how effectively we can use Redshift. Also will cover advanced topics, such as data loading best practices and tuning query performance.
Once you have completed this computer based training course, you will have learned everything you need to know to get started with Amazon Redshift.

Amazon Redshift Online Training

Requirements

  • Familiarity with database concepts
  • Basic experience with Amazon Web Services (AWS)

Course Modules we cover:

Introduction to Data Warehousing

Prerequisites , Installing and Configuring Amazon Redshift

  • Create an AWS account
  • Create IAM Role
  • Launch cluster
  • Install SQL Client using JDBC/ODBC Drivers
  • Connect to the Sample Cluster and Run Queries

Amazon Redshift Architecture

  • Cluster
  • Leader Node
  • Compute Nodes
  • Node Slices
  • Zone maps

Amazon Redshift performance Features

  • Massively Parallel Processing
  • Columnar Data Storage
  • Data Compression
  • Columnar Storage

Amazon Redshift Best Practices for Designing Tables

  • Sort key
  • Distribution Style
  • Compression Encodings

Designing and Creating DB and Tables

  • Create Database
  • Create Schema
  • Amazon Redshift SQL

Data Loading and Unloading in Amazon Redshift

  • Introduction to Data Loading
  • Loading Sample Data Set into Redshift
  • Data Distribution in Redshift
  • Data Loading Best Practices
  • Unloading data from Amazon Redshift

Implementing Workload Management

  • Query Queues
  • WLM Configuration
  • WLM Query Monitoring Rules

Amazon Redshift Spectrum Overview

  • Creating External Schemas
  • Query Data from Amazon S3

System Tables and Views

  • STL Tables for Logging
  • System Views
  • System Catalog Tables

Amazon Redshift pricing

  • Clusters and Node types in Amazon Redshift
  • Cost and Reserved Nodes

Amazon Redshift Management Overview

  • Managing Clusters Using the Console.
  • Snapshots
  • Viewing Events Using the Console.

Hands on Labs

Questions and Answers

Contact for Demo
Training Enquiry Form