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
** 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
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
For More Details visit – www.Instrovate.com
