• video_business

Course: Amazon Web Services Redshift Workshop

Pre-requisites to attend:

  • To benefit from this Amazon Web Services course, you will need to have basic IT application development and deployment concepts, and good understanding of data warehousing and analytics tools, prior to attending.

Total Course Duration:

  • 3 Days


This 3-day program will teach you all the fundamentals of cloud computing as well as Amazon Web Services cloud and AWS Redshift through a mixture of lectures, demonstrations, and hands-on exercises. By the end of the course you will have enough hands-on experience with Amazon Web Services to be able to deploy, configure and secure your own scalable web applications on the Amazon cloud. You will also be able to programmatically create and manage AWS services using the AWS APIs.

Takeaways from Workshop:

  • Understand all aspects of Cloud Computing
  • Understand the architecture and components of Amazon Web Services
  • Deploy scalable web applications on the Amazon Web Services cloud
  • Get hands-on training with the key services provided by AWS
  • Understand the AWS‘s data warehouse-as-a-service offering Redshift and how to use the same along with BI tools.

Target Audience:

If you are a developer, lead or manager interested in getting started in cloud computing withAmazon Web Services and want to use its Redshift service in particular, you should find this course both challenging and engaging. The program is also suitable for professionals working with ISVs/software product companies who would like to migrate their in-premise software product to the cloud so that it can be delivered as SaaS.


To benefit from this Amazon Web Services course, you will need to have basic IT application development and deployment concepts, and good understanding of data warehousing and analytics tools, prior to attending.

Delivery Method:

This is a hands-on course and you will work on exercises, quizzes and coding sessions which are designed to make you skilled in deploying, configuring and managing cloud applications for running on the Amazon Web Services cloud.

Program Content

Introduction to the cloud

What is a cloud? What a cloud is not: Grid, parallel computing, VM, etc.

Cloud Computing Service Models


Cloud Computing Deployment Models

Public cloud, Private cloud, Hybrid cloud, Community cloud

Advantages of cloud computing

Cost model change, TCO reduction, Time to Market, Reduction in operation overheads

Challenges of cloud computing

Security, Data privacy, Performance, Availability

Getting started with Amazon Web Services

The Amazon Elastic Compute Cloud (EC2)

  • Creating an account on the Amazon cloud
  • Starting a server instance
  • Allocating storage and other resources
  • Deploying an application

The Amazon Simple Storage Service (S3)

  • The Simple Storage Service
  • Creating buckets and bucket policies
  • Creating and storing objects
  • Retrieving stored data from S3

Amazon Elastic Block Store

  • Adding storage to server instances
  • Deploying storage
  • Taking snapshots of EBS
  • Restoring EBS volumes

Amazon Elastic Load Balancing

  • Creating a load balancer
  • Adding instances to the ELB
  • Performing health checks on balanced instances

Monitoring with Amazon CloudWatch

  • Setting up Amazon Cloud monitoring
  • Setting / configuring alarms / alerts
  • Notifications on events
  • Monitoring metrics

Data – Amazon Dynamo DB and RDS

  • Dynamo DB services
  • Storage of unstructured and structured data
  • Using the Relational Data Service
  • Securing data in Simple DB and RDS

Other AWS services

  • Virtual Private Cloud
  • CloudFront content delivery network
  • Route53 DNS service
  • Simple Notification Service
  • Simple Queue Service
  • Amazon Elastic Beanstalk, etc

AWS Billing and Credentials Management

  • AWS account activity and management
  • AWS Identity and Access Management
  • Billing, usage analysis and reports
  • Security credentials and keys management

Data Movement to and from AWS

  • Import/Export
  • Data pipeline
  • AWS Storage Gateway
  • Third party tools for data backup (e.g. NetBackup, CA, CommVault, RiverBed)
  • Using third-party tools to migrate DB data to AWS databases and Redshift (e.g.Informatica, Hapyrus, Attunity, Talend, SnapLogic, Pentaho or Jaspersoft, etc.)

Introduction to AWS Redshift

  • AWS Redshift – Data Warehouse-as-a-Service
  • Features
  • Pricing

Redshift Architecture

  • Clusters
  • Leader and Compute Nodes
  • Node slices
  • Columnar storage for performance
  • Star Schema support

Getting started with AWS Redshift

  • Launch a Redshift cluster
  • Authorise access to cluster
  • Connect to the cluster
  • Load sample data into cluster
  • Create and test queries against the data

Migration of existing BI Systems to Redshift

  • Analytics on Redshift
  • ETL on Redshift
  • JDBC/ODBC interfaces
  • Support for Informatica, Microstrategy, Business Objects, etc.

Overview of Informatica's Cloud Offering

  • Informatica cloud iPaaS – features
  • iPaaS capabilities
  • Development on iPaaS
  • Integration with iPaaS
  • Data security on the platform

Hosting Informatica on AWS vs. Informatica Cloud

  • Informatica cloud – pros and cons
  • Informatica on AWS – pros and cons
  • Decision-making for different use cases

Cared and Crafted by: Velociter

Scroll to Top