Save 20% off your training this summer, book before 5pm July 5th - See details here

Duration:
Only 2 days
Study Mode:
Classroom / Online / Classroom or Online
Next Date:
12/08/2024 (Monday)

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

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.

Prerequisites

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

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.

Benefits

Seven reasons why you should sit your course with Firebrand Training

  1. Two options of training. Choose between residential classroom-based, or online courses
  2. You'll be certified fast. With us, you’ll be trained in record time
  3. Our course is all-inclusive. A one-off fee covers all course materials, exams**, accommodation* and meals*. No hidden extras.
  4. Pass the first time or train again for free. This is our guarantee. We’re confident you’ll pass your course the first time. But if not, come back within a year and only pay for accommodation, exams and incidental costs
  5. You’ll learn more. A day with a traditional training provider generally runs from 9 am – 5 pm, with a nice long break for lunch. With Firebrand Training you’ll get at least 12 hours/day of quality learning time, with your instructor
  6. You’ll learn faster. Chances are, you’ll have a different learning style to those around you. We combine visual, auditory and tactile styles to deliver the material in a way that ensures you will learn faster and more easily
  7. You’ll be studying with the best. We’ve been named in the Training Industry’s “Top 20 IT Training Companies of the Year” every year since 2010. As well as winning many more awards, we’ve trained and certified over 135,000 professionals
  • For residential training only. Doesn't apply for online courses
    ** Some exceptions apply. Please refer to the Exam Track or speak with our experts

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

Course Dates


Start
Finish
Status
Study Mode
Prices
12/08/2024 (Mon)
13/08/2024 (Tue)
Open
Classroom
11/11/2024 (Mon)
12/11/2024 (Tue)
Open
Classroom
11/02/2025 (Tue)
12/02/2025 (Wed)
Open
Classroom
12/05/2025 (Mon)
13/05/2025 (Tue)
Open
Classroom