60% CompleteCourses »
Data Warehousing on Cloud with AWS Platform
Creating and Migrating a Data Warehouse on Cloud using AWS Platform
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
What is Amazon Redshift?
Benefits and Key Features
System Overview and Architecture
Getting Started - Using Amazon Redshift Database
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?
Lab - Creating / Loading a Data Warehouse on AWS Redshift using Matillion
Migrating a Data Warehouse on AWS Cloud Platform
Approach to Migrate Data Warehouse on Cloud Platform
Who Should Attend?
Data Warehouse Architects
Database developers, Data analysts and scientists
Prerequisites to learn:
Familiar with Relational databases and database design concepts