SnowFlake

  • 4.5/5.0
  • 1000+ Enrolled
  • All levels
  • Last updated 1/2025
  • English

Course description

Snowflake is transforming the worlds of data warehousing as such, delivers high-performance data warehousing in a scalable and secure cloud-based platform. Our comprehensive course, Snowflake Online Training, covers all aspects from basic data warehousing to advanced topics of the Snowflake environment such as data sharing, multi-cluster management and performance optimization. Taught by industry experts, this course is ideal for data engineers, data analysts and IT professionals who want to unlock the full capabilities of Snowflake.

The online training by Vamadeva Techno Sols will definitely embed real-world experience in the participant's mind with interactive sessions, hands-on labs, and project-based learning. By the end of this Snowflake training, learners will be well-equipped and proficient in managing data operations, optimizing performance, and effectively using the unique features of Snowflake for most applications involving data.

Prerequisites :

To get the most out of Snowflake Online Training participants should bring:

  • Basic familiarity with SQL and data warehousing concepts.
  • Experience with cloud platforms is a plus, but not a must: cloud providers like AWS, Azure or Google Cloud.
  • An enthusiasm to learn about modern data platforms and engineering practices on data.
What you’ll learn

  • What is Cloud?
  • Different Cloud Vendors
  • Advantages of Cloud over Traditional Databases

  • What is a Data Warehouse?
  • Database Vs Data Warehouse
  • Why do we need Data Warehouse?
  • OLTP Vs OLAP
  • What is ETL?

  • Supported Cloud Platforms
  • Snowflake Architecture
  • Cloud Service Layer
  • Compute or Query processing Layer
  • Storage Layer
  • Snowflake Editions
  • Setting up virtual warehouses

  • User Interface - snow sight
  • SnowSQL (CLI Client)
  • Using python

  • Introduction to Time Travel
  • Configure Retention time property
  • Query historical results
  • Clone historical objects
  • Restore the dropped objects

  • Introduction to Fail safe
  • Check fail safe storages consumption
  • Fail safe storage charges

  • Different table types
  • Permanent tables & databases
  • Transient tables & databases
  • Temporary tables & databases

  • Partitioning in Traditional Data Warehouses
  • Partitioning in Traditional Data Warehouses
  • Advantages of Micro-Partitioning
  • Structure of Micro-Partition
  • Query Processing in Snowflake

  • File formats supported in Snowflake
  • Creating file formats
  • Types of data loading
  • Limited data
  • Bulk data
  • Continuous data
  • Limited data loading/unloading using Web Interface
  • Bulk data loading/unloading from/to local file
  • Bulk data loading/unloading from/to Amazon S3
  • Bulk data loading from Microsoft Azure
  • Bulk data loading from Google cloud

  • Creating stage & raw file
  • Parsing JSON
  • Handling nested data
  • Dealing with hierarchy
  • Insert final data

  • What is a stage? Types of stages
    • Table stages
    • User Stage
  • Named Stage
  • Creating stages
  • Data Loading/Unloading into/from stages
  • Querying Data in Staged Files
  • External stages
    • AWS registration
    • Bucket creation
    • IAM policies
    • Accessing bucket through outside
    • Integrating AWS S3 to snowflake
    • Loading files from S3 but to snowflake

  • Introduction to Snowpipe
  • Load CSV data from S3 using Snowpipe
  • Load JSON data from S3 using Snowpipe
  • Snowpipe

  • Introduction to Data Sharing
  • Data Providers
  • Data Consumers
  • INBOUND and OUTBOUND Shares

  • Introduction to Tasks
  • Task tree
  • Implement standalone task
  • Check task history

  • Introduction to streams
  • Insert operation in streams
  • Delete operation in streams
  • Update operation in streams

  • Introduction to Zero Copy Cloning
  • Clone Database, Pipes, Streams, Tasks & Stages
  • Clone Schema and Tables
  • DML changes in cloned table
  • Cloning using Time Travel
  • Swap the Tables

  • Downloading and installing SnowSQL
  • Creating database, tables in SnowSQL
  • Loading and unload data using
  • SnowSQL

  • System Usage & Billing
  • Understanding Snowflake Credit and Storage Usage

  • System defined User roles
  • Custom roles
  • Creating Users
  • Creating Custom Roles
  • Granting roles to users
  • Data Encryption in Snowflake
  • Data Encryption at customer side

  • What are Snowflake Credits?
  • Server less Features cost
  • Storage Cost
  • Check storage cost for different regions
  • Virtual Warehouses – Compute Cost
  • Cloud Services Cost
  • Data Transfer Cost
  • Check consumed CREDITS on your
  • Account

  • Cache introduction
  • Types of Cache in Snowflake

  • Views in Snowflake
  • Secure views in Snowflake
  • Views vs. Secure Views
  • Understand and creating materialized views
  • Refresh materialized views
  • When to use materialized views

  • Understanding data masking
  • Creating a masking policy
  • Recreate and Unset Masking Policy
  • Apply Masking policies on objects
  • Alter Masking Policies
Enroll now

Course Information

  • Course Name Looker BI
  • Lectures 30
  • Duration 4h 50m
  • Level Beginner to Expert
  • Course Type Online/Offline
  • Language English
  • Faculty / Exp Keshav / 5yrs
  • Certificate Yes
Enroll a free demo class now

Our Courses