Snowflake Advanced Training

Start Date: January 01, 1970 – 12:00 AM (Pacific Time)

End Date: January 01, 1970 – 12:00 AM (Pacific Time)

$2,400.00

*Looking for flexible schedule (after hours or weekend)? Please call or email us: 858-208-4141 or sales@ccslearningacademy.com.
Student financing options are available.

Transitioning military and Veterans, please contact us to sign up for a free consultation on training and hiring options.
Qty:
Category:

Download PDF of Course Details

Course Description:

This 3-day course covers advanced Data Movement, Performance, Security, Agile Development and Data Sharing design considerations and best practices in the Snowflake Cloud Data Platform. This advanced course will consist of lecture, demos, and labs.

Course 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

Course 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

Target 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.

Inclusions

With CCS Learning Academy, you’ll receive:

  • Instructor-led training
  • Training Seminar Student Handbook
  • Pre and Post assessments/evaluations
  • Collaboration with classmates (not currently available for self-paced course)
  • Real-world learning activities and scenarios
  • Exam scheduling support*
  • Enjoy job placement assistance for the first 12 months after course completion.
  • This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
  • Government and Private pricing available.*

*For more details call: 858-208-4141 or email: training@ccslearningacademy.com; sales@ccslearningacademy.com