About Snowflake Training
Course Syllabus

Snowflake data cloud platform acts as a software-as-a-service (SaaS) for all your data storage, data processing, logical solution and mobilizes your data to advance your business. Through this Snowflake course, you can gain knowledge about areas like Snowflake architecture, cloning, data sharing, data streaming, loading unstructured data, and much more.

We offer the best Snowflake Online Training, where our real-time trainer will help you gain in-depth knowledge about the Snowflake data by covering all important areas. With Snowflake Online Training, the participants can easily revise and recap the training sessions at their own time and convenience.

Version IT training institute is the best online training institute in Hyderabad. Our highest teaching standards reflect the high-quality training provided by our institute, which helps in a successful future and benefits one’s career in the long term. So, no need to step out. Learn the course from the comfort of your home. Make a huge shift in your career by joining our Snowflake Online Training. Call us now to know more!

Basic SQL knowledge and understanding Datawarehouse, if required need to attend additional classes

1.Snowflake Architecture and Overview

  • Snowflake Overview
  • Architecture
  • How to use the Snowflake UI & ecosystem

2.Introduction to Cloud

  • What is Cloud
  • Different Cloud Vendors
  • Advantages of Cloud over On-Premise

3.Introduction Data Warehousing Concepts

  • What is a Data Warehouse and Why do we need Data Warehouse?
  • Database Vs Data Warehouse
  • Data Warehouse Architecture
  • OLTP Vs OLAP
  • What is ETL

4.Introduction to Snowflake

  • How different from traditional DB
  • Quick start to the snowflake and accessing trial account
  • Creating warehouse, DB, Schema, and tables
  • Accessing different roles and using it
  • Working with worksheets
  • Understanding different type of accounts

5.Understand Cloud platforms

  • AWS and understanding S3 storage
  • Snowflake architecture and caching
  • AZURE and understanding blob storage
  • GCP and understanding Bucket storage

6.Data Loading and Unloading

  • File formats
  • Internal and external storage
  • Internal and external stage
  • Copy into usage
  • Snowflake internal storage
  • Accessing Cloud storage data into Snowflake (GCP, AZURE and AWS)
  • Data unloading

7. SnowPipe

  • Accessing Snowpipe
  • PUT and GET commands
  • Bulk loading from cloud storage
  • Continuous loading

8. Partner connect with snowflake

  • Snowflake Connector and use cases Python
  • BI connectors use cases
  • Other connectors hands-on

9. Handling JSON and Semi structure data

  • Variant Datatype
  • File format options
  • Creating stages
  • Loading JSON semi-structured data into SF tables
  • Accessing JSON with select statement

10. Scheduling with Snowflake

  • Creating Tasks
  • Streams
  • Accessing procedures with tasks
  • Scheduling as per time with Different time zones
  • Automate loading process Daily and Weekly

11. Secure Data sharing

  • Usage of sharing data
  • Sharing data with different accounts
  • Sharing data with non-SF accounts using reader accounts
  • Importance of reader accounts
  • Privileges in data sharing
  • Challenges with cross-region sharing and understanding replication
  • Connecting shared objects with BI tools
  • Limitations with Data sharing

12. Cloning

  • Access Control Privileges for Cloned Objects
  • Cloning and Snowflake Objects
  • Impact of DDL on Cloning
  • Impact of DML and Data Retention on Cloning

13. Time travel &Failsafe

  • Introduction to Time Travel
  • Querying Historical Data
  • Enabling and Disabling Time Travel
  • Data Retention Period
  • Cloning Using Time Travel (Databases, Schemas, and Tables Only)

14. Query Caching, Clustering, and Performance techniques

  • Creating multi-users on large tables
  • Performance techniques
  • Result set cache
  • Metadata cache
  • Query data cache
  • Best practices of using caching for performance and cost optimization

Fill the form and get 10% discount