Course Code: 19041

Amazon Data Warehouse AWS

Class Dates:
4/11/2023
5/23/2023
Length:
3 Days
Cost:
$2025.00
Class Time:
Technology:
Database
Delivery:
Instructor-Led Training, Virtual Instructor-Led Training

Overview

  • Course Overview
  • In this Amazon Web Services Training Course, you will learn new concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. You will learn how to collect, store, and prepare data for the data warehouse by using other AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis Firehose, and Amazon S3. Additionally, this Amazon Web Services Training Course demonstrates how to use business intelligence tools to perform analysis on your data.

  • Audience
  • Database architects
    Database administrators
    Database developers
    Data analysts and scientists

Prerequisites

Course Disclaimer

Course to run is subject to a minimum enrollment. Course may run as a remote virtual instructor led class if the minimum enrollment is not met. For more information, please contact 207-775-0244 or email: learn@vtec.org.

Remote Classroom Training Our Remote Classroom Training is a live class with students observing the instructor and listening through your computer speakers. You will see the instructor's computer, slides, notes, etc., just like in the classroom. You will be following along, doing work, labs, and individual assignments.

Course Details

  • Day 1
  • Course Introduction
  • Introduction to Data Warehousing
  • Introduction to Amazon Redshift
  • Understanding Amazon Redshift Components and Resources
  • Launching an Amazon Redshift Cluster
  • Day 2
  • Reviewing Data Warehousing Approaches
  • Identifying Data Sources and Requirements
  • Designing the Data Warehouse
  • Loading Data into the Data Warehouse
  • Day 3
  • Writing Queries and Tuning Performance
  • Maintaining the Data Warehouse
  • Analyzing and Visualizing Data
  • Course Summary