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!   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.  

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 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 Jun 2021 Jul 2021 Aug 2021 Sep 2021 Oct 2021
Virtual Classroom (AMER/CT) Nov 10 – Nov 12
Dec 9 – Dec 11
Jan 13 – Jan 15
Virtual Classroom (EMEA/GMT) Nov 18 – Nov 20

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