Building Data Analytics Solutions Using Amazon Redshift
You will create a data analytics solution in this course utilizing the cloud data warehouse provider Amazon Redshift. The course focuses on the parts of the analytics pipeline that deal with data collection, ingestion, cataloging, storage, and processing.
- Group Discussions
- Live Demonstrations
- Presentations
- Hands-On Labs
- Knowledge Checks
- Data warehouse engineers, data platform engineers, architects, and operators who create and oversee data analytics pipelines are the target audience for this course.
- Completed either AWS Technical Essentials or Architecting on AWS
- Completed Building Data Lakes on AWS
Module A: Overview of Data Analytics and the Data Pipeline
Data analytics use cases
Using the data pipeline for analytics
Module 1: Using Amazon Redshift in the Data Analytics Pipeline
Why Amazon Redshift for data warehousing?
Overview of Amazon Redshift
Module 2: Introduction to Amazon Redshift
Amazon Redshift architecture
Interactive Demo 1: Touring the Amazon Redshift console
Amazon Redshift features
Practice Lab 1: Load and query data in an Amazon Redshift cluster
Module 3: Ingestion and Storage
Ingestion
Interactive Demo 2: Connecting your Amazon Redshift cluster using a Jupyter notebook with Data API
Data distribution and storage
Interactive Demo 3: Analyzing semi-structured data using the SUPER data type
Querying data in Amazon Redshift
Practice Lab 2: Data analytics using Amazon Redshift Spectrum
Module 4: Processing and Optimizing Data
Data transformation
Advanced querying
Practice Lab 3: Data transformation and querying in Amazon Redshift
Resource management
Interactive Demo 4: Applying mixed workload management on Amazon Redshift
Automation and optimization
Interactive demo 5: Amazon Redshift cluster resizing from the dc2.large to ra3.xlplus cluster
Module 5: Security and Monitoring of Amazon Redshift Clusters
Securing the Amazon Redshift cluster
Monitoring and troubleshooting Amazon Redshift clusters
Module 6: Designing Data Warehouse Analytics Solutions
Data warehouse use case review
Activity: Designing a data warehouse analytics workflow
Module B: Developing Modern Data Architectures on AWS
Modern data architectures
Why choose Cloud Wizard
- Advanced Tier Training Partner
- Amazon Authorised Instructors
- Official AWS Content
- Hands-on Labs
Class Deliverables
- E-Content kit by AWS
- Hands-on labs
- Class completion certificates
- Exam Prep sessions
Dates Available
Choose a date that works for you and click on Book Now to proceed with your registration.
Don't see a date that works for you?
Fill in the form below to let us know.
Related courses
Related products
-
AWS Training
MLOps Engineering on AWS
This course builds on and extends the DevOps methodology used in software development to build, train and deploy machine learning (ML) models. In this three days course you will learn about the four-level MLOps maturity framework. It outlines the importance of data, model and code to successful ML deployments. The course also discusses the use of tools and processes to monitor and take action when the model prediction shifts from the key performance indicators.
The course is intended for MLOps engineers who want to produce and monitor ML models in the AWS Cloud. It is also for DevOps engineers who are responsible for deploying and maintaining ML models. We recommend you to have completed AWS Technical Essentials, DevOps Engineering on AWS and Practical Data Science with Amazon SageMaker
The program is taught with the help of presentations, hands-on labs, demonstrations and group activities. You will be able to prepare for the AWS Certified Machine Learning certification
-
AWS Training
Running Containers on Amazon Elastic Kubernetes Service
This three day course is focused on learning container management and orchestration for Kubernetes using Amazon EKS. You will learn how to build Amazon EKS cluster, configure the environment, deploy and add applications to the cluster.
-
AWS Training
Planning and Designing Databases on AWS
Both relational and non-relational databases’ planning and design processes will be covered in this Planning and designing Databases on AWS course. You will learn about design factors for databases hosted on Amazon Elastic Compute Cloud (AmazonEC2).
-
AWS Training
Advanced Developing on AWS
This course is focused around analyzing a monolithic application and determining logical break points where the application can be broken down across various AWS services. You will learn advanced development techniques to deconstruct on-premise legacy applications.
