Administering Snowflake II Training Logo

Administering Snowflake II Training

Live Online & Classroom Enterprise Training

Administering Snowflake II is an advanced course focused on enterprise-level Snowflake administration, security, and performance optimization. It builds expertise in managing complex workloads, governance, and high-availability features in production Snowflake environments.

COURSE BROCHURE DOWNLOAD PDF

Looking for a private batch ?

REQUEST A CALLBACK

Need help finding the right training?

Your Message

  • Enterprise Reporting

  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

What is Administering Snowflake II Training about?

This two‐day, role‐specific course continues the study and practical lab experience of database and account administration. This course includes data recovery scenarios, replication, and advanced tuning strategies. The course consists of lectures, labs, demonstrations, and discussions.

What are the objectives of Administering Snowflake II Training ?

  • Managemultiple accounts across the company using Snowflake Organization.
  • Employ data recovery methods using Time Travel and zero‐copy cloning.
  • Implement advanced techniques for Snowflake performance tuning methodologies.
  • Utilize Snowflake’s recommended management, monitoring, and optimization best practices.
  • Deploy replication for data sharing across accounts and failover scenarios.
  • Share data securely both inside and outside your organization.
  • Create and deploy administrative jobs using Snowflake stored procedures and functions.

Who is Administering Snowflake II Training for?

  • Database Administrators
  • System Administrators
  • Database Architects
  • Data Engineers

What are the prerequisites for Administering Snowflake II Training?

  • Recommended completion of the “Snowflake Multi‐Factor Authentication (MFA) Essentials” free on demand course.
  • Completion of the “Administering Snowflake” three‐day course or equivalent Snowflake knowledge.
  • A background in database administration or management is required.

Available Training Modes

Live Online Training

2 Days

Classroom Training

2 Days

Course Outline Expand All

Expand All

  • Micro‐partitions and Clustering
  • Micro‐partition Pruning (Elimination)
  • Evaluating Clustering
  • Implement and Test Cluster Keys
  • Materialized Views
  • Search Optimization Service
  • QueryAcceleration Service (QAS)
  • Fail‐safe
  • Data Recovery Scenarios
  • Data Quality and Data Metric Functions
  • Snowflake Organizations
  • Administrative Operations With Organizations
  • ORGADMINRole
  • Snowflake Role Types
  • Creating Accounts
  • Using Snowflake Database Roles with Organizations
  • Querying Organization Account Usage
  • Account Management Commands
  • Overview
  • Replication Workflow
  • Failover Workflow
  • Client Redirect
  • Monitoring Replication
  • User‐defined Functions
  • JavaScript Stored Procedures
  • Snowflake Scripting Overview
  • Programmability Enhancements
  • Logging and Tracing
  • Event Tables
  • Using Alerts with Email Notifications
  • Managing Data Exchange
  • Managing Data Marketplace
  • Whatare Database Roles?
  • Database Roles and Data Sharing
  • Snowflake Shared Database Roles
  • Whatis aHybrid Table?
  • Implement Hybrid Tables
  • Hybrid Table Cost Analysis
  • Hybrid Table Limitations
  • Table Format Overview
  • Iceberg Table Format
  • Iceberg Tables in Snowflake Overview
  • Snowflake‐managed Apache Iceberg™ Tables
  • Create Externally Managed Iceberg Tables in Snowflake
  • Cost Management in Snowflake
  • Monitoring Access_History
  • Monitoring Compute
  • Monitoring Storage
  • Monitoring Data Transfer
  • Resource Monitors

Who is the instructor for this training?

The trainer for this Administering Snowflake II Training has extensive experience in this domain, including years of experience training & mentoring professionals.

Reviews