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
 

Testimonials

Related Courses

Data Vault: Building a Scalable Data Warehouse

  28 hours

Amazon DynamoDB for Developers

  14 hours

AWS CloudFormation

  7 hours

Advanced Amazon Web Services (AWS) CloudFormation

  7 hours

AWS IoT Core

  14 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

Amazon Web Services (AWS) IoT Greengrass

  21 hours

AWS Lambda for Developers

  14 hours

Advanced AWS Lambda

  14 hours

Big Data & Database Systems Fundamentals

  14 hours

Apache Druid for Real-Time Data Analysis

  21 hours

Apache Kylin: From Classic OLAP to Real-Time Data Warehouse

  14 hours

MemSQL

  28 hours

Pivotal Greenplum for Developers

  21 hours