Snowflake Course Overview

Snowflake is referred to as a cloud based data warehousing system which helps in delivering advanced solutions to the functionalities like storing, handling and data analysis. It is completely different from the other offerings and includes some of the special characteristics like versatility, high speed, etc. Through Snowflake, one can also customize and create the ready to query tables with less costs or zero administration costs.

HKR trainings is offering the best Snowflake online training to provide their esteemed guidance and support through the advanced level of training from the expert trainers. Moreover, the candidate will learn all the concepts from beginner level to a professional level which includes building the snowflake applications, debugging, managing and maintaining the applications, gain understanding on the user interfaces, learning and implementing the processes on real-time projects. This ultimately will help in enhancing the candidate skill set. This is the right time to learn and enhance the career opportunities through the Snowflake certification training. Snowflake Course Content

The expert professionals at HKR trainings designed the Snowflake training curriculum and divided it into two sections, namely Snowflake administrator and Snowflake developer. You can find the complete information in the module below mentioned module.

Now let's start exploring each module in a more detailed way. Module1: Snowflake architecture

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

Module2: Cloud overview

  Introduction to cloud
  Different cloud vendors
  Advantages of cloud over on premises 

Module3: Data warehousing

  What is data warehousing
  Why data warehousing?
  Data Warehouse architecture
  OLTP vs OLAP
  ETL overview 

Module4: 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 

Module5: Understanding the cloud platforms

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

Module6: data loading and unloading

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

Module7: Snowpipe

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

Module8: Partner connect with snowflake

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

Module9: HAndling JSOn and semi structured data

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

Module10: Scheduling with snowflake

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

Module 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 

Module12: Cloning

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

Module13: Time travel and failsafe

  Introduction to Time Travel
  Querying Historical Data
  Enabling and Disabling Time Travel
  Data Retention Period
  Cloning Using Time Travel 

Module14: query caching 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 

Module15: Advanced topics

  Error Handling and Validations
  Snowflake Pricing model
  Selecting best Edition and Calculation of Credits usage
  Resource Monitoring
  Data Masking
  Partitioning and Clustering in snowflake
  Materialized View and Normal View
  Integration with Python
  Integration with AWS, Azure and Google Cloud
  Best Practices to follow 

Module 16: Practice test and interview questions

At HKR trainings, we provide practice tests at the end of the course , community question and answers, also Snowflake interview question and answers , Snowflake tutorial and Sample Resumes to crack the interview. Practice Mock Interview Sessions and Technical Job Support We at HKR trainings provide the learners with practice Mock Interview Sessions and excellent Job Support at the end of the course.