Type
Virtual
Classroom ILT
Skill Level
Available dates
Learning Path
Virtual
Duration
1 Day
TYPE
Virtual
Classroom ILT
LEARNING PATH
SKILL LEVEL
DURATION
AVAILABLE DATES
Introduction
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.
Audience profile
This course is intended for:
- Data engineers
- Data Architects
- Database Architects
- Database administrators
- Database Developers
Pre-requisites
It is recommended that attendees of this course have:
- Building Data Lakes on AWS
- Building Data Analytics Solutions Using Amazon Redshift
Course objectives
This course is designed to teach you how 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
Course content
Session 1: Data Warehouse Concepts | |
|
|
|
|
Session 2: Setting up Amazon Redshift | |
|
|
|
|
Session 3: Loading Data | |
|
|
|
|
|
|
Session 4: Deep Dive into SQL Query Editor v2 and Notebooks | |
|
|
|
|
Session 5: Backup and Recovery | |
|
|
|
|
Session 6: Amazon Redshift Performance Tuning | |
|
|
|
|
|
|
Session 7: Securing Amazon Redshift | |
|
|
|
|
|
|
Session 8: Orchestration | |
|
|
|
|
Session 9: Amazon Redshift ML | |
|
|
|
|
Session 10: Amazon Redshift Data Sharing | |
|
|
|
Associated certifications and exam
The AWS Certified Data Engineer – Associate (DEA-C01) exam validates a candidate’s ability to implement data pipelines and to monitor, troubleshoot, and optimize cost and performance issues in accordance with best practices.
Amazon Web Services Overview
Amazon Web Services (AWS) are leaders in cloud computing solutions and provide IT infrastructure in the form of online web services.
Torque IT is the first and only Authorized AWS Training Partner in Africa.
Our authorized AWS training solutions, and associated certifications, develop and validate the technical knowledge and skills that are relevant to individuals and organizations that are considering, implementing and maintaining cloud-based solutions.
Our hands-on AWS training courses are for anyone who wants to gain a deeper level of understanding with regard to cloud computing solutions and AWS. AWS Certifications designate individuals who demonstrate knowledge, skills and proficiency with AWS services. AWS Certification exams validate the technical knowledge and skills necessary for building and maintaining applications and services on the AWS Cloud.
Regardless of your level of experience with cloud computing, and AWS, we have a course for you.