Kalyan V.

I am a Software engineer with 15 yrs of experience in IT field. I am giving online snowflake training covering all topics along with hands on lab sessions and will share the detailed prepared material of all topics and lab session related sql queries/scripts. Below are the topics will be covered as part of training.

If you are interested for taking snowflake snopro training, will provide very good guidance with additional charge.

Topics :-

• Quick review of RDBMS
• Snowflake Architecture
• Recap on Architecture
• Snowflake Environment Setup (Hands-on)
• Virtual warehouse (Hands-on & More details about credits consumption and sizes)
• Snowflake under the hood
-Caching in snowflake data warehouse
-Clustering in snowflake
• Performance Tuning and DB characteristics (v02)
• Install AWS CLI, Snow CLI
• Loading data in snowflake
• Loading data using internal staging
o Table stage
o Named stage
o Load using Snowsql (CLI)
• Loading data from AWS S3 to Snowflake
o Load using snowflake console (Low volume load)
o Load using AWS CLI (Bulk Load)
• Snow Pipe
• Copy options (Deep Dive)
o Validation Mode
o Load Selected files
o ON_ERROR
o ENFORCE_LENGTH & TRUNCATE COLUMNS
o FORCE
o PURGE
o LOAD HISTROY VIEW AND COPY HISTORY FUNCTION
• Loading unstructured data
o Method 1
o Method 2
o Method 3
• Data sharing in snowflake
o Normal and Secure Views
• Time Travel in Snowflake
• Failsafe in snowflake
o Sub Topics
 Access failsafe from console
 Relation between failsafe and retention period
 Table types in snowflake
 Permanent table and failsafe
 Transient table
 Temporary table
 Creating Transient database in snowflake

• Clone Feature in snowflake
• Table Swap in snowflake
• Data Sampling in snowflake
• Scheduling in snowflake – TASKS
• Streaming in snowflake
• Continuous Data Load in snowflake
• Materialized Views
o Importance using MV