Facebook

Snowflake Advanced Training

* Looking for a flexible schedule (after hours or weekends)? Please call 858-208-4141 or email us:  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.

Looking for group training? Contact Us

psinghal
Last Update December 12, 2023
0 already enrolled

About This Course

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

Learning Objectives

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

Inclusions

  • Instructor-led training
  • Training Seminar Student Handbook
  • 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.*

Pre-requisites

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

Target Audience

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

Your Instructors

psinghal

0/5
430 Courses
0 Reviews
0 Students
See more

Write a review

IMG1696503032.jpg

$2,400.00

Level
Intermediate
Duration 24 hours

Inclusions

  • Instructor-led training
  • Training Seminar Student Handbook
  • 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.*

Don't have an account yet? Sign up for free

🚀 Get Up to 33% OFF on Top Courses + FREE e-learning subscription (worth $1595)
This is default text for notification bar