60% Complete Courses » Data Warehousing on Cloud with AWS Platform
  • Course Content
  • Course Overview
  • Training Schedule
  • Demo Video
  • Learning Material
  • Register

Creating and Migrating a Data Warehouse

Creating and Migrating a Data Warehouse on Cloud using AWS Platform

Course Overview

In this course, the students will learn, how to create a new Data Warehouse on Cloud and migrate an existing Data Warehouse on Cloud, using AWS Platform.

Course objective:
This course is intended to provide an understanding on how to model a Data Warehouse on Cloud using the Amazon Redshift service and then load the data into the Data Warehouse using a server-less ETL tool, called Matillion.It will also help in providing a deeper dive into different approaches which can be used to Migrate a Data Warehouse on AWS Cloud platform. This training will also give an introductory insight into Cloud Computing and AWS Fundamentals, specifically for the trainees who are new to AWS infrastructure.

Introduction to AWS

  • What is Cloud Computing and Why is it needed?
  • What is Amazon Web Services?
  • Architecture of AWS
  • Key Services in AWS
Amazon Redshift
  • What is Amazon Redshift?
  • Benefits and Key Features
  • Pricing Overview
  • System Overview and Architecture
Getting Started - Using Amazon Redshift Database
  • Designing Tables
  • Lab 1 - Using Amazon Redshift Database to create a Data Model
  • Lab 2 - Loading data into Amazon Redshift Database from Amazon S3
  • Amazon Redshift - Best Practices
  • What is Matillion?
  • Orchestration Components
  • Transformation Components
  • Lab - Creating / Loading a Data Warehouse on AWS Redshift using Matillion
Migrating a Data Warehouse on AWS Cloud Platform
  • Architecture Options
  • Approach to Migrate Data Warehouse on Cloud Platform
  • Best Practices
Who Should Attend?
  • ETL Developers
  • Data Warehouse Architects
  • Database architects
  • Database administrators
  • Database developers, Data analysts and scientists
Prerequisites to learn:
  • Familiar with Relational databases and database design concepts
  • Familiar with Data Warehouse concepts
  • Fresher can also take the training
Course Duration: 25-30 hours
Course Id:
Course Fees:
301 USD