Coursera Plus Annual is 50% Off — Ends June 17.

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

CodeSignal

Data Warehousing on AWS with Amazon Redshift

via CodeSignal

Go to class Write review

Overview

Build a fast, organized analytics warehouse on AWS by connecting Redshift Serverless to your S3 data lake. Model a star schema, load and export data efficiently, tune for speed, and publish business-ready analytics—all with hands-on, real-world demos.

Syllabus

  • Unit 1: Querying S3 with Spectrum
    • Fix External Schema Syntax Errors
    • Complete Your External Schema Setup
    • Query Your First S3 Data
    • Analyze Data with Aggregation Queries
    • Debug Your Broken Spectrum Query
  • Unit 2: Creating Dimension Tables
    • Adding Columns to Dimension Tables
    • Creating Your First Dimension Table
    • Optimizing Dimension Tables for Performance
  • Unit 3: Fast Data Loads in Redshift
    • Complete Your First COPY Command
    • Write Your First COPY Command
    • Verify Your Data Load Success
    • Complete Your First UNLOAD Command
    • Build Your Complete Data Pipeline
  • Unit 4: Query Tuning with Redshift
    • Running Your First ANALYZE Command
    • Complete Table Maintenance Workflow
    • Manual Query Performance Timing
    • Benchmarking Patron Analytics Query Performance

Reviews

Start your review of Data Warehousing on AWS with Amazon Redshift

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.