Amazon Redshift Fundamentals: Distribution Styles and Performance Tuning

<p>Follow Marcus Webb, a data engineer at Tidewater Media, a regional streaming service, as he takes over a struggling Amazon Redshift cluster and chases down why dashboards crawl during peak hours. Across five hands-on lessons you will learn how Redshift's leader node, compute nodes, and slices differ from the decoupled, serverless model of BigQuery and Snowflake, how to pick distribution styles (KEY, ALL, EVEN) that eliminate network shuffles and avoid data skew, how compound and interleaved sort keys let Redshift skip blocks instead of scanning whole tables, how workload management queues and query monitoring rules keep concurrent workloads from starving each other, and how VACUUM, ANALYZE, and Redshift's own system tables turn cluster health from a mystery into a repeatable check.</p>

Tools: Amazon Redshift, SQL, AWS, Data Warehousing