Course Outline

Introduction to Data Warehousing

Overview of Amazon Redshift Features and Architecture

Installing and Configuring Amazon Redshift

Benefits of Using Amazon Redshift

Creating, Resizing, and Launching an Amazon Redshift Cluster

Data Loading in Amazon Redshift

  • Introduction to Data Loading
  • Designing and Creating Tables
  • Loading Sample Data Set into RedShift
  • Data Distribution in Redshift
  • Data Loading Best Practices

Querying Data within Redshift

  • Designing Queries
  • Tuning Query Performance

Data Integration, Analysis, and Visualization with Redshift

  • Connecting and Using Data Integration (ETL) Tools with Redshift
  • Connecting and Using Business Intelligence (BI) Tools with Redshift

Troubleshooting

Summary and Conclusion

Requirements

  • Basic experience with Amazon Web Services (AWS)
  • Familiarity with database concepts
 21 Hours

Number of participants



Price per participant

Testimonials (2)

Related Courses

Data Vault: Building a Scalable Data Warehouse

28 Hours

Amazon DynamoDB for Developers

14 Hours

Advanced Amazon Web Services (AWS) CloudFormation

7 Hours

AWS CloudFormation

7 Hours

AWS IoT Core

14 Hours

Amazon Web Services (AWS) IoT Greengrass

21 Hours

Industrial Training IoT (Internet of Things) with Raspberry PI and AWS IoT Core 「4 Hours Remote」

4 Hours

Industrial Training IoT (Internet of Things) with Raspberry PI and AWS IoT Core 「8 Hours Remote」

8 Hours

Advanced AWS Lambda

14 Hours

AWS Lambda for Developers

14 Hours

Big Data & Database Systems Fundamentals

14 Hours

Azure Data Lake Storage Gen2

14 Hours

Apache Druid for Real-Time Data Analysis

21 Hours

Pivotal Greenplum for Developers

21 Hours

Greenplum Database

14 Hours

Related Categories

1