Data Warehousing on AWS (DWAWS)

 

Course Overview

Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift. This course demonstrates how to ingest, store, and transform data in the data warehouse. Topics covered include: the purpose of Amazon Redshift, how Amazon Redshift addresses business and technical challenges, features and capabilities of Amazon Redshift, designing a Data Warehousing Solution on AWS by applying best practices based on the Well-Architected Framework, integration with AWS and non-AWS products and services, performance tuning, orchestration, and securing and monitoring Amazon Redshift.

Who should attend

This course is intended for:

  • Data engineers
  • Data architects
  • Database architects
  • Database administrators
  • Database developers

Prerequisites

We recommend that attendees of this course have completed the following courses:

Course Objectives

In this course, you will learn to:

  • Describe Amazon Redshift architecture and its roles in a modern data architecture
  • Design and implement a data warehouse in the cloud using Amazon Redshift
  • Identify and load data into an Amazon Redshift data warehouse from a variety of sources
  • Analyze data using SQL QEV2 notebooks
  • Design and implement a disaster recovery strategy for an Amazon Redshift data warehouse
  • Perform maintenance and performance tuning on an Amazon Redshift data warehouse
  • Secure and manage access to an Amazon Redshift data warehouse
  • Share data between multiple Redshift clusters in an organization
  • Orchestrate workflows in the data warehouse using AWS Step Functions state machines
  • Create an ML model and configure predictors using Amazon Redshift ML

Prices & Delivery methods

Online Training
Modality: L

Duration 3 days

Price
  • Eastern Europe: 1,995.— €
Dates and Booking
Request a date
Classroom Training
Modality: C

Duration 3 days

Price
  • Eastern Europe: 1,995.— €
Dates and Booking
Request a date

Schedule

English

1 hour difference

Online Training Time zone: Greenwich Mean Time (GMT)
Online Training Time zone: British Summer Time (BST)
Online Training Time zone: British Summer Time (BST)

6 hours difference

Online Training 1 day Time zone: Eastern Standard Time (EST)
Online Training 1 day Time zone: Eastern Standard Time (EST)
Online Training Time zone: Eastern Daylight Time (EDT)
Online Training Time zone: Eastern Daylight Time (EDT)

7 hours difference

Online Training Time zone: Central Daylight Time (CDT)
Online Training Time zone: Central Daylight Time (CDT)

9 hours difference

Online Training Time zone: Pacific Standard Time (PST)
Online Training Time zone: Pacific Standard Time (PST)
Instructor-led Online Training:   This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
This is a FLEX course, which is delivered both virtually and in the classroom. All FLEX courses are also Instructor-led Online Trainings (ILO).

Europe

Germany

 Hamburg This is a FLEX course.   Time zone: Central European Time (CET) Enroll:
for online training
for classroom training
Munich This is a FLEX course.   Time zone: Central European Summer Time (CEST) Enroll:
for online training
for classroom training
Berlin This is a FLEX course.   Time zone: Central European Summer Time (CEST) Enroll:
for online training
for classroom training

Switzerland

 Zurich This is a FLEX course.   Time zone: Central European Time (CET) Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Central European Time (CET) Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Central European Summer Time (CEST) Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Central European Summer Time (CEST) Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Central European Summer Time (CEST) Enroll:
for online training
for classroom training
Zurich This is a FLEX course.   Time zone: Central European Time (CET) Enroll:
for online training
for classroom training
This is a FLEX course, which is delivered both virtually and in the classroom. All FLEX courses are also Instructor-led Online Trainings (ILO).