Muftasoft TM

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

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.