Trending Courses

Vendors

Skip Navigation Links

Overview

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.
img-course-overview.jpg

What You'll Learn

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

Who Should Attend

This course is intended for data warehouse engineers, data platform engineers, and architects and operators who build and manage data analytics pipelines.
img-who-should-learn.png

Prerequisites

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

Learning Journey

Coming Soon...

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

Instructors

Scott Duffy

Bestselling Azure & TOGAF® Trainer, Microsoft Azure MVP

4.8 (4.1k)
|
10 Courses
profile-instructor-a.png
Scott Duffy

Bestselling Azure & TOGAF® Trainer, Microsoft Azure MVP

4.8 (4.1k)
|
10 Courses
profile-instructor-a.png

Frequently Asked Questions (FAQs)

  • Why get AWS certified?

    AWS certifications validate your expertise in cloud computing and your proficiency in using AWS services.

    These certifications are globally recognized and highly sought after by employers, as they demonstrate your ability to design, deploy, and manage scalable and secure cloud solutions on the AWS platform.

    AWS-certified professionals are in high demand, opening doors to new career opportunities and higher earning potential.

  • What to expect for the examination?

    AWS offers a variety of certification exams at different levels (Foundational, Associate, Professional, and Specialty) covering various domains and services.

    The exams typically consist of multiple-choice and multiple-response questions, and some may include scenario-based questions that assess your ability to apply your knowledge in real-world situations.

    Note: Certification requirements and policies may be updated by AWS from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.

  • How long is AWS certification valid for?

    AWS certifications are valid for three years from the date of passing the exam.

    To maintain your certification, you will need to recertify by passing the latest version of the exam or completing the AWS Cloud Quest game-based training (if option is applicable).

    Note: Certification requirements and policies may be updated by AWS from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.

  • Why take this course with Trainocate?

    Here’s what sets us apart:

    - Global Reach, Localized Accessibility: Benefit from our geographically diverse training hubs in 16 countries (and counting!).

    - Top-Rated Instructors: Our team of subject matter experts (with high average CSAT and MTM scores) are passionate to help you accelerate your digital transformation.

    - Customized Training Solutions: Choose from on-site, virtual classrooms, or self-paced learning to fit your organization and individual needs.

    - Experiential Learning: Dive into interactive training with our curated lesson plans. Participate in hands-on labs, solve real-world challenges, and take on comprehensive assessments.

    - Learn From The Best: With 30+ authorized training partnerships and countless awards from Microsoft, AWS, Google – you're guaranteed learning from the industry's elite.

    - Your Bridge To Success: We provide up-to-date course materials, helpful exam guides, and dedicated support to validate your expertise and elevate your career.

Keep Exploring

Course Curriculum

Training Schedule

Exam & Certification

Frequently Asked Questions

img-improve-career.jpg

Improve yourself and your career by taking this course.

More Courses By AWS

Browse All Courses
aws-mga-migrating-to-aws-training
Migration and Transfer

Migrating to AWS

This course is for individuals who seek an understanding of how to plan and migrate existing workloads to the AWS Cloud.
ILT VILT
Course Duration 3 Days
aws-devops-devops-engineering-on-aws-training
AWS Role - Based

DevOps Engineering on AWS

Learn how to use the most common DevOps patterns to develop, deploy and maintain applications on AWS.
ILT VILT
Course Duration 3 Days
aws-arc-architecting-on-aws-training
AWS Role - Based

Architecting on AWS

From this course, you will learn how to optimize the AWS Cloud by understanding how AWS services fit into cloud-based solutions.
ILT VILT
Course Duration 3 Days
img-get-info.jpg

Ready to Take Your Business from Great to Awesome?

Level-up by partnering with Trainocate. Get in touch today.

Name
Email
Phone
I'm inquiring for
Inquiry Details

By providing your contact details, you agree to our Privacy Policy.

Stay Connected. Be the first to Know.

Company

Vendors

Services

Customer Service

© Copyright Trainocate 2024. All rights reserved.