Loading...

AWS-DBDWOA – Data Warehousing on AWS

Home / AWS-DBDWOA – Data Warehousing on AWS

Data Warehousing on AWS introduces students 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 other 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 data.

Course Outline:

Course Outline

This course covers the following concepts:

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

  • Choosing a Data Warehousing Approach
  • Identifying Data Sources and Requirements
  • Architecting the Data Warehouse
  • Loading Data into the Data Warehouse

Day 3

  • Optimizing Queries and Tuning Performance
  • Monitoring and Auditing the Data Warehouse
  • Maintaining the Data Warehouse
  • Analyzing and Visualizing Data

Course Audience:

Audience:

This course is intended for:

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

Prerequisites:

We recommend that students taking this course have the following prerequisites:

Course Offerings:

Instructor Led Online

Students receive the same quality as an in-class course, with a live instructor and the ability to participate in hands-on labs through real-life examples

ILOs help cut costs by reducing time and travel as they can be taken from home or the office and require only the use of a computer, high-speed wired internet and a headset.

  • Course Outline
  • Course Audience
  • Course Offerings
  • Related Courses

Course Outline

This course covers the following concepts:

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

  • Choosing a Data Warehousing Approach
  • Identifying Data Sources and Requirements
  • Architecting the Data Warehouse
  • Loading Data into the Data Warehouse

Day 3

  • Optimizing Queries and Tuning Performance
  • Monitoring and Auditing the Data Warehouse
  • Maintaining the Data Warehouse
  • Analyzing and Visualizing Data

Audience:

This course is intended for:

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

Prerequisites:

We recommend that students taking this course have the following prerequisites:

Instructor Led Online

Students receive the same quality as an in-class course, with a live instructor and the ability to participate in hands-on labs through real-life examples

ILOs help cut costs by reducing time and travel as they can be taken from home or the office and require only the use of a computer, high-speed wired internet and a headset.

AWS-TECESS – AWS Technical Essentials

AWS Technical Essentials introduces students to AWS products, services, and common solutions. It provides students with fundamentals to become more proficient in identifying AWS services so that they can make informed decisions about IT solutions based on their business requirements and get started working on AWS.   The students will learn how to:
  • Recognize terminology and concepts as they relate to the AWS platform and navigate the AWS Management Console.
  • Understand the foundational services, including Amazon Elastic Compute Cloud (EC2), Amazon Virtual Private Cloud (VPC), Amazon Simple Storage Service (S3), and Amazon Elastic Block Store (EBS).
  • Understand the security measures AWS provides and key concepts of AWS Identity and Access Management (IAM).
  • Understand AWS database services, including Amazon DynamoDB and Amazon Relational Database Service (RDS).
  • Understand AWS management tools, including Auto Scaling, Amazon CloudWatch, Elastic Load Balancing (ELB), and AWS Trusted Advisor.