GBP

EN_GB

Shaping the future of IT skills

Maximising IT performance through learning

Data Warehousing on AWS - DWAWS

WGAC-AWS-DWAWS

Schedule

See all events for this course

Currently there are no public dates for this course. We can offer you a private group training, or you can pre-register upfront for a future public class. Please contact us.

Description

Show Tabs

Introduction

In this course, you will learn concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. We will demonstrate 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 Simple Storage Service (Amazon S3). We will also explore how to use business intelligence (BI) tools to perform analysis on your data.

Prerequisites & Audience

We recommend that attendees of this course have the following prerequisites:

AWS Technical Essentials (AWSE) or equivalent experience with AWS
Familiarity with relational databases and database design concepts

Course Topics

In this course, you will learn how to:

Evaluate the relationship between Amazon Redshift and other Big Data systems
Evaluate use cases for data warehousing workloads and review real-world 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
Understand which security features are appropriate for 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
Evaluate approaches and methodologies for designing data warehouses
Identify 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
Audit, monitor, and receive event notifications about activities in the data warehouse by using features and services such as Amazon Redshift database audit logging, Amazon CloudTrail, Amazon CloudWatch, and Amazon Simple Notification Service (Amazon SNS)
Prepare for operational tasks such as resizing Amazon Redshift clusters and using snapshots to back up and restore clusters
Use a BI application to perform data analysis and visualization tasks against your data

Amazon Web Services courses

Filter courses

Machine Learning Pipeline on AWS - ML-PIPE

CODE: WGAC-AWS-ML-PIPE

Advanced Developing on AWS - ADV-DEV

CODE: WGAC-AWS-ADV-DEV

AWS Cloud Ready Hackathon: Coding and Testing on Linux - AWSHCTL

CODE: WGAC-AWS-AWSHCTL

Practical Data Science with Amazon SageMaker - PDSASM

CODE: WGAC-AWS-PDSASM

Architecting on AWS Accelerator - ARCH-AX

CODE: WGAC-AWS-ARCH-AX

Migrating to AWS - AWSM

CODE: WGAC-AWS-AWSM

Advanced Architecting on AWS - AWSAA

CODE: WGAC-AWS-AWSAA

AWS Cloud Essentials for Business Leaders - CEBL

CODE: WGAC-AWS-CEBL

DevOps Engineering on AWS - AWSDEVOPS

CODE: WGAC-AWS-AWSDEVOPS

AWS Cloud Ready Hackathon: Containers, Kubernetes CI & CD - AWSHCKC

CODE: WGAC-AWS-AWSHCKC

Exam Readiness: AWS Certified Data Analytics – Specialty - ACDAS-EX

CODE: WGAC-AWS-ACDAS-EX

Advanced Architecting on AWS - AAAWS

CODE: WGAC-AWS-AAAWS

Exam Readiness: AWS Certified Security - Specialty - ACSS-EX

CODE: WGAC-AWS-ACSS-EX

AWS Cloud Practitioner Essentials - CP-ESS

CODE: WGAC-AWS-CP-ESS

AWS Cloud Essentials for Business Leaders – Financial Services - CEBL-FS

CODE: WGAC-AWS-CEBL-FS

Developing on AWS - AWSD

CODE: WGAC-AWS-AWSD

AWS Cloud Ready Hackathon: Running Cloud Workloads with Kubernetes - AWSHRWK

CODE: WGAC-AWS-AWSHRWK

AWS Discovery Day (3 hours) - AWSDD3H

CODE: WGAC-AWS-AWSDD3H

AWS Well-Architected Best Practices - WABP

CODE: WGAC-AWS-WABP

Exam Readiness Intensive Workshop: AWS Certified Solutions Architect – Associate - ACSAA-EXIW

CODE: WGAC-AWS-ACSAA-EXIW

Building Data Analytics Solutions Using Amazon Redshift - BDASAR

CODE: WGAC-AWS-BDASAR

MLOps Engineering on AWS - MLOE

CODE: WGAC-AWS-MLOE

Data Warehousing on AWS - DWAWS

CODE: WGAC-AWS-DWAWS

Building Data Lakes on AWS - BDLA

CODE: WGAC-AWS-BDLA

Exam Readiness: AWS Certified Solutions Architect – Professional - ACSAP-EX

CODE: WGAC-AWS-ACSAP-EX

Exam Readiness: AWS Certified Database – Specialty - ACDS-EX

CODE: WGAC-AWS-ACDS-EX

Architecting on AWS - AWSA

CODE: WGAC-AWS-AWSA

Big Data on AWS - BDAWS

CODE: WGAC-AWS-BDAWS

Security Engineering on AWS - AWSSO

CODE: WGAC-AWS-AWSSO

AWS Security Governance at Scale - SGS

CODE: WGAC-AWS-SGS

AWS Security Essentials - SEC-ESS

CODE: WGAC-AWS-SEC-ESS

Deep Learning on AWS - AWSDL

CODE: WGAC-CSC-AWSDL

Systems Operations on AWS - AWSSYS

CODE: WGAC-AWS-AWSSYS

Planning and Designing Databases on AWS - PD-DB

CODE: WGAC-AWS-PD-DB

Running Containers on Amazon Elastic Kubernetes Service - RCAEKS

CODE: WGAC-AWS-RCAEKS

Exam Readiness: AWS Certified Developer - Associate - ACDA-EX

CODE: WGAC-AWS-ACDA-EX

Exam Readiness: AWS Certified Advanced Networking - Specialty - ACANS-EX

CODE: WGAC-AWS-ACANS-EX

Exam Readiness: AWS Certified Solutions Architect – Associate - ACSAA-EX

CODE: WGAC-AWS-ACSAA-EX

AWS Discovery Day - AWSDD

CODE: WGAC-AWS-AWSDD

AWS Technical Essentials - AWSE

CODE: WGAC-AWS-AWSE

Exam Readiness: AWS Certified DevOps Engineer – Professional - ACDOEP-EX

CODE: WGAC-AWS-ACDOEP-EX

We use cookies to understand how you use our site and to improve your experience. To learn more, click here. Read our revised Privacy Policy and Terms and Conditions.