AW274: Data Warehousing on AWS™

Training: AWS™ - Cloud

AWS ATP Select Tier Logo

Participants receive a practical introduction to concepts, strategies, and best practices for cloud-based data warehousing with Amazon Redshift. The course covers data ingestion, storage and transformation, performance tuning, orchestration, as well as security and monitoring. It also addresses integration with AWS™ and non-AWS™ services in accordance with the Well-Architected Framework.

Unfortunately there are currently no available appointments.
Would you like to request an appointment? Then click on 'No matching appointment?'

Request prefered appointment period:

* All fields marked with an asterisk are mandatory fields.

Agenda:

  • Data Warehouse Concepts
    • Modern data architecture
    • Introduction to the course story
    • Data warehousing with Amazon Redshift
    • Amazon Redshift Serverless architecture
    • Hands-On Lab: Launch and Configure an Amazon Redshift Serverless Data Warehouse

  • Setting up Amazon Redshift
    • Data models for Amazon Redshift
    • Data management in Amazon Redshift
    • Managing permissions in Amazon Redshift
    • Hands-On Lab: Setting up a Data Warehouse using Amazon Redshift Serverless

  • Loading Data
    • Overview of data sources
    • Loading data from Amazon Simple Storage Service (Amazon S3)
    • Extract, transform, and load (ETL) and extract, load, and transform (ELT)
    • Loading streaming data
    • Loading data from relational databases
    • Hands-On Lab: Populating the data warehouse

  • Deep Dive into SQL Query Editor v2 and Notebooks
    • Features of Amazon Redshift Query Editor v2
    • Demonstration: Using Amazon Redshift Query Editor v2
    • Advanced queries
    • Hands-On Lab: Data Wrangling on AWS™

  • Backup and Recovery
    • Disaster recovery
    • Backing up and restoring Amazon Redshift provisioned
    • Backing up and restoring Amazon Redshift Serverless

  • Amazon Redshift Performance Tuning
    • Factors that impact query performance
    • Table maintenance and materialized views
    • Query analysis
    • Workload management
    • Tuning guidance
    • Amazon Redshift monitoring
    • Hands-On Lab: Performance Tuning the Data Warehouse

  • Securing Amazon Redshift
    • Introduction to Amazon Redshift security and compliance
    • Authentication with Amazon Redshift
    • Access control with Amazon Redshift
    • Data encryption with Amazon Redshift
    • Auditing and compliance with Amazon Redshift
    • Hands-On Lab: Securing Amazon Redshift

  • Orchestration
    • Overview of data orchestration
    • Orchestration with AWS™ Step Functions
    • Orchestration with Amazon Managed Workflows for Apache Airflow (MWAA)
    • Hands-On Lab: Orchestrating the Data Warehouse Pipeline

  • Amazon Redshift ML
    • Machine Learning Overview
    • Getting started with Amazon Redshift ML
    • Amazon Redshift ML workflow scenarios
    • Amazon Redshift ML Usage
    • Hands-On Lab: Predicting customer churn with Amazon Redshift ML

  • Amazon Redshift Data Sharing
    • Overview of data sharing in Amazon Redshift
    • Amazon DataZone for Data as a service

  • Wrap-Up
    • Hands-On Lab: End of course challenge lab

Objectives:

In this course AW274 Data Warehousing on AWS™, 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

Target audience:

This course AW274 Data Warehousing on AWS™ is intended for:
  • Data engineers
  • Data architects
  • Database architects
  • Database administrators
  • Database developers

Prerequisites:

To participate in the course AW274 Data Warehousing on AWS™ at qSkills™, you should have completed the following AWS™ trainings:
In addition, you should have completed the following digital AWS™ trainings:
  • Fundamentals of Analytics on AWS™ – Part 1 (Digital Course)
  • Fundamentals of Analytics on AWS™ – Part 2 (Digital Course)

Description:

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 AW274 Data Warehousing on AWS™ 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.

This course AW274 Data Warehousing on AWS™ includes presentations, hands-on labs, and demonstrations.
check-icon

Guaranteed implementation:

from 2 Attendees

Booking information

Price:

2.685,00 € plus VAT.

(including lunch & drinks)

Authorized training partner

NetApp Partner Authorized Learning
Commvault Training Partner
CQI | IRCA Approved Training Partner
Veeam Authorized Education Center
Acronis Authorized Training Center
AWS Partner Select Tier Training
ISACA Accredited Partner
iSAQB
CompTIA Authorized Partner
EC-Council Accredited Training Center

Memberships

Allianz für Cyber-Sicherheit
TeleTrust Pioneers in IT security
Bundesverband der IT-Sachverständigen und Gutachter e.V.
Bundesverband mittelständische Wirtschaft (BVMW)
Allianz für Sicherheit in der Wirtschaft
NIK - Netzwerk der Digitalwirtschaft
BVSW
Bayern Innovativ
KH-iT
CAST
IHK Nürnberg für Mittelfranken
eato e.V.
Sicherheitsnetzwerk München e.V.