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