fr
en
Building data analytics solutions with Amazon Redshift
Your analyses depend on available, properly organised data. With AWS, connect collection, transformation and delivery to structure data flows. Strengthen your ability to design processing that meets application and business needs.
- Duration
- 1 day 7 hours
- Code
- AWS14FR Code
Presentation
Data analytics on AWS provides a modern approach to collecting, ingesting, cataloguing, storing and processing data. It combines data warehouse, data lake and modern data architecture capabilities to significantly improve organisational speed and efficiency on AWS.
This intensive course provides practical skills to master the creation of data analytics solutions with Amazon Redshift. You will explore essential AWS tools and services, including Amazon Redshift, Amazon Redshift Spectrum and the Data API. Through practical workshops, you will design and implement data warehouse solutions, optimise data storage and processing, and secure data at rest and in transit.
By the end of this one-day program, you will have the expertise to design high-performance, secure analytics solutions on AWS. You will master Amazon Redshift optimisation and best practices to unlock your cloud data's potential.
As an authorised Amazon Web Services premium training partner (ATP), Oo2 offers skills development and certification training that meets the organisation's rigorous quality standards.
Objectives
By the end of this Amazon Redshift course, you will be able to:
- compare data warehouse, data lake and modern data architecture features and benefits;
- design and implement a data warehouse analytics solution;
- identify and apply appropriate techniques, including compression, to optimise data storage;
- select and deploy appropriate data ingestion, transformation and storage options;
- choose instance and node types, clusters, automatic scaling and network topology for a specific use case;
- understand how storage and processing affect the analysis and visualisation mechanisms needed for actionable business insights;
- secure data at rest and in transit;
- monitor analytics workloads to identify and resolve problems;
- apply cost management best practices.
Program
Module 1: understanding data analytics and the data pipeline
- Data analytics use cases.
- Using the data pipeline for analytics.
Module 2: using Amazon Redshift in the analytics pipeline
- Benefits of cloud data warehousing.
- Overview of Amazon Redshift.
Module 3: introducing Amazon Redshift
- Architecture components.
- Using the console.
- Core features.
Lab:
- Load and query data in a cluster.
Module 4: processing and optimising data
- Data transformation.
- Advanced query capabilities.
- Resource management.
- Applying mixed workload management.
- Automation and optimisation.
- Resizing an Amazon Redshift cluster.
Lab:
- Transform and query data.
Module 5: securing and monitoring clusters
- Cluster security.
- Cluster monitoring and troubleshooting.
Module 6: designing data warehouse analytics solutions
- Data warehouse use cases.
Lab:
- Design a data warehouse analytics workflow.
Module 7: developing modern cloud data warehouses on AWS
- Modern data architecture components.
Audience
This course is intended for:
- data warehouse engineers building and managing data analytics pipelines;
- data platform engineers responsible for building and managing analytics pipelines;
- data architects and operators building and managing data analytics pipelines.
Prerequisites
This AWS course requires the following prerequisites:
- at least 1 year of data warehouse management experience;
- completion of AWS Technical Essentials or Architecting on AWS (recommended);
- completion of Building Data Lakes on AWS (recommended) .
Teaching and assessment methods
- Initial skills assessment
- Training materials provided to participants
- Continuous assessment throughout the course
- End-of-course feedback questionnaire
- Combination of theory and practical application
- Attendance records
- Post-course follow-up evaluation
- Practical exercises
Course highlights
- AWS-certified expert trainers: recognised expertise and in-depth knowledge of Amazon Redshift and analytics solution design and implementation best practices.
- Interactive practical learning: master Amazon Redshift through demonstrations and workshops, preparing for real challenges in pipeline development, storage and processing optimisation, and cloud data security.
- Key skills development: carefully designed content builds essential analytics design and implementation skills, Redshift performance optimisation and cost management best practices.
Dates and sessions
Choose the date and delivery format that suit you.
No upcoming sessions are currently available.
AWS and Amazon Redshift are registered trademarks of Amazon.com, Inc. or its affiliates.