Login
ILT-ADMIN

Administering Snowflake

This 3-day role specific course covers an in-depth look at what a database administrator manages in the Snowflake Cloud Data Platform. This includes data loading performance, designing a role hierarchy, agile development, and advanced performance tuning. This course will consist of lecture, labs and discussions.
Calendar
Administering Snowflake

Description

This 3-day role specific course covers an in-depth look at what a database administrator manages in the Snowflake Cloud Data Platform. This includes data loading performance, designing a role hierarchy, agile development, and advanced performance tuning. This course will consist of lecture, labs and discussions. Prerequisite Snowflake Foundations is a prerequisite for this course. The prerequisite is estimated to take about 5 hours to complete. If you have previously completed Snowflake Fundamentals, Data Engineer, Data Science, or Administering Snowflake you do not have to take the Foundations prerequisite course. Questions? Submit a Case

Objectives

View the COURSE DATASHEET
  • Identify the various aspects of compute and storage management
  • Illustrate the detailed architecture of Snowflake for administrative tasks
  • Review best practices & considerations for managing load operations and performance
  • Describe the DDL operations that work with the fundamental database objects
  • Discuss transaction and concurrency model and DML considerations
  • Employ recovery methods and agile development with Time Travel & Cloning Use the snowflake methodology for advanced techniques for performance tuning
  • Design and develop secured access to objects in snowflake with role-based access control Recommend the best practices for management, monitoring & optimization
  • Share data in or outside of your organization securely

Prerequisites

  • A background in database administration or management is required.
  • Snowflake Foundations On-Demand (estimated to take 5 hours to complete)

Setup Requirements

  • to bring a laptop
  • a Snowflake compatible browser (see options HERE)

Audience

  • Data Engineers
  • Database Architects
  • Database Administrators

Learning Tracks

Snowflake Learning Journey

You know what you’re looking for, and we have curated paths to help you achieve whatever your learning goals. From skill building badges, to preparation for the SnowPro core certifications we have you covered.
Explore Learning Tracks
Snowflake Logo

Snowflake Education Services includes Instructor-Led Training, SnowPro Certifications, and this online, on-demand educational courses website. Our on-demand courses are branded as "Snowflake University." Snowflake University (aka Uni) offers a badge program called Hands-On Essentials as well as other courses.

©2023 Snowflake Inc. All Rights Reserved