Snowflake DBA Training

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 Feb 2020 Mar 2020 Apr 2020 May 2020 Jun 2020 Jul 2020 Aug 2020 Sep 2020 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021
Virtual Classroom (AMER) Feb 25 – Feb 27
Apr 7 – Apr 9

Onsite Training

For groups of 8 or more, we recommend booking a Private Training class and our instructor will come to your location! Simply click the button below and fill out the private training request form. A representative will contact you as soon as possible.

Request Quote

Public Training

Virtual Classroom (AMER)

Classes marked with Confirmed are confirmed to run. Sign up now while there is still space available!


Don't see a date that works for you?

Request Class