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