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.
