Building Data Analytics Solutions Using Amazon Redshift
In this course, you will build a data analytics solution using Amazon Redshift, a cloud data warehouse service. The course focuses on the data collection, ingestion, cataloging, storage, and processing components of the analytics pipeline. You will learn to integrate Amazon Redshift with a data lake to support both analytics and machine learning workloads.
You will also learn to apply security, performance, and cost management best practices to the operation of Amazon Redshift.
You will also learn to apply security, performance, and cost management best practices to the operation of Amazon Redshift.
In this course, you will learn to:
- Compare the features and benefits of data warehouses, data lakes, and modern data architectures
- Design and implement a data warehouse analytics solution
- Identify and apply appropriate techniques, including compression, to optimize data storage
- Select and deploy appropriate options to ingest, transform, and store data
- Choose the appropriate instance and node types, clusters, auto scaling, and network topology for a particular business use case
- Understand how data storage and processing affect the analysis and visualization mechanisms needed to gain actionable business insights
- Secure data at rest and in transit
- Monitor analytics workloads to identify and remediate problems
- Apply cost management best practices
- This course is intended for data warehouse engineers, data platform engineers, and architects and operators who build and manage data analytics pipelines.
Students with a minimum one-year experience managing data warehouses will benefit from this course. We recommend that attendees of this course have:
- 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.
| Method | Duration | Start Time | Start date | Price | Action |
|---|---|---|---|---|---|
| Classroom | 1 days | All Day | May 6, 2024 | ₹15,000 | |
| Classroom | 1 days | All Day | May 20, 2024 | ₹15,000 | |
| Classroom | 1 days | All Day | June 3, 2024 | ₹15,000 | |
| Classroom | 1 days | All Day | June 17, 2024 | ₹15,000 |
Don't see a date that works for you?
Fill in the form below to let us know.
Related courses
Related products
-
AWS Training
Planning and Designing Databases on AWS
In this course, you will learn about planning and designing your solutions with purpose-built Amazon Web Services (AWS) Cloud databases. The course introduces you to the features and characteristics of each of these databases and shares the design considerations that you should make while using them. By taking this course, you can develop the analytical skills needed to choose the right AWS database for your unique needs.
By the end of the course, you will be able to analyze a business use case, analyze the workload, and assess application requirements to identify and design the most suitable AWS database solution to support your organizational needs
-
AWS Training
Practical Data Science with Amazon SageMaker
Artificial Intelligence and Machine learning are increasingly dominating the business landscape. This makes it important to learn how to collaborate with data scientists to develop ML-integrated applications. As part of this course, you will learn how data scientists develop solutions on the AWS Cloud with Amazon SageMaker. You will also understand how to develop, train and deploy ML models.
This course is intended for DevOps Engineers and Application developers eager to develop applications that work well with Machine Learning. Entry-level knowledge of Python programming and basic knowledge of statistics will help. The class is delivered with presentations, hands-on labs and demonstrations by an Amazon Authorized Instructor.
-
AWS Training
AWS Cloud for Finance Professionals
This course is aimed at enterprise level financial stakeholders who need to learn to manage, optimize and plan the organization’s cloud spend. You will learn to be more accountable and price conscious from an expert AWS Instructor. The course runs for two days and is focused on learning to innovate within your financial organization
As part of the course, you’ll learn to define cloud business models, estimate costs associated with your AWS account with the existing and future workloads. Tools used for reporting, monitoring, allocating, optimizing and planning AWS spending through pricing models on AWS Cloud shall also be covered.
If you are a Financial Stakeholder in an organization who wants to learn how to maximize cloud business value and use CFM best practices and to help the finance teams to innovate with AWS, this course is ideal for you. It is delivered by an Amazon Authorized Instructor with a mix of presentation, theory and knowledge checks.
-
AWS Training
Architecting on AWS
This course helps you identify services and features needed to build secure and highly available IT solutions in AWS Cloud. You will learn the basic practices of AWS Architecture and designing optimal IT solutions using the AWS Well-Architected framework.
Additionally, you will explore AWS Services related to account security, networking, storage, databases, automation, containers, serverless architecture, backup and recovery.
This course is ideally meant for Solution Architects, Solution-Design engineers and developers who seek to understand AWS Architecture principles. You will also be able to prepare for the AWS Certified Solutions Architect – Associate exam after the completion of this three day course. The course is delivered by an Amazon Authorized Instructor with theory, real-life scenarios and hands-on labs
