Administering Snowflake Training

Price
$3,000.00 USD

Duration
3 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

Request More Information
Download Course Details
Course Details Only
Course Details & Schedule
Skip to Class Dates

Course Overview

This three-day, role-specific course provides an in-depth exploration of database administrator duties and responsibilities in the Snowflake AI Data Cloud. This course covers data loading performance, security, role hierarchy design, and performance tuning. The course consists of lectures, labs, demonstrations, and discussions.

Course Objectives

  • Identify the various aspects of Snowflake compute and storage management.
  • Define the administrative tasks performed in support of the Snowflake AI Data Cloud.
  • Apply Snowflake’s recommended best practices and considerations for managing load operations and performance.
  • Describe data governance in Snowflake, including column-level data security using secure views and dynamic data masking features.
  • Explain the data definition language (DDL) operations that work with fundamental database objects.
  • Apply strategies for Snowflake performance-tuning.
  • Design and develop secure access to objects in Snowflake with Role-based Access Control (RBAC).
  • Utilize Snowflake’s recommended management, monitoring, and optimization best practices.

Who Should Attend?

  • Database Administrators
  • System Administrators
  • Database Architects
  • Data Engineers
  • Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
  • Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
  • Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
  • Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
  • Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
  • Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

Course Prerequisites

  • A background in database administration or management is required.
  • Completion of “Snowflake Foundations” one-day course or equivalent Snowflake knowledge.

Agenda

1 - Snowflake Administration

2 - Clients, Connectors, and Ecosystems

  • Clients and Interfaces
  • SnowSQL

3 - Managing Security

  • Overview
  • Access
  • Authentication
  • Key-Pair Authentication
  • What is an Integration?
  • Security Integrations
  • Security Best Practices
  • Trust Center

4 - Managing Roles

  • Users and Roles
  • Types of Roles
  • Using and Showing Grants
  • Ownership

5 - Managing Users

  • User Management Overview
  • Password Policies
  • Managing Session Policies

6 - Snowflake Environment

  • Account Structure
  • Set Account Parameters
  • Virtual Warehouse Scaling

7 - Database Objects and Commands

  • Objects
  • Tables
  • Constraints
  • Views
  • Using the Result_Scan Function
  • System Functions
  • External Tables
  • Dynamic Tables
  • Dynamic Table Advantages
  • Monitoring Dynamic Tables

8 - Managing Data Ingestion

  • Data Loading Overview
  • Bulk Loading
  • Error Handling
  • Fixing Load Failures
  • Loading Data Using the Web Interface
  • Continuous Loading with Snowpipe
  • Unloading Data
  • Storage Integrations
  • Notification Integrations

9 - Work with Semi-structured Data

  • Loading Semi-structured Data
  • Querying Semi-structured Data

10 - Working with Unstructured Data

11 - Schema Inference and Evolution

  • Schema Inference
  • Schema Evolution

12 - Tasks

  • Tasks Overview
  • Creating Tasks
  • Managing Tasks

13 – Streams

14 - Managing Query Performance

  • Get_Query_Operator_Status
  • Writing E icient Queries
  • Join Elimination

15 - Data Manipulation Language (DML) and Transaction Concurrency

  • Transaction Concurrency Goals
  • System’s Point of View
  • Monitoring and Management Functions

16 - Managing Data Governance

  • Data Governance and Snowflake
  • Classification and Tagging
  • Row Access Policies
  • Masking Policies
  • Context Functions
  • Auditing Access History
  • Access History and Column Lineage
  • Snowsight Data Governance Dashboard
 

Get in touch to schedule training for your team
We can enroll multiple students in an upcoming class or schedule a dedicated private training event designed to meet your organization’s needs.

CourseID: 3606101E
 



Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
Contact Us about Starting Your Business Training Strategy with New Horizons