*Trademarks & Logos are owned by Snowflake
About Snowflake :
  • Snowflake is a Cloud-based Data-Warehousing platform that offers advanced solutions for Organizational Data Storage, Processing and Analytical Needs
  • Snowflake is the Trending Platform used by thousands of Companies globally
  • Snowflake Enables Most Critical Data Workloads in large Corporations
Training Schedule
Training Objective :
  • Master fundamental Snowflake Concepts
  • Acquire Skills to implement Snowflake based Solutions
  • This Course will prepare you to take up SnowPro Core Certification
  • Makes you Job-Ready to use Snowflake Tech Stack
Training Pre-requisites :
  • Any Degree or Diploma
  • Familiarity with SQL
Training Description :
  • This training provides Snowflake concepts & hands on expertise to help get you started on implementing solutions using Snowflake.
  • This training reinforces the learning through hands on labs, assignments and quizzes
Lab Sessions :
  • Get access to Test Drive Snowflake for 30 days
  • Use the Test Drive for your Lab Assignments
Detailed Course Content & Syllabus
Topics
Section 1 : Introduction
  • Introduction
  • What is a data warehouse?
  • Why cloud computing?
  • The Snowflake Story
 
Section 2 : Getting Started with Snowflake
  • Signup for Snowflake
  • Using Snowflake UI
  • Creating our first Database, Schema & Table
  • Load Data into our first table
  • Setting up Required Snowflake tools
  • Assignment : Create, Load & query a table
 
Section 3 : Snowflake Warehouse for Compute
  • Creating our first Virtual Warehouses
  • Virtual Warehouses sizes & Scalability
  • Warehouse - Maximized vs Auto Scale
  • Multi-Cluster Warehouse Scaling Policy's
  • Assignment : Creating a new Virtual Warehouse
 
Section 4 : Architecture, Features & Pricing
  • Key Concepts & Architecture
  • Supported Cloud Platforms & Regions
  • Snowflake Editions
  • Snowflake Releases
  • Snowflake Pricing
  • Data Integration
  • Quiz : Snowflake Concepts
 
Section 5 : Loading & Unloading Structured Data
  • Ingestion / Loading Methods
  • Steps to Managing Loads
  • Preparing your data
  • Staging your data
  • Loading data from an Internal stage
  • Loading data from different Internal stages
  • Loading data from External S3 stages
  • What is Snowpipe?
  • Loading data via Snowpipe - high level steps
  • Unloading of data
  • Quiz : Data Ingestion Quiz
 
Section 6 : Semi Structured Data
  • Loading and Unloading JSON data - high level steps
  • Analytics on JSON data - hands on lab
  • ORC data handling
  • Parquet data handling
  • Assignment : Load JSON data from an S3 bucket
 
Section 7 : Stage data transformations
  • Querying Data in Staged Files
  • Querying Metadata for Staged Files
  • Transforming Data During a Load
 
Section 8 : Databases, Tables & Views
  • Working with Temporary, Transient & Permanent Tables
  • Working with Externals Tables
  • Overview of Views
  • Working with Materialized Views
  • Table Design Considerations
 
Section 9 : Time Travel, Failsafe & Zero Copy Clones
  • Back to the future with Snowflake
  • Travel to a specific time or before a query
  • Assignment : Time Travel to a point in time
  • Undrop databases, schema & tables
  • Assignment : Un-drop tables, schemas & databases
  • Assignment : Test drive the time travel
  • Failsafe in Snowflake
  • Lab : View storage used by Fail-safe
  • Assignment : Understanding storage used by Fail-safe
  • Zero Copy Clone
  • Cloning with Time Travel
  • Quiz : Time Travel, Zero Copy Clones
 
Section 10 : Performance Optimization
  • Performance Optimization in Snowflake
  • Using Dedicated Virtual Warehouses
  • Multi-cluster virtual warehouse or Scaling Out
  • Maximize Cache Usage
  • Lab : Query Caching in Action
  • Clustering large tables & improve partition elimination
  • Lab : Cluster keys for large tables
  • Search Optimization
  • Quiz : Performance Optimization
 
Section 11 : Secure Data Sharing
  • Secure Data Sharing in Snowflake
  • Sharing with other Snowflake users
  • Assignment : Share a table with another Snowflake user
  • Sharing - Who's compute is used?
  • Sharing - Data always up-to date
  • What is a share?
  • Sharing with non Snowflake users
  • Lab : Sharing with non Snowflake users
  • Assignment : Share a table with non Snowflake user
  • Lab : Sharing entire schemas & databases
  • Lab : Sharing views
  • Assignment : Share a view, combining data from multiple tables
  • Quiz : Secure data sharing
 
Section 12 : Snowflake Access Management
  • Snowflake Approach to Access Control & Key Concepts
  • Role Hierarchy in Snowflake
  • ACCOUNT ADMIN role
  • Outline of the IAM hands on lectures
  • SECURITY ADMIN role
  • SYSADMIN role
  • Custom roles
  • PUBLIC roles
  • Lab : Demonstrating different roles
  • Assignment : Assign privileges through a new custom role
  • Assignment : Assign a default role to a user (using SQL)
  • Quiz : Snowflake Access Management
 
Section 13 : Advanced Features
  • Change Tracking Using Table Streams
  • Schedule Using Tasks
  • UDF
  • Stored Procedures
  • Column-level Security
  • Row-level Security
  • Working with Resource Monitors
 
Conclusion & Mega Quiz Evaluation
Call our Training & Career Counsellor on (+91) 9972579495 and (+91) 9945235221
Enroll Now - Pay ₹ 20,000 (all inclusive)

*T & C Apply

Click on Pay Now to Check EMI Options
Frequently Asked Questions - FAQs for Snowflake Training :
  • Que : Will I Get Placement Assistance after completing this Snowflake course?
  • Ans : BigDataLogin is a Job Portal. We will forward your resume to all relevant companies.
  • Que: Will I receive a Certificate?
  • Ans : Yes. You will get Course Completion Certificate from BigDataLogin.
  • Que : What if I miss the Online class?
  • Ans : BigDataLogin provides Video recordings of each class so you can review them as needed before the next session..
  • Que : Do you provide Tutor / Mentor Support during & after the course?
  • Ans : We will provide 20 days support for asking any doubts after the course completion. Doubts and questions can be listed on BigDataLogin platform and the Trainer will answer them online later. Questions will be supported during the Course and for 20 days after the Course completion. Sometimes there may be a delay in answers to queries.
  • Que : What if I have more queries?
  • Ans : You can Call our Training & Career Counsellor at (+91) 9972579495, (+91) 9945235221 OR email at [email protected]

You have Signed Out of Your Account.

Please press 'Reload' to Sign in to BigDataLogin again.