Administering Snowflake Training

News
NEW ADVANCED CERTIFICATION AVAILABLE ➤  Learn more about the SnowPro Advanced: Architect exam.   NEW PERFORMANCE AUTOMATION & TUNING COURSE ➤  Learn more and sign up for the first public instructor-led class!   COMPLETE YOUR SNOWPRO CORE CERT. PREP WITH OUR ON-DEMAND PREPARATION COURSE➤   Learn more!   COVID-19 UPDATES ➤   Instructor-led classes will be delivered via virtual classroom only.  

Administering Snowflake Training

Administering Snowflake Training

Summary

This 3-day role specific course (*formerly named DBA Training) 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.

Duration

3 Days

Objectives

By the end of this class you will be able to:

  • 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

Audience

Who should attend this course?

  • Data Engineers
  • Database Architects
  • Database Administrators

Prerequisites

A background in database administration or management is required.

Setup Requirements

Snowflake Training students need...

  • to bring a laptop
  • a Snowflake compatible browser (see options HERE)
  • permissions to install software on your computer  (**Students will install SnowSQL IN CLASS with the instructor if required.)

Outline

Upcoming Classes

Online

Instructor-led online training

Location Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 Jun 2021 Jul 2021 Aug 2021 Sep 2021 Oct 2021 Nov 2021 Dec 2021 Jan 2022
Virtual Classroom (AMER/CT) Feb 3 – Feb 5
Mar 10 – Mar 12
Apr 14 – Apr 16
Virtual Classroom (EMEA/GMT) Mar 17 – Mar 19

Already enrolled in an Instructor-Led class or paid On-Demand course? Log in to your Learner Dashboard.