Duration
3 days.
Prerequisites
- Taken AWS Technical Essentials (or equivalent experience with AWS)
- Familiarity with relational databases and database design concepts
Skills Gained
This course teaches you 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, 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
Who Can Benefit?
- Database Architects
- Database Administrators
- Database Developers
- Data Analysts
- Data Scientists
Outline for Data Warehousing on AWS Training
Day 1
- Introduction to Data Warehousing
- Introduction to Amazon Redshift
- Launching Clusters
Day 2
- Designing the Database Schema
- Identifying Data Sources
- Loading Data
Day 3
- Writing Queries and Tuning Performance
- Amazon Redshift Spectrum
- Maintaining Clusters
- Analyzing and Visualizing Data
12/06/2023 - 12/08/2023
12:00 PM - 08:00 PM
Eastern Standard Time
USD $2,025.00
01/23/2024 - 01/25/2024
09:00 AM - 05:00 PM
Eastern Standard Time
USD $2,025.00
03/05/2024 - 03/07/2024
09:00 AM - 05:00 PM
Eastern Standard Time
USD $2,025.00