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

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

Advanced Tuning Strategies

Micro‐partitions and Clustering

Micro‐partition Pruning (Elimination)

Evaluating Clustering

Implement and Test Cluster Keys

Materialized Views

Search Optimization Service

QueryAcceleration Service (QAS)

Data Protection and Data Recovery

Fail‐safe

Data Recovery Scenarios

Data Quality and Data Metric Functions

Organizations

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

Replication

Overview

Replication Workflow

Failover Workflow

Client Redirect

Monitoring Replication

Functions and Procedures

User‐defined Functions

JavaScript Stored Procedures

Scripting in Snowflake

Snowflake Scripting Overview

Programmability Enhancements

Logging and Tracing

Event Tables

Snowflake Alerts

Using Alerts with Email Notifications

Data Sharing

Managing Data Exchange

Managing Data Marketplace

Database Roles

Whatare Database Roles?

Database Roles and Data Sharing

Snowflake Shared Database Roles

Hybrid Tables

Whatis aHybrid Table?

Implement Hybrid Tables

Hybrid Table Cost Analysis

Hybrid Table Limitations

Apache Iceberg™ Tables

Table Format Overview

Iceberg Table Format

Iceberg Tables in Snowflake Overview

Snowflake‐managed Apache Iceberg™ Tables

Create Externally Managed Iceberg Tables in Snowflake

Resource and Cost Management

Cost Management in Snowflake

Monitoring Access_History

Monitoring Compute

Monitoring Storage

Monitoring Data Transfer

Resource Monitors

DOWNLOAD COURSE BROCHURE

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

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree