Professional Training · Data & Analytics Track
Building Data Analytics Solutions Using Amazon Redshift
A one-day course on building analytics solutions around Amazon Redshift. It covers how data warehouses, data lakes and modern data architectures compare, then works through designing and implementing a warehouse analytics solution: ingestion, transformation and storage options, node and cluster sizing, auto scaling, storage optimisation, securing data, monitoring workloads and applying cost management practices.
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 building the pipelines that feed the warehouse.
- Data Analysts: Analysts querying and reporting on warehoused data.
- Data Architects: Architects designing analytics platforms on AWS.
- Technical Professionals: Staff supporting analytics workloads in production.
Prerequisites
This is an intermediate course. To get the most from it, you should have:
At least one year of experience managing data warehouses.
Completion of AWS Technical Essentials or Architecting on AWS, or equivalent AWS knowledge.
Completion of Building Data Lakes on AWS, or equivalent experience of data lake design.
Learning Objectives
In this course, you will learn to:
Compare data architectures: Weigh up data warehouses, data lakes and modern data architectures.
Design a warehouse solution: Build and implement analytics on Amazon Redshift.
Optimise storage: Apply compression and related techniques to storage design.
Size the cluster: Choose instance and node types, clusters, auto scaling and network topology.
Secure the warehouse: Protect data at rest and in transit.
Monitor and control cost: Identify and remediate problems and apply cost management practices.
Certification
A MY Code Campus certificate of completion is awarded for Building Data Analytics Solutions Using Amazon Redshift.
In-person in Kuala Lumpur or live virtual. Team & enterprise rates available.
