Data Warehousing on AWS

Build a data warehousing solution on the AWS cloud and train your team in data collection, storage, and preparation. The Data Warehousing on AWS training offers hands-on experience with key services, including Amazon DynamoDB, Amazon EMR, Amazon Redshift, and Amazon S3, equipping your team with the skills needed to effectively manage and utilize data in a cloud environment.

Course Details

Price:

$2,025.00

Days:

Location:

Virtual

Course Overview

– • 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

• Familiarity with relational databases
• Understanding of database design concepts

• Loading data
• Loading data
• Loading data
• Loading data
• Writing queries and tuning for performance
• Writing queries and tuning for performance
• Writing queries and tuning for performance
• Writing queries and tuning for performance
• Amazon Redshift Spectrum
• Amazon Redshift Spectrum
• Amazon Redshift Spectrum
• Amazon Redshift Spectrum
• Maintaining clusters
• Maintaining clusters
• Maintaining clusters
• Maintaining clusters
• Analyzing and visualizing data
• Analyzing and visualizing data
• Analyzing and visualizing data
• Analyzing and visualizing data
• Introduction to Data Warehousing
• Introduction to Data Warehousing
• Introduction to Data Warehousing
• Introduction to Data Warehousing
• Introduction to Amazon Redshift
• Introduction to Amazon Redshift
• Introduction to Amazon Redshift
• Introduction to Amazon Redshift
• Launching clusters
• Launching clusters
• Launching clusters
• Launching clusters
• Designing the database schema
• Designing the database schema
• Designing the database schema
• Designing the database schema
• Identifying data sources
• Identifying data sources
• Identifying data sources
• Identifying data sources

Class Dates & Times


6/2/2025 Virtual 09:00:00-17:00:00 CST Enroll Now $2,025.00
7/7/2025 Virtual 09:00:00-17:00:00 CST Enroll Now $2,025.00
8/4/2025 Virtual 09:00:00-17:00:00 CST Enroll Now $2,025.00
9/8/2025 Virtual 09:00:00-17:00:00 CST Enroll Now $2,025.00
10/6/2025 Virtual 09:00:00-17:00:00 CST Enroll Now $2,025.00
11/3/2025 Virtual 09:00:00-17:00:00 CST Enroll Now $2,025.00
12/8/2025 Virtual 09:00:00-17:00:00 CST Enroll Now $2,025.00

— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.

Student? Switch to our Career Center Site →