Advanced to Snowflake
- Created By raju2006
- Last Updated December 29th, 2023
- Overview
- Prerequisites
- Audience
- Audience
- Curriculum
Description:
Dive deep into Snowflake's architecture and partitioning in this comprehensive course. Participants will not only master the creation of Role-Based Access Control (RBAC) hierarchies but also learn to seamlessly integrate Snowflake into disaster recovery strategies, optimize performance, and automate workflows for an efficient data management experience.
Course Code/Duration:
BDT111 / 2 Days
Learning Objectives:
In this course, participants will:
- Describe advanced Snowflake architecture feature and functionality
- Design and build an RBAC hierarchy
- Share data from inside or outside of an organization
- Incorporate Snowflake into your Disaster Recovery plan
- Use performance tuning and resource management features to optimize Snowflake
- Leverage advanced caching features to enhance performance
- Enhance continuous data pipelines with scheduled tasks to create an automated workflow
- Snowflake Foundations course or similar experience.
- The target audience for this course is DBAs, and Architects.
- The target audience for this course is DBAs, and Architects.
Course Outline:
The course includes presentations, demonstrations, and hands-on labs.
Module 1: Advanced Architecture
- Three Tiered Architecture
- Micro-Partitioning in Showflake
- Workshop: Snowflake Workshop
- Lab: Snowflake Clustering
Module 2:Building an RBAC Hierarchy
- Role Hierarchies
- Multifactor Authentication and Authorization
- Security Best Practices
- Workshop: Snowflake Roles
- Lab: Connecting Snowflake
Module 3: 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
Module 4: Performance Tuning and Resource Management
- Designing High Performance Tables and Queries
- Resource Usage and Billing
- Multi-clustering and Clustering Keys
- Scaling
- Lab: Performance Tuning
Module 5: How Caching Improves Performance
- Temp Tables
- Transient Tables
- Snowflake Caching Features
- Lab: Advanced Caching
Module 6: Tasks and Scheduling Management
- Integrating Stored Procedures, Views, and Functions
- Tasks and Scheduling
- Lab: Enhance Continuous Data Pipeline
Training material provided:
Yes (Digital format)
The curriculum is empty
[INSERT_ELEMENTOR id="19900"]
