Intermediate Snowflake
- Created By raju2006
- Last Updated December 20th, 2023
- Overview
- Prerequisites
- Audience
- Audience
- Curriculum
Description:
Unlock the Power of Snowflake: Dive Deep into Architecture, Partitioning, and Advanced Techniques. Learn to Build RBAC Hierarchies, Ensure Disaster Recovery, Optimize Query Performance, and Streamline Workflows in this Comprehensive Course.
Course Code/Duration:
BDT199 / 1 Day
Learning Objectives
After this course, you will be able to:
- Architecture review
- Design and Build a RBAC Hierarchy
- Data Sharing and Disaster Recover
- Performance Tuning and Resource Management
- Leverage caching features to enhance performance
- Enhance continuous data pipelines with scheduled tasks to create automated workflows
- Have taken Kick start Snowflake in a day or understand basics of Snowflake architecture.
- This course is designed for anyone interested to get started with using Snowflake – Developers, DBA, Architects.
- This course is designed for anyone interested to get started with using Snowflake – Developers, DBA, Architects.
Topic Outline:
- Build An RBAC Hierarchy
- Role hierarchies
- Multifactor Authentication and Authorization
- Security Best Practices
- Lab: Connecting Snowflake
- Data Sharing And Disaster Recovery
- Overview of Time Travel and Copy Cloning
- Data Sharing
- Overview of Disaster Recovery
- Disaster Recovery with Snowflake
- Lab: Data Sharing and Disaster Recovery
- Performance Tuning And Resource Management
- Designing High Performance Tables and Queries
- Resource Usage and Billing
- Multi-clustering and Clustering Keys
- Lab: Clustering
- Caching To Improve Performance
- Table Types – Temp, Transient and Permanent
- Snowflake caching features
- Lab: Caching
- Tasks And Scheduling Management
- Integrating Store Procedures, Views and Functions
- Tasks and Scheduling
- Lab: Stored Procedure
Training material provided: Yes (Digital format)
The curriculum is empty
[INSERT_ELEMENTOR id="19900"]
