Snowflake Advanced 3-Day (Multi-Week)

News
NEW ADVANCED CERTIFICATION AVAILABLE ➤  Learn more about the SnowPro Advanced: Architect exam.   NEW PERFORMANCE AUTOMATION & TUNING COURSE ➤  Learn more and sign up for the first public instructor-led class!   COMPLETE YOUR SNOWPRO CORE CERT. PREP WITH OUR ON-DEMAND PREPARATION COURSE➤   Learn more!   COVID-19 UPDATES ➤   Instructor-led classes will be delivered via virtual classroom only.  

Snowflake Advanced 3-Day (Multi-Week)

Snowflake Advanced 3-Day (Multi-Week)

Summary

In this multi-week course, students learn the advanced Data Movement, Performance, Security, Agile Development and Data Sharing design considerations and best practices in the Snowflake Cloud Data Platform. The course will consist of lecture, demos, labs and office hours with the instructor to cover a wide range of advanced topics.

Duration

3 Days

Objectives

By the end of this course, you will be able to:

  • Evaluate Snowflakes advanced architectural concepts
  • Employ strategies and best practices for agile development
  • Discuss Snowflakes various ingestions methods for streaming data
  • Develop a methodology for performance tuning
  • Design a comprehensive program for ensuring user, network & data security
  • Share data in or outside of your organization securely

Audience

Who should attend this course?

  • Data Analysts
  • Data Engineers
  • Data Scientists
  • Database Architects
  • Database Administrators

Prerequisites

Students should have completed Fundamentals training or have previous working knowledge of Snowflake.

Setup Requirements

Snowflake Training students need...

  • to bring a laptop
  • a Snowflake compatible browser (see options HERE)
  • have SNOWSQL installed
  • have DOCKER installed

IMPORTANT: The Advanced course assumes participants have completed the Fundamentals course or have previous experience using Snowflake.

Outline

Week 1:

Introductions
Architecture
  • Recap
  • Compute
Clustering
  • Natural Clustering
  • Auto Clustering Service
  • Explicit Clustering
Caching
  • Query Result Cache
  • Metadata Cache
  • Warehouse Cache
Deployment Approaches
Loading data
  • Best Practices
  • Transforming Data
  • Unloading Data
Semi-Structured Data
  • FLATTEN Data
  • Applications
  • Advanced Topics


Week 2:
Snowpipe
Data Lake Support
Querying
  • Constructing Efficient Queries
  • Pruning
  • Grouping and Sorting
Continuous Data Protection
  • Time Travel
  • Cloning
Streams and Tasks
  • Introduction
  • Streams
  • Tasks
  • Streams and Tasks Together
Agile Database Development
  • Recap
  • Replication
Global Snowflake
  • Overview
  • Replication


Week 3:
Data Sharing
  • Advanced Sharing Topics
  • Secure Objects
Clients
  • Python
  • Pandas
  • SQLAlchemy
  • Spark
Managing Security
  • Overview
  • Encryption Key Management
SCIM
  • Overview
  • SCIM for Okta
  • SCIM for Active Directory
Access Control
  • Authorization
  • Privileges
  • Users
  • Roles
Performance
  • Tuning Metrics
  • Bottleneck Scenarios
  • Concurrency
  • Concurrency Scenarios
  • Concurrency Issues
Monitoring
  • ACCOUNT_USAGE Share
  • Compute
  • Storage
  • Serverless Services
  • Resource Monitors
Materialized Views
Newer SQL Features
  • Stored Procedures
  • Collations
  • CTEs and CONNECT BY

View and download the Advanced Course Datasheet

Upcoming Classes

No classes have been scheduled, but you can always Request a Quote.

Already enrolled in an Instructor-Led class or paid On-Demand course? Log in to your Learner Dashboard.