SnowPro Advanced Data Engineer: Performance Optimization

Focused View

Pinal Dave

1:04:26

0 View

1. Course Overview

1. Course Overview.mp4

01:29

2. Optimizing Query Performance

1. Outlining Telemetry around Query Operations.mp4

04:25

2. Demo - Identifying Underperforming Queries.mp4

06:41

3. Demo - Increasing Efficiency of Underperforming Queries.mp4

03:30

4. Identifying Root Causes of Underperforming Queries.mp4

04:15

3. Configuring Solutions for Best Performance

1. Scaling Out vs. Scaling Up.mp4

04:06

2. Demo - Exploring Virtual Warehouse Properties.mp4

04:10

3. Examining Micro-partitions and Clustering.mp4

06:35

4. Demo - Analyzing Micro-partitions and Clustering.mp4

03:17

5. Demo - Leveraging Materialized Views.mp4

03:43

6. Utilizing Search Optimization Service.mp4

02:20

7. Applying Query Acceleration Service.mp4

02:06

4. Data Caching and Monitoring Continuous Data Pipelines

1. Outlining Caching Features.mp4

04:36

2. Demo - Exploring Caching Features.mp4

02:35

3. Understanding Snowpipe, Streams, and Tasks.mp4

05:08

4. Demo - Monitoring Streams and Tasks.mp4

05:30

Description

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.

What You'll Learn?

Optimizing the performance of your Snowflake data platform is crucial for ensuring the efficiency and scalability of your data-driven operations.

In this course, SnowPro Advanced Data Engineer: Performance Optimization, you'll gain the ability to become a Snowflake performance optimization expert.

First, you'll explore techniques for troubleshooting underperforming queries, including identifying bottlenecks, outlining telemetry, increasing efficiency, and identifying root causes.

Next, you'll discover how to configure Snowflake solutions for the best performance, including scaling out vs. scaling up, understanding virtual warehouse properties, optimizing micro-partitions and clustering, leveraging materialized views, and utilizing search and query acceleration services.

Finally, you'll learn how to outline and use caching features, as well as monitor continuous data pipelines, including Snowpipe, tasks, and streams.

When you're finished with this course, you'll have the skills and knowledge of Snowflake performance optimization needed to design, implement, and maintain highly efficient and scalable data solutions on the Snowflake platform.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Pinal Dave

Instructor's Courses

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 45 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at https://blog.sqlauthority.com.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.