You are leaving our Website
Using an external Link:
You are now leaving our website. The following page is operated by a third party. We accept no responsibility for the content, data protection, or security of the linked page..
URL:
AW274: Data Warehousing on AWS™
Training: AWS™ - Cloud
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?'
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.
Guaranteed implementation:
from 2 Attendees
Booking information:
Duration:
3 Days
Price:
2.685,00 € plus VAT.
(including lunch & drinks)
Appointment selection:
No appointment available
Authorized training partner
Authorized training partner
Memberships
Memberships
Shopping cart
AW274: Data Warehousing on AWS™
was added to the shopping cart.