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
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:
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:
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
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
Write a review
$2,400.00
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.*
AZ-204T00-A: Developing solutions for Microsoft Azure
$2,195.00$2,695.00
DP-900T00: Microsoft Azure Data Fundamentals
$495.00$795.00
