Highlights

• Instructor Based Live Online Course with Step by Step Guidance
• Get Ready For SnowPro Certification Training
• Learn from industry expert and Snow Pro Certified Trainer
• SnowPro Certification Guidelines
• Study Guide ,notes and sample questions
• Tips to crack the certification in first attempt
• All sessions go along with Hands on Demo
• Knowledge check quiz after each topic
• Learn the In High Demand Skill of Cloud Data Platform and Architecture
• Participant focused learning with small batches and interactive session
• Q&A Session
• Resume Highlights
• Interview Questions and Answers
• Project for Final Assessment
• Review of project and submission details
• Q&A- related to project

Course Content

INTRODUCTION TO CLOUD DATA WAREHOUSE

• Understanding Cloud data warehouse
• On Premise vs On Cloud
• Introduction to Data Warehousing and Key concepts
• Benefits of a Cloud Data warehouse

INTRODUCTION TO SNOWFLAKE

• Snowflake:  History & Popularity
• Architecture  : Data Storage , Processing and cloud services
• Supported cloud platforms
• Snowflake Editions
• Overview of Data LifeCycle
• Continuous Data Protection

GETTING STARTED WITH SNOWFLAKE                                                                  

• Understanding each component Snowflake web interface

• Key concepts for using Snowflake and Data Warehouse
• Setting up your trial account
• Hands On: Creating first Database, tables and running query
• Virtual Warehouses

CONNECTION TO SNOWFLAKE

• Overview of Ecosystem

• ODBC Driver

• Downloading the ODBC Driver
• Installing and Configuring the ODBC Driver 
• Using ODBC Driver

** Setting up ODBC Connector and using it in sample SSIS package

• JDBC Driver

• Downloading / Integrating the JDBC Driver
• Configuring the JDBC Driver
• Using the JDBC Driver

** Sample Java program using snowflake-jdbc connector .jar file

• SNOW SQL

• Installing SnowSQL
• Configuring SnowSQL
• Connecting through SnowSQL
• Using SnowSQL

• PYTHON Connector

• Installing Python Connector
• Using Python Connector
  **Sample Python program using snowflake connector for Python

LOADING DATA TO SNOWFLAKE                                                                  

• Key concepts related to data loading : Data File, File Formats, Copy command, Data Stage

• Loading using Web interface
• Bulk loading using COPY

• Bulk loading from Local File System
• Bulk Loading from External Cloud Platform

** Along with demo on setting up AWS Free Tier Account and S3 bucket and loading file from S3 Bucket

• Loading continuously using Snowpipe
• Querying Data in Staged Files
• Querying Metadata for Staged Files
• Transforming Data During a Load

UNLOADING DATA FROM SNOWFLAKE                                        

• Key concepts related to data unloading : File Formats, Copy command, Data Stage
• Unloading into SF stage
• Unloading into External Cloud Platform like S3,GCS and Azure

TIME TRAVEL, FAILSAFE & ZERO COPY CLONES                        

• Understanding & Using Time Travel
• Understanding & Viewing Fail-safe
• Zero Copy Clones

DATA SHARING IN SNOWFLAKE                                                

• Introduction to data sharing

• Overview of Data Providers and Consumers
• Readers Account
• Demo on Data Share
• Snowflake DataMarketplace
• Snowflake Data Exchange

ACCESS CONTROL

• Access Control Framework
• Securable Objects
• Roles
• System-Defined Roles
• Custom Roles
• Privileges
• Role Hierarchy and Privilege Inheritance

SNOWFLAKE USAGE AND BILLING

• Snowflake credits
• Understanding warehouse, storage and cloud service usage
• Understanding data transfer billing

PARAMETER MANAGEMENT

• Viewing Parameters for Account/Session/Object
• Altering Parameters for Account/Session/Object
• Resetting Parameters

USER MANAGEMENT

• User Roles
• Creating Users
• Resetting the Password for a User
• Disabling the Change Password Functionality for Users
• Disabling / Enabling a User
• Unlocking a User
• Viewing Users
• Dropping a User

SNOWFLAKE SQL

• DDL and DML Commands      
• Analytical Function
• String and Date functions                                 
• Sub queries

** Practice Assignment of Snowflake SQL

MANAGING SECURITY IN SNOWFLAKE

• Network Policies
• Multi-Factor Authentication (MFA)
• Federated Authentication & SSO
• Data Encryption

     Snowflake End to End Enterprise level Project Walk through 

• Detailed walk through on how to design and develop Data management Solution for real Enterprise Demo Project
• Understanding Data Model, Data flow and data pipeline
• Cloud Data Architect