Unlock the potential of data warehousing on Amazon Web Services (AWS) with this intermediate-level course, Amazon Redshift – Best Practices for Data Warehousing on AWS. You will learn skills to optimize data warehousing. You will learn best practices for data modeling, table design, and query design to make sure that your data is structured for maximum performance and insights. The course also covers best practices for high-throughput data loading, and workload management strategies to help you deliver fast query responses. You will learn to further optimize your data warehouse by using Amazon Redshift Advisor and logging tools. At the end of the course, you will walk away empowered to design, deploy, and optimize Amazon Redshift environments that drive strategic business impact for your organization.
Activities
- Presentations
- Videos
- Knowledge checks
Course objectives
- Describe popular data modeling approaches and best practices for when to use a given approach.
- Identify supported data types.
- Recognize best practices for choosing column compression, distribution keys, or sort keys when designing Amazon Redshift tables.
- Explain best practices for structuring data and authoring SQL queries for Amazon S3.
- Distinguish manual and automatic WLM and identify best practices for working with each.
- Identify best practices of performing administrative tasks for loaded data.
- Describe the Amazon Redshift logging tools for auditing at the database and service levels.
Intended audience
- Data engineers
- Data architects
- Database architects
- Database administrators
Recommended skills
- Experience working with data warehouses and Amazon Redshift
- Completion of the following digital courses is recommended:
- Amazon Redshift Getting Started
- Fundamentals of Analytics on AWS – Part 1
- Fundamentals of Analytics on AWS – Part 2
Course outline
- Module 1: Introduction
- Introduction to Amazon Redshift
- Module 2: Optimizing Amazon Redshift
- Table Design Best Practices
- Query Design Best Practices
- Data Lake Modeling Best Practices
- Workload Management Best Practices
- Data Load Best Practices
- Auditing and Compliance
- Module 3: Getting Help
- Learn More
- Contact Us
