Snowflake DBA 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!   COVID-19 UPDATES ➤   Instructor-led classes will be delivered via virtual classroom only.  

Snowflake DBA Training

Snowflake DBA Training

Summary

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.

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

View and download the DBA Course Datasheet.

Upcoming Classes

Online

Instructor-led online training

Location Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 Jun 2021 Jul 2021 Aug 2021
Virtual Classroom (AMER/CT) Aug 25 – Aug 27
Oct 13 – Oct 15
Virtual Classroom (EMEA/GMT) Sep 16 – Sep 18

Already enrolled in an instructor-led class? Log in to your Learner Dashboard.