Data Warehousing on AWS

Length 3 days

Course overview

View dates &
book now

Why study this course

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.

This course is delivered through a mix of instructor-led training (ILT) and hands-on labs.

Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.

What you’ll learn

In this course, participants will learn how to:

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, optimise queries, and tune the database for better performance
Use Amazon Redshift Spectrum to analyse data directly from an Amazon S3 bucket
Use Amazon QuickSight to perform data analysis and visualisation tasks against the data warehouse

AWS at DDLS

DDLS is an official AWS Training Partner for the Australian and Philippines region. Through our Authorised AWS Instructors, we can provide you with a learning path that’s relevant to you and your organisation, so you can get more out of the cloud. We offer virtual and face-to-face classroom-based training to help you build your cloud skills and enable you to achieve industry-recognised AWS Certification.

View all AWS courses

Stay ahead of the technology curve

Don’t let your tech outpace the skills of your people

Get in touch today

Quality instructors and content

Expert instructors with real world experience and the latest vendor- approved in-depth course content.

Partner-Preferred Supplier

Chosen and awarded by the world’s leading vendors as preferred training partner.

Ahead of the technology curve

No matter your chosen technologies or platforms, we can help you stay one step ahead.

Who is the course for?

This course is intended for:

Database architects
Database administrators
Database developers
Data analysts and scientists

We can also deliver and customise this training course for larger groups – saving your organisation time, money and resources. For more information, please contact us via email on ph.training@ddls.com.ph

.

Course subjects

Module 1: Introduction to Data Warehousing

Relational databases
Data warehousing concepts
The intersection of data warehousing and big data
Overview of data management in AWS
Hands-on lab 1: Introduction to Amazon Redshift

Module 2: Introduction to Amazon Redshift

Conceptual overview
Real-world use cases
Hands-on lab 2: Launching an Amazon Redshift cluster

Module 3: Launching clusters

Building the cluster
Connecting to the cluster
Controlling access
Database security
Load data
Hands-on lab 3: Optimising database schemas

Module 4: Designing the database schema

Schemas and data types
Columnar compression
Data distribution styles
Data sorting methods

Module 5: Identifying data sources

Data sources overview
Amazon S3
Amazon DynamoDB
Amazon EMR
Amazon Kinesis Data Firehose
AWS Lambda Database Loader for Amazon Redshift
Hands-on lab 4: Loading real-time data into an Amazon Redshift database

Module 6: Loading data

Preparing data
Loading data using COPY
Maintaining tables
Concurrent write operations
Troubleshooting load issues
Hands-on lab 5: Loading data with the COPY command

Module 7: Writing queries and tuning for performance

Amazon Redshift SQL
User-Defined Functions (UDFs)
Factors that affect query performance
The EXPLAIN command and query plans
Workload Management (WLM)
Hands-on lab 6: Configuring workload management

Module 8: Amazon Redshift Spectrum

Amazon Redshift Spectrum
Configuring data for Amazon Redshift Spectrum
Amazon Redshift Spectrum Queries
Hands-on lab 7: Using Amazon Redshift Spectrum

Module 9: Maintaining clusters

Audit logging
Performance monitoring
Events and notifications
Lab 8: Auditing and monitoring clusters
Resizing clusters
Backing up and restoring clusters
Resource tagging and limits and constraints
Hands-on lab 9: Backing up, restoring and resizing clusters

Module 10: Analysing and visualising data

Power of visualisations
Building dashboards
Amazon QuickSight editions and features

Please Note: This is an emerging technology course. Course outline is subject to change as needed.

Prerequisites

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

AWS Technical Essentials course or equivalent experience
Familiarity with relational databases and database design concepts

Terms & Conditions

The supply of this course by DDLS is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.

Looking for more course options?

View all AWS courses View all Data, Analytics and AI courses View all Cloud Computing and Virtualisation courses