Administering Snowflake II Course Overview

Course Prerequisites

• Basic Computer Knowledge.

Target Audience for Administering Snowflake II

Course Introduction and Audience
Administering Snowflake II is a specialized, advanced course designed for IT professionals aimed at deepening their skills in database and account administration within the Snowflake environment.

Job Roles and Audience

• Database Administrators (DBAs)
• Cloud Administrators
• Data Engineers
• IT Managers
• System Administrators
• Data Architects
• DevOps Engineers
• Cloud Solutions Architects
• IT Consultants
• Performance Tuning Specialists
• SREs (Site Reliability Engineers)
• Technical Leads

Learning Objectives - What you will Learn in this Administering Snowflake II?

Introduction

The Administering Snowflake II course aims to equip students with advanced database and account administration skills in Snowflake. This intensive two-day program covers data recovery, replication, performance tuning strategies, and more through lectures, labs, and practical demonstrations.

Learning Objectives and Outcomes

• Advanced Tuning Strategies

  • Learn about micro-partitions and clustering.
  • Gain knowledge on micro-partition pruning (elimination).
  • Evaluate and implement cluster keys.
  • Use materialized views, search optimization service, and query acceleration service for enhanced performance.

• Data Protection and Data Recovery

  • Understand fail-safe mechanisms and data recovery scenarios.

• Organizations

  • Gain insights into Snowflake Organizations and administrative operations.
  • Learn about the ORGADMIN role and querying organization account usage.
  • Master account management commands and the use of database roles within organizations.

• Database Replication

  • Get an overview of replication and failover workflows.
  • Learn about client redirect mechanisms.

• Account Replication

  • Understand the purpose and key use cases of account replication.

• Functions and Procedures

  • Develop user-defined functions and JavaScript stored procedures.
  • Explore programmability enhancements along with logging and tracing techniques.