logo

AWS Course

course overview

download outline

Select Country and City to View dates & book now

Overview

Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using other AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3. Additionally, this course demonstrates how to use Amazon QuickSight to perform analysis on your data.

Target Audience

  • Database architects
  • Database administrators
  • Database developers
  • Data analysts and scientists

Delivery Method

This course is delivered through a mix of:

  • Instructor-Led Training (ILT)
  • Hands-On Labs

Hands-On Activity

This course allows you to test new skills and apply knowledge to your working environment through a variety of practical exercises.

Prerequisites

We recommend that attendees of this course have the following prerequisites:

  • Courses taken: AWS Technical Essentials (or equivalent experience with AWS)
  • Familiarity with relational databases and database design concepts

Outline

Day 1

  • Course Introduction
  • Introduction to Data Warehousing
  • Introduction to Amazon Redshift
  • Understanding Amazon Redshift Components and Resources
  • Launching an Amazon Redshift Cluster

Day 2

  • Choosing a Data Warehousing Approach
  • Identifying Data Sources and Requirements
  • Architecting the Data Warehouse
  • Loading Data into the Data Warehouse

Day 3

  • Optimizing Queries and Tuning Performance
  • Monitoring and Auditing the Data Warehouse
  • Maintaining the Data Warehouse
  • Analyzing and Visualizing Data

Certification

Labs - Please note: The labs for your AWS course will be delivered through AWS Builder labs. In order to access these labs you will need to have an Amazon BuilderID. You can set up your new Amazon account here. Please ensure that you have set up this Amazon BuilderID in advance of attending your class.

Courseware – Please note: In order to access your digital course materials you are required to set up a Gilmore account in advance of attending your course. To do this please follow this link.

Please also be aware that in order to access your materials and Labs it is important that your device and network should not restrict access to AWS or Vitalsource content. For that reason, AWS recommend NOT using a Corporate laptop with any security restrictions in place or the use of a VPN.

Talk to an expert

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. Its a cost effective option. One on one training can be delivered too, at reasonable rates.

Submit an enquiry from any page on this site and let us know you are interested in the requirements box, or simply mention it when we contact you.

All $ prices are in USD unless it’s a NZ or AU date

SPVC = Self Paced Virtual Class

LVC = Live Virtual Class

Please Note: All courses are availaible as Live Virtual Classes

Trusted by over 1/2 million students in 15 countries

Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well as public sector institutions such as the Department of Defence and the Department of Health.