Administering Snowflake II Training

Price
$2,000.00 USD

Duration
2 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

Request More Information
Download Course Details
Course Details Only
Course Details & Schedule
Skip to Class Dates

Course 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, database and account replication, and advanced performance tuning strategies. The course consists of lectures, labs, demonstrations, and discussions.

Course Objectives

  • 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 best practices for management, monitoring, and optimization.
  • 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 Should Attend?

  • Database Administrators
  • System Administrators
  • Database Architects
  • Data Engineers
  • Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
  • Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
  • Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
  • Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
  • Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
  • Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

Course Prerequisites

  • A background in database administration or management is required.
  • Completion of “Administering Snowflake” three‐day course or equivalent Snowflake knowledge

Agenda

1 - Advanced Tuning Strategies

  • Micro‐partitions and Clustering
  • Micro‐partition Pruning (Elimination)
  • Evaluating Clustering
  • Implement and Test Cluster Keys
  • Materialized Views
  • Search Optimization Service
  • Query Acceleration Service (QAS)

2 - Data Protection and Data Recovery

  • Fail‐safe
  • Data Recovery Scenarios

3 - Organizations

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

4 - Replication

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

5 - Functions and Procedures

  • User‐defined Functions
  • JavaScript Stored Procedures

6 - Scripting in Snowflake

  • Snowflake Scripting Overview
  • Programmability Enhancements
  • Logging and Tracing
  • Event Tables

7 - Snowflake Alerts

  • Using Alerts with Email Notifications

8 - Data Sharing

  • Managing Data Exchange
  • Managing Data Marketplace

9 - Database Roles

  • What are Database Roles?
  • Database Roles and Data Sharing
  • Snowflake Shared Database Roles

10 - Hybrid Tables

  • What is a Hybrid Table?
  • Implement Hybrid Tables
  • Hybrid Table Cost Analysis
  • Hybrid Table Limitations

11 - 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

12 - Resource and Cost Management

  • Cost Management in Snowflake
  • Monitoring Access_History
  • Monitoring Compute
  • Monitoring Storage
  • Monitoring Data Transfer
  • Resource Monitors
 

Upcoming Class Dates and Times

Jun 11, 12
9:00 AM - 5:00 PM
ENROLL $2,000.00 USD
Guaranteed to Run
Virtual: - CST
Jul 23, 24
9:00 AM - 5:00 PM
ENROLL $2,000.00 USD

Virtual: - CST
Sep 9, 10
9:00 AM - 5:00 PM
ENROLL $2,000.00 USD

Virtual: - CST
Oct 20, 21
9:00 AM - 5:00 PM
ENROLL $2,000.00 USD

Virtual: - CST
CourseID: 3606109E
 



Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
Contact Us about Starting Your Business Training Strategy with New Horizons