Snowflake Fundamentals

Who Should Attend?

Data Analysts, Data Engineers, Data Scientists, Database Architects, Database Administrators

}
Duration: 2 Days

This 2-day course covers the fundamental concepts, design considerations, and best practices intended for key stakeholders who will be working on the Snowflake Cloud Data Platform. The course will consist of lecture and demos only on a wide range of foundational topics.

  • Illustrate the unique and differentiated architecture of the Snowflake Cloud Data Platform
  • Load and transform data
  • Evaluate Query Constructs and DDL & DML Operations
  • Review Snowflakes broad SQL support for data analysis
  • Describe how user and application access can be easily managed
  • Demonstrate best practices for working with semi-structured data
  • Discuss how Snowflake provides a unique approach to caching Examine the various ways to connect and interact with the Snowflake Platform
  • Employ Snowflake’s method for continuous data protection
  • Utilize Data Sharing to send your data in real-time to Customers and Partners
  • Scale your Virtual Warehouse for performance and concurrency
  • Explain the different ways you can manage and monitor your Snowflake account

Pre-requisite

Previous Data Warehouse knowledge is assumed.

1. Snowflake Architecture and Overview

  • Snowflake Technical Overview
  • Cloud Services Layer
  • Compute Layer
  • Storage Layer

2. Data Movement

  • Data Loading
  • Unloading
  • Best Practices

3. Snowflake Objects & Commands

  • Query Constructs
  • Data Description Language (DDL)
  • Data Manipulation Language (DML)

4. Snowflake SQL Support for Data Analysis

  • SQL Support and Query Best Practices
  • SQL Analytic Functions
  • High Performing Estimation Functions
  • UDF and Stored Procedure
  • Demo Query Profile

5. Managing Security

  • Data Encryption
  • Authentication
  • Role-Based Access Control

6. Semi-structured Data

  • Capabilities and Best Practices for working with semi-structured data in Snowflake

7. Caching

  • Caching Features in Snowflake
  • Best Practices of using caching for performance and cost optimization

8. Snowflake Clients and Ecosystem

  • Snowflake Clients and Connectors Overview
  • SnowSQL – Snowflake CLI

    9. Continuous Data Protection

    • Time Travel in Snowflake
    • Cloning in Snowflake

    10. Data Sharing

    • Snowflake Data Sharing Overview

    11. Data Sharing

    • Snowflake Data Sharing Overview

    12. Performance & Concurrency

    • Query Profile
    • Micro-partitions & Data Clustering
    • Scaling a Virtual Warehouse

    13. Account and Resource Management and Monitoring

    • System Resource Usage and Billing
    • Managing Virtual Warehouses
    • Workload independence and segmentation
    • Monitoring Tool: Resource Monitors
    • Monitoring Tools: Information Schema and Account Usage

    Register Now

    Drop us your entry if you are interested to join this course.

    This field is for validation purposes and should be left unchanged.