AWS Data Warehousing | 2-day course

Overview

On this accelerated AWS: Data Warehousing course, you’ll gain an understanding of how to warehouse data on the most used cloud storage in the world. Mastering this skill will be a valuable asset when working with other AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis Firehose, and Amazon Simple Storage Service (Amazon S3).

In just 2 days, you’ll learn how to design cloud-based data warehousing solutions. You’ll also learn:

Concepts, strategies, and best practices for designing cloud-based data warehousing solutions
How to use the petabyte-scale data warehouse in AWS
How to use business intelligence tools to perform analysis on your data

At the end of this course, you’ll sit the AWS exam, and achieve your AWS: Data Warehousing certification. Through Firebrand’s Lecture | Lab | Review methodology, you’ll get certified at twice the speed of the traditional training and get access to courseware, learn from certified instructors, and train in a distraction-free environment.

Audience

This course is ideal for:

Data architects
Database administrators
Database developers
Data analysts
Data scientists

See prices now to find out how much you could save when you train at twice the speed.

See prices

Benefits

Other accelerated training providers rely heavily on lecture and independent self-testing and study.

Effective technical instruction must be highly varied and interactive to keep attention levels high, promote camaraderie and teamwork between the students and instructor, and solidify knowledge through hands-on learning.

Firebrand Training provides instruction to meet every learning need:

Intensive group instruction
One-on-one instruction attention
Hands-on labs
Lab partner and group exercises
Question and answer drills
Independent study

Think you are ready for the course? Take a FREE practice test to assess your knowledge!

Free Practice Test

Curriculum

Module 1: Introduction to Data Warehousing
Module 2: Introduction to
Module 3: Launching clusters Amazon Redshift
Module 4: Designing the database schema
Module 5: Identifying data sources
Module 6: Loading data
Module 7: Writing queries and tuning for performance
Module 8: Amazon Redshift Spectrum
Module 9: Maintaining clusters
Module 10: Analyzing and visualizing data

Exam Track

There is no exam for this course.

What's Included

Your accelerated course includes:

Accommodation *
Meals, unlimited snacks, beverages, tea and coffee *
On-site exams **
Exam vouchers **
Practice tests **
Certification Guarantee ***
Courseware
Up-to 12 hours of instructor-led training each day
24-hour lab access
Digital courseware **

* For residential training only. Accommodation is included from the night before the course starts. This doesn't apply for online courses.
** Some exceptions apply. Please refer to the Exam Track or speak with our experts
*** Pass first time or train again free as many times as it takes, unlimited for 1 year. Just pay for accommodation, exams, and incidental costs.

Prerequisites

Before attending this accelerated course, you will have familiarity with relational databases and database design concepts.

Unsure whether you meet the prerequisites? Don’t worry. Your training consultant will discuss your background with you to understand if this course is right for you.

Reviews

Here's the Firebrand Training review section. Since 2001 we've trained exactly 134561 students and asked them all to review our Accelerated Learning. Currently, 96.41% have said Firebrand exceeded their expectations.

Read reviews from recent accelerated courses below or visit Firebrand Stories for written and video interviews from our alumni.

"Highly recommended!"
Yuchen Wang, Engineer. (8/5/2023 (Monday) to 11/5/2023 (Thursday))

"Great instructor, very disciplined, good knowledge and very patiently explained. Its like a boot camp and a very structured approach is taken to make you ready for exam and also increase your knowledge. Any one can join if you meet the prerequisites."
Mahesh Kukrani. (8/5/2023 (Monday) to 11/5/2023 (Thursday))

"Very skilled teacher and helpful discussions."
Anonymous (8/5/2023 (Monday) to 11/5/2023 (Thursday))

"Thanks for this intensive and quite productive training session !"
Alain Dedeurwaerder. (22/5/2018 (Tuesday) to 24/5/2018 (Thursday))

"Very impressed with the dedication from the instructor and how well structured the sessions are. The course is very intense since it's only 3 days long, however, the quality of the training makes it worthwhile. I'd recommend going in person since you will find it much easier to focus and likely get more out of the course overall."
Simon Brown, Softcat. (8/9/2023 (Friday) to 10/9/2023 (Sunday))

Course Dates

Start	Finish	Status	Location
19/2/2024 (Monday)	20/2/2024 (Tuesday)	Finished - Leave feedback	-
24/6/2024 (Monday)	25/6/2024 (Tuesday)	Wait list	Nationwide
5/8/2024 (Monday)	6/8/2024 (Tuesday)	Limited availability	Nationwide
16/9/2024 (Monday)	17/9/2024 (Tuesday)	Open	Nationwide
28/10/2024 (Monday)	29/10/2024 (Tuesday)	Open	Nationwide
9/12/2024 (Monday)	10/12/2024 (Tuesday)	Open	Nationwide

FastPass: unlimited Microsoft training for €6,750

Amazon Web Services (AWS) - Data Warehousing