Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift. This course demonstrates how to ingest, store, and transform data in the data warehouse. Topics covered include: the purpose of Amazon Redshift, how Amazon Redshift addresses business and technical challenges, features and capabilities of Amazon Redshift, designing a Data Warehousing Solution on AWS by applying best practices based on the Well-Architected Framework, integration with AWS and non-AWS products and services, performance tuning, orchestration, and securing and monitoring Amazon Redshift.
Course level: Advanced
Duration: 3 days
Activities
This course includes presentations, hands-on labs, and demonstrations.
In this course, you will learn to:
Day 1
Module 1: Data Warehouse Concepts
Module 2: Setting up Amazon Redshift
Module 3: Loading Data
Day 2
Module 4: Deep Dive into SQL Query Editor v2 and Notebooks
Module 5: Backup and Recovery
Module 6: Amazon Redshift Performance Tuning
Module 7: Securing Amazon Redshift
Day 3
Module 8: Orchestration
Module 9: Amazon Redshift ML
Module 10: Amazon Redshift Data Sharing
Module 11: Wrap-Up
We recommend that attendees of this course have completed the following courses:
This course is intended for:
- Data engineers
- Data architects
- Database architects
- Database administrators
- Database developers
NOK 31.000
