Trending Courses
Vendors
Agile & Scrum
POPULAR COURSES
Read More In Blog
#BeCyberSmart with Microsoft: Cybersecurity Awareness Month 2024
AI & Machine Learning
Analytics & Data Management
Big Data
Business Application
Cloud Computing
Cyber Security
Database Admin & Dev
Data Engineering & Science
DevOps
Digital Transformation
IT Governance
IT Infrastructure
IT Service Management
Networking
Programming & Development
Project Management
Virtualization
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.
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.
Database Administrators System Administrators Database Architects Data Engineers
Coming Soon...
Module 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) Module 2: Data Protection and Data Recovery Fail-safe Data Recovery Scenarios Data Quality and Data Metric Functions Module 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 Module 4: Replication Overview Replication Workflow Failover Workflow Client Redirect Monitoring Replication Module 5: Functions and Procedures User-defined Functions JavaScript Stored Procedures Module 6: Scripting in Snowflake Snowflake Scripting Overview Programmability Enhancements Logging and Tracing Event Tables Module 7: Snowflake Alerts Using Alerts with Email Notifications Module 8: Data Sharing Managing Data Exchange Managing Data Marketplace Module 9: Database Roles What are Database Roles? Database Roles and Data Sharing Snowflake Shared Database Roles Module 10: Hybrid Tables What is a Hybrid Table? Implement Hybrid Tables Hybrid Table Cost Analysis Hybrid Table Limitations Module 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 Module 12: Resource and Cost Management Cost Management in Snowflake Monitoring Access_History Monitoring Compute Monitoring Storage Monitoring Data Transfer Resource Monitors
Module 1: Advanced Tuning Strategies
Module 2: Data Protection and Data Recovery
Module 3: Organizations
Module 4: Replication
Module 5: Functions and Procedures
Module 6: Scripting in Snowflake
Module 7: Snowflake Alerts
Module 8: Data Sharing
Module 9: Database Roles
Module 10: Hybrid Tables
Module 11: Apache Iceberg™ Tables
Module 12: Resource and Cost Management
Level-up by partnering with Trainocate. Get in touch today.
By submitting this form, you consent to Trainocate processing your data to respond to your inquiry and provide you with relevant information about our training programs, including occasional emails with the latest news, exclusive events, and special offers.
You can unsubscribe from our marketing emails at any time. Our data handling practices are in accordance with our Privacy Policy.
Your Cart Is Empty!