In this Snowflake fundamentals training module, trainees will learn how the Snowflake database is different from other conventional databases like Oracle, MS SQL and how to work with the Snowflake platform. Along with this, our industry experts will teach you how to create warehouses, schema, how to access different roles, and how to work with worksheets, and understand different kinds of accounts.

• How different from traditional DB like (Oracle ...)  
• Quick start to 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

Learning outcomes: By the end of this module, you will know the importance of snowflake, and you will get a real-time experience of working with the snowflake platform 
 

In this Snowflake virtual classroom training module, you will learn how to do bulk loading into Snowflake through AWS S3, Azure Blob Storage, and GCP Bucket storage. Along with this, you will study Snowflake Architecture and caching in the Snowflake data warehouse.

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

Learning Outcomes: At the end of this module, you will get a real-time experience of using AWS S3 Storage, Azure Blob Storage, and GCP Bucket Storage in the Snowflake Data warehouse platform. You will also acquire an in-depth understanding of Snowflake Architecture and Caching.
 

This Snowflake Online training module will provide you with a detailed look at Data loading/Unloading file formats, storing the data internally and externally, and using the COPY INTO command. You will also learn how to access Snowflake internal and cloud storage and how to carry out data 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

Learning Outcomes: Upon completing this module, you will gain a practical understanding of Data Loading and Unloading. Also, you will know how to access Snowflake’s internal storage and cloud storage.
 

In this module you'll learn detailed overview of Snowpipe, Continuous loading, Bulk loading, and Commands like PUT, GET.

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

Learning Outcomes: By the end of this module, you will be able to work with Snowpipe and perform continuous loading and bulk loading in it.
 

In this module, you will learn the use cases of Snowflake python connector and BI Connectors. Also, you will be familiar with other Snowflake connectors.

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

Learning Outcomes: At the end of this module, you will get a real-time experience of the Snowflake python connector and other Snowflake connectors.
 

This Snowflake module helps you master the concepts like variant data type, file format options, and creating stages. You will also learn how to load the semi-structured data and how to access JSON files through the “select” statement.

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

Learning Outcomes: Upon completing this module, you will be able to use a variant data type for storing the data and use different types of files to handle semi-structured data. Along with this, you will get a deep understanding of loading the semi-structured data and accessing the JSON file.
 

This module deals with Snowflake scheduling concepts like creating tasks, streams, and accessing procedures with the tasks. Also, you will learn how to schedule the tasks and how to automate the loading process regularly.

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

Learning Outcomes: By the end of this module, you will acquire practical knowledge of creating the tasks and streams, scheduling the tasks, and automating the loading process.  
 

In this Snowflake database training module discusses the importance of data sharing in the Snowflake cloud platform, how to share data with Snowflake and Non-Snowflake accounts. It also deals with data sharing privileges, connecting shared objects with BI tools, challenges, and data sharing limitations.

• 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 like POWER BI  
• Limitations with Data sharing

Learning Outcomes:  At the end of this module, you will be able to share the data in different ways, and you will be familiar with the security measures required for sharing the data.
 

The Cloning in Snowflake module provides you with a detailed look at how to control the accessing of cloned objects and what is the impact of DDL, DML, and Data Retention on Cloning.

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

Learning Outcomes: By the end of this module, you will get extensive knowledge of accessing the cloned objects, cloning snowflake objects, pipes, streams, and tasks. Along with this, you will also achieve practical knowledge of how DDL, DML, and Data retention impact cloning.
 

In this module, you will learn how to retrieve historical data, enable or disable time travel. You will also study the data retention period and cloning through time travel.

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

Learning Outcomes: At the end of this module, you will acquire a real-time experience of using time travel for querying historical data and performing cloning.
 

This module discusses topics like creating multi clusters on large tables and performance techniques in Snowflake database.

• Creating multi clusters on large tables  
• Performance techniques

Learning Outcomes: At the end of this module,  you will be able to create multi clusters and use performance techniques to improve the performance of the Snowflake data warehouse.
 

Mindmajix offers advanced Snowflake interview questions and answers along with Snowflake resume samples. Take a free sample practice test before appearing in the certification to improve your chances of scoring high.