Skip to Scheduled 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.
Who Should Attend
- Database Administrators
- System Administrators
- Database Architects
- Data Engineers
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
Course Outline
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