Snowflake Administering Training

• Identify the different aspects of storage and compute management
• Explain Snowflake architecture for administrative tasks
• Learn considerations and best practices to manage performance and load operations
• Explain DDL operations that work with fundamental database objects
• What are DML considerations, and transaction and concurrency model?
• Implement agile development and recovery methods with Cloning & Time Travel
• How to use snowflake methodology for performance tuning?
• How to design as well as develop secured access to objects in snowflake with role-based access control?
• Best practices for optimization, management and monitoring
• How to share data outside or in your organization securely?

• Recorded Videos After Training
• Digital Learning Material
• Course Completion Certificate
• 24x7 After Training Support

• Database Administrators
• Database Architects
• Data Engineers

• Database management or administration background is required.

• Multisoft Systems provides a globally recognized training certificate after successful completion of Administering Snowflake Training Certification Course.

Module 1: Overview and Architecture

• Snowflake Cloud Data Platform
• Functional Architecture and Workloads
• Global Structure: Cloud Platforms and Regions

Module 2: Snowflake Environment

• Cloud Services Layer
• Compute Layer
• Data Storage Layer
• Scaling Up, Out, and Across
• Account Structure
• Set Account Parameters

Module 3: Data Storage and Metadata

• What is Micro-partitioning?
• Data Clustering

Module 4: Data Objects and Commands

• Objects
• Tables
• Constraints
• Views
• Data Types
• Semi-structured Data
• Querying Semi-structured dat

Module 5: Clients, Connectors, and Ecosystems

• Clients and Interfaces
• SnowSQL

Module 6: Caching

• Metadata Cache
• Query Result Cache
• Data Cache

Module 7: Managing Security

• Access
• Authentication
• Encryption Key Management
• Authorization and Access Control
• Privileges and Roles
• Role Management
• User Management

Module 8: Administering Data Governance

• Data Governance and Snowflake
• Identify and Classify
• Protect
• Audit and Analyze

Module 9: Managing Data Ingestion and Scaling

• Streaming and Batch Loading
• Bulk Loading
• Storage Integration
• Snowpipe
• Load Operation Performance

Module 10: DML and Transaction Concurrency

• Transaction Concurrency Goals
• System’s Point of View
• Monitoring and Management Functions

Module 11: Data Sharing

• Data Providers
• Data Consumers
• The Data Marketplace
• Reader Account

Module 12: Back-up, Restore, and Snapshot

• Time Travel and Point-in-time Restore
• Fail-safe
• Zero-copy Cloning

Module 13: Data Replication

• Configuring Data Replication
• Failover and Failback

Module 14: Managing Query Performance

• Query Profiles
• Explain Plan
• Writing Efficient Queries

Module 15: Advanced Tuning Strategies

• Micro-partitions and Clustering
• Automatic Clustering Service
• Designing Clustering Keys
• Materialized Views
• Search Optimization Service

Module 16: Organizations

• Account Management Challenges
• Snowflake Organizations
• Administrative Operations with Organizations
• ORGADMIN Role
• Creating Accounts
• Querying Organization Account Usage
• Account Management Commands

Module 17: Resource and Cost Governance

• Monitoring Compute
• Monitoring Serverless Compute
• Monitoring Storage
• Monitoring Data Transfer
• Resource Monitors

Module 18: Stored Procedures and Tasks

• Stored Procedures
• Tasks