Description

SNOWFLAKE DATABASE ADMINISTRATORi3-day role specific course covers an in-depth look at what a database administrator manages in the Snowflake Platform. Such as data loading performance, designing a role hierarchy, agile development, and advanced performance tuning. This course will consist of lecture, labs and discussions.

 

Radiant Techlearning offers “SNOWFLAKE DATABASE ADMINISTRATOR” training program in Classroom & Virtual Instructor Led / Online mode.

 

 

Duration: 3 days

 

 

Learning 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

Pre-requisites

  • A background in database administration or management is required

 

Audience Profile

  • Data Engineers
  • Database Architects

Database Administrators

Course Details

Module 1: Snowflake Architecture and Overview

  • Snowflake Technical Overview
  • Overview of three-tiered architecture

Module 2: Compute Management

  • Scaling Virtual Warehouses Up & Out
  • Creating and managing Virtual Warehouses

Module 3: Snowflake Objects & Commands

  • Built-in design and comparison to traditional SQL commands
  • DDL commands to work with different database objects
  • Different functions and operators available in Snowflake
  • Account, Session, & Object Parameters
  • Single and Multiple Accounts

Module 4: Load Operations & Performance Management

  • Load operation performance
  • Data Unloading

Module 5: DML & Transaction Model

  • Snowflake DML Commands
  • SQL statements for transactions in Snowflake
  • DML and clustering impact on table versioning

Module 6: Back-up, Restore & Snapshot

  • Time Travel
  • Zero-copy cloning
  • Agile Development use cases

Module 7: Storage Management

  • Table Design Considerations
  • DML and Cloning Considerations
  • Storage Optimization

Module 8: Performance Methodology & Management

  • Query Profile Analysis
  • Query Best Practices
  • Caching
  • Troubleshooting Tools & Tuning Performance Metrics
  • Data Clustering
  • Materialized Views

Module 9: Role-based Access & Design

  • System roles & custom roles
  • Role Hierarchy
  • Best practices

Module 10: Account & Resource Monitoring

  • Creating Resource Monitors
  • Monitoring Compute, Storage and Credits
  • Database object types and storage considerations

Module 11: Data Sharing

  • Data Sharing overview
  • Secured View
  • Secured UDF

FAQs

Category:

Unble To Find a Batch..?

Request a Batch