Administering Snowflake Training Logo

Administering Snowflake Training

Live Online & Classroom Enterprise Training

Administering Snowflake is a hands-on course focused on managing, securing, monitoring, and optimizing Snowflake accounts in production environments. It equips learners with the skills required to operate Snowflake reliably at scale with strong governance and cost control.

COURSE BROCHURE DOWNLOAD PDF

Looking for a private batch ?

REQUEST A CALLBACK

Need help finding the right training?

Your Message

  • Enterprise Reporting

  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

What is Administering Snowflake Training about?

This three‐day, role‐specific course provides an in‐depth exploration of database administrator duties and responsibilities in the Snowflake AI Data Cloud. This course covers data loading performance, security, role hierarchy design, and performance tuning. The course consists of lectures, labs, demonstrations, and discussions.

What are the objectives of Administering Snowflake Training ?

  • Identify the various aspects of Snowflake compute and storage management.
  • Definethe administrative tasks performed in support of the Snowflake AI Data Cloud.
  • Apply Snowflake’s recommended best practices and considerations for managing load operations
  • and performance.
  • DescribedatagovernanceinSnowflake, including column‐level data security using secure views and
  • dynamic data masking features.
  • Explain the data definition language (DDL) operations that work with fundamental database objects.
  • Apply strategies for Snowflake performance‐tuning.
  • Design and develop secure access to objects in Snowflake with Role‐based Access Control (RBAC).
  • Utilize Snowflake’s recommended management, monitoring, and optimization best practices.

Who is Administering Snowflake Training for?

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

What are the prerequisites for Administering Snowflake Training?

  • Recommended completion of the “Snowflake Multi‐Factor Authentication (MFA) Essentials” free
  • on‐demand course.
  • Completion of “Snowflake Foundations” one‐day course or equivalent Snowflake knowledge.
  • Abackground in database administration or management is required.

Available Training Modes

Live Online Training

Course Outline Expand All

Expand All

  • Overview
  • Access
  • Authentication
  • Programmatic Access Token (PAT)
  • Key‐Pair Authentication
  • Whatis an Integration?
  • Security Integrations
  • Security Best Practices
  • Trust Center
  • Users and Roles
  • Types of Roles
  • Using and Showing Grants
  • Ownership
  • User Management Overview
  • Password Policies
  • Managing Session Policies
  • Account Structure
  • Set Account Parameters
  • Virtual Warehouse Scaling
  • Objects
  • Tables
  • Constraints
  • Views
  • Using the Result_Scan Function
  • System Functions
  • External Tables
  • Dynamic Tables
  • Dynamic Table Advantages
  • Monitoring Dynamic Tables
  • Data Loading Overview
  • Bulk Loading
  • Error Handling
  • Fixing Load Failures
  • Loading Data Using the Web Interface
  • Continuous Loading with Snowpipe
  • Unloading Data
  • Storage Integrations
  • Notification Integrations
  • Loading Semi‐structured Data
  • Querying Semi‐structured Data
  • SchemaInference
  • SchemaEvolution
  • Tasks Overview
  • Creating Tasks
  • Managing Tasks
  • Get_Query_Operator_Stats
  • Writing Efficient Queries
  • Join Elimination
  • Transaction Concurrency Goals
  • System’s Point of View
  • Monitoring and Management Functions
  • Data Governance and Snowflake
  • Classification and Tagging
  • RowAccess Policies
  • Masking Policies
  • Context Functions
  • Auditing Access History
  • Access History and Column Lineage
  • Snowsight Data Governance Dashboard

Who is the instructor for this training?

The trainer for this Administering Snowflake Training has extensive experience in this domain, including years of experience training & mentoring professionals.

Reviews