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.

How can we help you?

Thanks for sharing your details. Our team will get in touch with you soon.
There was an error trying to send your message. Please try again later.

Enquire


  • CloudLabs

  • Projects

  • Assignments

  • 24x7 Support

  • Lifetime Access

Snowflake

Overview

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

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

Prerequisites

Previous Data Warehouse knowledge is assumed

Course Outline

Snowflake Architecture and Overview2021-06-28T13:53:50+05:30

  • Snowflake Technical Overview
  • Cloud Services Layer
  • Compute Layer
  • Storage Layer
Data Movement2021-06-28T13:55:18+05:30

  • Data Loading
  • Unloading
  • Best Practices
Snowflake Objects & Commands2021-06-28T13:55:32+05:30

  • Query Constructs
  • Data Description Language (DDL)
  • Data Manipulation Language (DML)
Snowflake SQL Support for Data Analysis2021-06-28T13:55:52+05:30

  • SQL Support and Query Best Practices
  • SQL Analytic Functions
  • High Performing Estimation Functions
  • UDF and Stored Procedure
  • Demo Query Profile
Managing Security2021-06-28T13:56:07+05:30

  • Data Encryption
  • Authentication
  • Role-Based Access Control
Semi-structured Data2021-06-28T13:59:15+05:30

  • Capabilities and Best Practices for working with semi-structured data in Snowflake
Caching2021-06-28T13:59:27+05:30

  • Caching Features in Snowflake
  • Best Practices of using caching for performance and cost optimization
Snowflake Clients and Ecosystem2021-06-28T13:59:39+05:30

  • Snowflake Clients and Connectors Overview
  • SnowSQL – Snowflake CLI
Continuous Data Protection2021-06-28T13:59:57+05:30

  • Time Travel in Snowflake
  • Cloning in Snowflake
Data Sharing2021-06-28T14:00:05+05:30

  • Snowflake Data Sharing Overview
Performance & Concurrency2021-06-28T14:00:42+05:30

  • Query Profile
  • Micro-Partitions & Data Clustering
  • Scaling a Virtual Warehouse
Account and Resource Management and Monitoring2021-06-28T14:01:17+05:30

  • System Resource Usage and Billing
  • Managing Virtual Warehouses
  • Workload independence and segmentation
  • Monitoring Tool: Resource Monitors
  • Monitoring Tools: Information Schema and Account Usage
2023-01-06T15:27:38+05:30

Testimonials

I recently attended the AWS Security Training with edForce and had a great first-hand experience. The trainer Anurag, and facilitator Ashutosh, both delivered the content effectively, ensuring that I thoroughly understood the concepts. The training tools and materials were comprehensive and effective in helping me grasp the content. I am looking forward to attending additional trainings with edForce to continue improving my professional knowledge. – Lavkesh Jain

I have attended a session regarding Docker and Kubernetes with edForce. It was a very good experience. In a short duration of session, instructor explained almost every detail about the topics to at least start with that tech stack. I am looking forward for more session with edForce in future. – Digvijay Singh Parmar

Michelin, client of edForce
Digijay sign parmar saying ghreat things about edForce training and session

I have attended few AWS sessions conducted by edForce. Trainers have always been knowledgeable, they covered concepts starting from basics of AWS. The presentations of topics are always very good and in nutshell I found the sessions were very helpful. Thanks you!! – Vinoth Shanmugam

Vinoth Sai who attended Docker and Kubernetes session by edForce

About Us

Upskill Your Workforce

Work With Us

Work With Us

+91 9945 531 611
+1 (650) 533-3312

ISO 9001:2015 & ISO 10004:2018 Certified Company

Copyright © edForce. All Rights Reserved.

Terms of Use | Privacy Policy

Copyright © edForce. All Rights Reserved.

Terms of Use | Privacy Policy

Copyright © edForce. All Rights Reserved.

Terms of Use | Privacy Policy

Disclaimer
  • PMP, PMI are registered marks of the Project Management Institute, Inc.
  • Certified ScrumMaster® (CSM) and Certified Scrum Trainer® (CST) are registered trademarks of SCRUM ALLIANCE®
  • ITIL® is a registered trademark of AXELOS Limited.
  • Professional Scrum Master is a registered trademark of Scrum.org
  • Java is the registered trademarks of Oracle and/or its affiliates
  • Azure is a registered trademark of Microsoft Corporation.

  • Power BI is a registered trademark of Microsoft Corporation.

close-link
close-link
Go to Top