SnowPro Advanced Data Engineer: Performance Optimization

سرفصل های دوره

Maximize your Snowflake data platform's performance with advanced optimization techniques. This course will teach you expert techniques for identifying and resolving bottlenecks, leveraging caching, and monitoring data pipelines.

1. Course Overview

1. Course Overview

2. Optimizing Query Performance

1. Outlining Telemetry around Query Operations

2. Demo - Identifying Underperforming Queries

3. Demo - Increasing Efficiency of Underperforming Queries

4. Identifying Root Causes of Underperforming Queries

3. Configuring Solutions for Best Performance

1. Scaling Out vs. Scaling Up

2. Demo - Exploring Virtual Warehouse Properties

3. Examining Micro-partitions and Clustering

4. Demo - Analyzing Micro-partitions and Clustering

5. Demo - Leveraging Materialized Views

6. Utilizing Search Optimization Service

7. Applying Query Acceleration Service

4. Data Caching and Monitoring Continuous Data Pipelines

1. Outlining Caching Features

2. Demo - Exploring Caching Features

3. Understanding Snowpipe, Streams, and Tasks

4. Demo - Monitoring Streams and Tasks

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight