Snowflake

Live Online (VILT) & Classroom Corporate Training Course

Snowflake is cloud based data warehouse and analytical tool. With so many SAAS based Data warehouse applications available currently that are competing against one another, Snowflake stands out among the crowd for it uniqueness in design and approach.
Snowflake Logo

How can we help you?

  • CloudLabs
    CloudLabs
  • Projects
    Projects
  • Assignments
    Assignments
  • 24x7 Support
    24x7 Support
  • Lifetime Access
    Lifetime Access
Box

Overview

This course covers the fundamental concepts, design considerations, and best practices intended for key stakeholders who will be working on the Snowflake Platform.

Box

Objectives

At the end of Snowflake training course, participants will be able to

  • Illustrate the unique and differentiated architecture of the Snowflake 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 Snowflakes 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
Box

Prerequisites

Previous Data Warehouse knowledge is assumed

Box

Course Outline

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

  • Data Loading
  • Unloading
  • Best Practices

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

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

  • Data Encryption
  • Authentication
  • Role-Based Access Control

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

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

  • Snowflake Clients and Connectors Overview
  • SnowSQL – Snowflake CLI

  • Time Travel in Snowflake
  • Cloning in Snowflake

  • Snowflake Data Sharing Overview

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

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

Testimonials

Shamsudeen Bawa

Synergific Software Team has been very supportive, and working with them has been a best decision that we could ever made, They are just a call away. You guys are AWESOME, Thank You, Keep up the Good Work!!!

Shamsudeen Bawa

Vice President, J.P Morgan, CIS, USA

Farhan Hafiz

Synergific Software has been of great help and I plan to continue to use your services in the future for my business needs.

Farhan Hafiz

Data Architect, Fiserv

Dr. Sahdev Singh

I think Synergific Software is great. I liked that it was hassle free and easy to set up. Again, it's a great feature for a fast and cheap set up, which gives me peace of mind, as I know have a terms of use agreement.

Dr. Sahdev Singh

Under Secretary, Ministry of Law & Justice, Govt. of India

M Chikanna Swamy

I liked using Synergific Software very much. I thought the website was easy to navigate and the instructions for generating the terms was clear. I even recommended you on a Facebook Group I am a member of.

M Chikanna Swamy

Director & Learning Head, Mindtree