Advanced Snowflake

Course Summary

The Advanced Snowflake training course is designed to demonstrate a high-level examination of Snowflake.

The course begins with a discussion of the basics of Snowflake and its architecture. Next, it explores how to ingest data, cache various levels, and optimize performance. The course concludes with a description of how to harden security and design Snowflake objects.

Prerequisites: A background in the basics of Snowflake and Python is required.

Skill Level	Advanced
Style	Workshops
Duration	3 Days
Related Technologies	Snowflake \| Python

Productivity Objectives

Demonstrate a high level understanding of Snowflake
Explore how to ingest data
Understand query plan
Design Snowflake objects

What You'll Learn:

In the Advanced Snowflake training course, you'll learn:

Quick Recap of Snowflake Basics
- Layered architecture of Snowflake
- Ingesting data into Snowflake
- Concept of micro partitions
- Functions and procedures
- Working with Snowflake
Ingesting and Streaming Data
- How does Snowpipe work?
- Ingesting data using Snowpipe
- Concept of Streams
- Streams and tasks
- Implementation of CDC using streams
Working with Snowflake Cache
- Types of Cache
- Understanding Result Cache
- Exploring Data Cache
- Optimizing Query performance with Cache
Data Sharing
- Data Sharing Concepts
- Data Providers & Consumers
- Sharing Data outside organization
- Sharing Data within organization
Managing Security
- Authentication
- Role Hierarchy in Snowflake
- Encryption
- Network Policies
- Dynamic Data Masking
Query Tuning and Best Practices
- Understanding Query Plan
- Pruning
- Spillage
- Best Practices for writing Query
Designing Snowflake Objects
- Things to take care while designing
- Data Clustering
- When to choose Materialized Views?
- Performance Tuning

Real-World Content

Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.

Expert Practitioners

Industry experts that bring their battle scars into the classroom.

Experiential Learning

More coding than lecture, coupled with architectural and design discussions.

Tailored Outlines

One-size-fits-all doesn't apply to training teams. That's where we come in!

“I appreciated the instructor's technique of writing live code examples rather than using fixed slide decks to present the material.”

VMware

Dive in and learn more

When transforming your workforce, it's important to have expert advice and tailored solutions. We can help. Tell us your unique needs and we'll explore ways to address them.

Let's chat

First Name*

Last Name*

Business Email*

Company*

Job Title*

Phone*

Country*

Tell us about what you’re looking to accomplish:

By filling out this form and clicking submit, you acknowledge our privacy policy.