Professional Training · Data & Analytics Track
Data Warehousing on AWS
A three-day course on data warehousing with Amazon Redshift, covering its architecture and place in a modern data architecture. It works through designing and implementing a warehouse, loading data from varied sources, analysing it with SQL notebooks, planning disaster recovery, performance tuning and maintenance, securing and managing access, sharing data across clusters, orchestrating workflows with AWS Step Functions and building models with Amazon Redshift ML.
Authorised Instructor
Hui Liang
Chief Digital Officer
- Data Engineer – Associate
- Security – Specialty
- Generative AI Developer – Professional
- Solutions Architect – Professional
- +5 more
This class is delivered by our AWS Authorised Instructor for this specialisation. Trainers confirmed on enrolment.
Who Should Attend
- Data Engineers: Engineers loading and transforming warehouse data.
- Data Architects: Architects designing the warehouse and its integrations.
- Database Architects: Specialists shaping schema and cluster design.
- Database Administrators: Administrators maintaining and tuning the warehouse.
- Database Developers: Developers building queries and applications against it.
Prerequisites
This is an intermediate course. To get the most from it, you should have:
Completion of Fundamentals of Analytics on AWS parts 1 and 2, or equivalent analytics knowledge.
Completion of Building Data Lakes on AWS, or equivalent experience of data lake design.
Completion of Building Data Analytics Solutions Using Amazon Redshift, or equivalent Redshift experience.
Learning Objectives
In this course, you will learn to:
Understand the architecture: Describe Amazon Redshift and its role in a modern data architecture.
Build the warehouse: Design and implement a cloud data warehouse on Amazon Redshift.
Load and analyse data: Ingest from varied sources and analyse using SQL notebooks.
Keep it running: Plan disaster recovery and perform maintenance and performance tuning.
Secure and share: Manage access controls and share data between Redshift clusters.
Extend the platform: Orchestrate workflows with AWS Step Functions and build models with Amazon Redshift ML.
Certification
A MY Code Campus certificate of completion is awarded for Data Warehousing on AWS.
In-person in Kuala Lumpur or live virtual. Team & enterprise rates available.
Keep Exploring
More AWS Training & Certification
- Data Engineer – Associate
Data Engineering on AWS
Build and operate reliable, cost-effective data pipelines and analytics on AWS.
Intermediate3 DaysView course Build Modern Applications with AWS NoSQL Databases
Build cloud applications on AWS purpose-built NoSQL databases for demanding access patterns.
Intermediate1 DayView courseBuilding Batch Data Analytics Solutions on AWS
Design and run batch analytics on Amazon EMR with an eye on both cost and performance.
Intermediate1 DayView course
