Snowflake Training

Snowflake Training

Course Duration:

30-40 hours,

Free - Demo Training available for interested students

Course Content:

• What is Snowflake?

Snowflake Architecture (Services Layer and Compute Layer)

• Snowflake Architecture (Storage Layer) Life cycle of a query

Snowflake editions

• Snowflake regions

Creating account in Snowflake Snowflake account overview

• Loading sql scripts to Snowflake Creating a database

Creating a warehouse

• SnowSQL installation

Establishing connection to Snowflake through SnowSQL Snowsight

• Cahing in Snowflake

-Metadata cache

-Result cache

-Data cache

Life cycle of a query

• Types of tables Types of views

• Query Tags Explain function Data loading

• Data unloading Tasks

Snowflake functions

• User defined functions Stored procedures

Difference between user defined functions and stored procedures

• Security

-Access

-Authentication

-Authorization

-Data Protection

-Infrastructure

• Access control in Snowflake System defined roles Custom roles

• Working with semi-structured data

• Cloning Time Travel Failsafe

• Database Replication

Snowflake Data Sharing

-Producers

-Consumers

-Reader accounts

Product offerings for secure data share

• SQL Performance Tips Resolving Pruning Issues Virtual Warehouse Scaling

• Controlling Costs Resource Monitors INFORMATION_SCHEMA ACCOUNT_USAGE

• Integrating Snowflake with Tableau for creating reports

• Preview features Snowflake Quiz

• SnowPro Certification resources and tips Snowflake Interview Preparation