Data Warehousing on AWS

Category	ID	Duration	Level	Price
Amazon Web Services	13583	3 Day(s)	Intermediate	$1,995.00

Class Schedule

Course Overview

In this 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 course demonstrates how to use business intelligence tools to perform analysis on your data.

Course Objectives

· Core concepts of data warehousing
· Evaluate the relationship between Amazon Redshift and other big data systems
· Evaluate use cases for data warehousing workloads and review case studies that demonstrate implementation of AWS data and analytic services as part of a data warehousing solution
· Choose an appropriate Amazon Redshift node type and size for your data needs
· Discuss security features as they pertain to Amazon Redshift, such as encryption, IAM permissions, and database permissions
· Launch an Amazon Redshift cluster and use the components, features, and functionality to implement a data warehouse in the cloud
· Use other AWS data and analytic services, such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis Firehose, and Amazon S3, to contribute to the data warehousing solution
· Approaches and methodologies for designing data warehouses
· Data sources and assess requirements that affect the data warehouse design
· Design the data warehouse to make effective use of compression, data distribution, and sort methods
· Load and unload data and perform data maintenance tasks
· Write queries and evaluate query plans to optimize query performance
· Configure the database to allocate resources such as memory to query queues and define criteria to route certain types of queries to your configured query queues for improved processing
· Use features and services, such as Amazon Redshift database audit logging, Amazon CloudTrail, Amazon CloudWatch, and Amazon Simple Notification Service (Amazon SNS), to audit, monitor, and receive event notifications about activities in the data warehouse
· Prepare for operational tasks, such as resizing Amazon Redshift clusters and using snapshots to back up and restore clusters
· Use a business intelligence (BI) application to perform data analysis and visualization tasks against your data

AWS Certified Big Data - Specialty

Architecting on AWS

Advanced Architecting on AWS

Security Engineering on AWS

System Operations on AWS: Part One

Training Delivery Methods

With Productivity Point, you will have a spectrum of delivery methods to choose from... when where and how you like it. Whether it's in a classroom or online, we have a delivery option to meets your needs.

Classroom Live Training

Get in-person, hands-on instruction with live lab exercises taught by subject matter experts who deliver authorized and industry-leading content.

With classrooms in almost every major U.S. city, Productivity Point has something for users of every level, so you can earn the most popular industry certifications. You get hands-on learning experience with live lab exercises taught by experienced instructors. We proudly advocate our learning services to be hosted by the best-qualified trainers in terms of technical knowledge and teaching skills.

Classroom Virtual Training

Prefer to have a dedicated classroom for your virtual experience? Attend live, hands- on training via remote instructor from one of Productivity Point’s multiple locations.

Enjoy a focused and professional training environment, including all technical equipment provided along with administrative and technical support at your fingertips. With over 150 locations to choose from, review our course catalog or contact your personal Productivity Point Account Manager to see if the course you have in mind is delivered at one of our dedicated virtual classrooms in your area.

Live Online Training

Blend the best from traditional face-to-face instructor-led training with the latest in conferencing technology.

Delivering live training to multiple locations at one time
100% live, instructor led training in a classroom setting without excess travel.
Dramatically reduced class cancellation rate.

Private Group Training

Your private group classroom experience will not only take place in the location of your choice (including any of our training centers), but you will enjoy the following amenities:

Instructor Consult to get to know your instructor and convey your customized requirements
Course Curriculum tailored to your specifications and displaying your organization's branding
On-Line course evaluations provided for your review
Post-Assessments to ensure your learners have fully comprehended

On-Demand Learning

On-Demand is an IT training solution designed around your schedule, budget, and learning needs. Combining high-quality video, reading, and knowledge checks in a self-paced format, On-Demand helps you build skills as your schedule allows—all at once or five minutes at a time.

With On-Demand, you learn at your own pace and in the convenience of your own space.

With Learn at your own pace…

Personal industry leading trainers and instructors right on your own desktop.
Acquire leverage to better career opportunities.
Learn the latest information technology.
Increase your earning potential
Get Certified

Try Before You Buy…
If you would like to experience On-Demand before you purchase, send an email to: ondemand@productivitypointls.com to receive your Course Demo Code.

Class Schedule