Discover Classes. Earn 10% Rewards.

Data Warehousing on AWS is unfortunately unavailable

Thankfully we have 206 other IT Classes for you to choose from. Check our top choices below or see all classes for more options.

Excel Bootcamp

Noble Desktop See all classes by this school - Virtually Online

Gain comprehensive Excel expertise in this intensive three-day course that moves from foundational calculations through to advanced automation with macros. Whether you're building on basic knowledge or aiming for expert-level proficiency, this well-paced program covers the full range of tools and techniques that make Excel an indispensable asset in any professional setting.

(452) Beginner 18 and older
$599

3 sessions

Gift it!

Excel Level I: Fundamentals

Noble Desktop See all classes by this school - Virtually Online

Build a confident foundation in Microsoft Excel through this practical workshop at Noble Desktop. You'll work with calculations, functions, charts, formatting, and print layouts to manage data and produce well-structured spreadsheets.

(452) Beginner 18 and older

Excel Expert Certification Program

Noble Desktop See all classes by this school - Virtually Online

Reach advanced Excel proficiency in this complete program. Through group sessions, private instruction, and a certification exam with one free retake, you'll cover formulas, functions, PivotTables, charts, and career-boosting tools.

(452) All levels 18 and older
$1,149

3 sessions

Gift it!

Excel Level II: Intermediate

Noble Desktop See all classes by this school - Virtually Online

Push your Excel skills past the basics with this intermediate course covering VLOOKUP, PivotTables, and more. At Noble Desktop, you'll build the working ability to manipulate and analyze data effectively for real reporting and analysis tasks.

(452) Intermediate 18 and older
$299

2 sessions

Gift it!

Excel Specialist Certification Program

Noble Desktop See all classes by this school - Virtually Online

Become an expert in Microsoft Excel and strengthen your resume through this comprehensive certification program. Get lifetime access to video courses, private training, and free proctored exams. Grow your skills and stand out in the competitive job market.

(452) All levels 18 and older
$959

3 sessions

Gift it!
See all IT classes Online

Data Warehousing on AWS

  • Intermediate
  • 16 and older
  • Earn 10% Rewards
  • Price Lock

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • Live Online Training
  • 24 hours over 3 sessions

Start Dates (0) $1,495/person

No upcoming dates are currently available.

Book a Private Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

Class Description

Description

Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3. Additionally, this course demonstrates how to use Amazon QuickSight to perform analysis on your data.

Course Objectives

  • Discuss the core concepts of data warehousing, and the intersection between data warehousing and big data solutions
  • 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, and Amazon S3, to contribute to the data warehousing solution
  • Architect the data warehouse
  • Identify performance issues, optimize queries, and tune the database for better performance
  • Use Amazon Redshift Spectrum to analyze data directly from an Amazon S3 bucket
  • Use Amazon QuickSight to perform data analysis and visualization tasks against the data warehouse

Course Outline

Introduction to Data Warehousing

  • Relational databases
  • Data warehousing concepts
  • The intersection of data warehousing and big data
  • Overview of data management in AWS

Introduction to Amazon Redshift

  • Conceptual overview
  • Real-world use cases

Launching clusters

  • Building the cluster
  • Connecting to the cluster
  • Controlling access
  • Database security
  • Load data

Who Should Attend

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

Prerequisites

Required

  • Familiarity with relational databases and database design concepts

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Refund Policy

A student who cancels within 7 days of signing the enrollment agreement but before instruction begins receives all monies returned with the exception of the non-refundable registration fee.

Thereafter, a student will be liable for:

  • The non-refundable registration fee of $100 plus
  • The cost of any textbooks or supplies accepted plus
  • Tuition liability as of the student's last date of physical attendance
If Termination Occurs

  • Prior to or during the first week - 0% Penalty
  • During the second week - 25% Penalty
  • During the third week - 50% Penalty
  • During the fourth week - 75% Penalty
  • After the fourth week - 100% Penalty

The failure of a student to notify CourseHorse in writing of withdrawal may delay a refund of tuition.

Reviews of Classes at NetCom Learning (16)

Similar Classes

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 14950 points. Earn 10% back in reward points!

NetCom Learning

NetCom Learning is a leading provider of training and certification solutions for businesses, individuals, and government agencies. With over 20 years of experience, NetCom has worked with Fortune 500 companies, serviced thousands of business customers, and advanced the careers of over 50,000 professionals through expert-led training.

View school profile
NetCom Learning
Vetted by CourseHorse

A verified Online educator.

Loading...