Overview

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.

Skills Covered

  • Manage multiple 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.

Prerequisites

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

Target Audience

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

Course Curriculum

Clustering and Materialized Views

  • Micro‐partitions and Clustering
  • Micro‐partition Pruning (Elimination)
  • Evaluating Clustering
  • Implement and Test Cluster Keys
  • Materialized Views

Search Optimization Service

  • Define Search Optimization Service
  • Enable Search Optimization
  • Cost Considerations When Using Search Optimization Service

Query Acceleration Service (QAS)

  • Define the Query Acceleration Service (QAS)
  • Understand QAS Query Eligibility
  • Enabling the Query Acceleration Service
  • Monitor Query Acceleration Costs

Virtual Warehouse Optimization

  • Virtual Warehouse Behavior
  • Virtual Warehouse Settings
  • Monitor Virtual Warehouse Efficiency

Hybrid Tables

  • What is a Hybrid 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
  • Create Managed Apache Iceberg™ Tables
  • Create Externally Managed Iceberg Tables in Snowflake

Organizations

  • Snowflake Organizations
  • Administrative Operations with Organizations
  • GLOBALORGADMIN Role
  • Snowflake Role Types
  • Creating Accounts
  • Using Snowflake Database Roles with Organizations
  • Querying Organization Account Usage
  • Account Management Commands

Data Sharing

  • Data Access Options
  • Managing Data Exchange
  • Managing Data Marketplace
  • Native Data Clean Rooms

Replication

  • Overview
  • Replication Workflow
  • Failover Workflow
  • Client Redirect
  • Monitoring Replication

Dates & Locations

Let’s make it work for you

Can’t find a date that fits? Need to train your whole team? Looking for a discount?
Speak to one of our learning experts today.

There’s no intakes scheduled for this course at the moment!

For enquiries, please contact our reps.

Exam & Certification

Training & Certification Guide

Why train with Trainocate

Speak to a Training Consultant

All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631

Preferred mode of training
Checkboxes