infyni

Mastering Snowflake Data

Unlock the full potential of your data with "Mastering Snowflake Data." This course is your gateway to becoming an expert in leveraging Snowflake, the cutting-edge cloud-based data warehousing platform. Gain hands-on experience, optimize data workflows, and elevate your capabilities.

Live Course

Live Class: Friday, 08 Mar

Duration: 40 Hours

Enrolled: 0

Offered by: infyni

Live Course
$1094 60% off

$438

Enroll Now

About Course

Snowflake is revolutionizing the way organizations manage and analyze their data, offering a scalable and flexible platform for data storage and processing. This comprehensive course is designed for data professionals, analysts, and anyone looking to harness the full power of Snowflake. Explore advanced data warehousing concepts, learn to optimize performance, and master the art of extracting valuable insights from your data.

Skills You Will Gain

Introduction to Snowflake Architecture Data Loading and Unloading Snowflake SQL Fundamentals Performance Optimization Techniques Data Modeling in Snowflake Managing Metadata and Security

Course Offerings

  • Instructor-led interactive classes
  • Clarify your doubts during class
  • Access recordings of the class
  • Attend on mobile or tablet
  • Live projects to practice
  • Case studies to learn from
  • Lifetime mentorship support
  • Industry specific curriculum
  • Certificate of completion
  • Employability opportunity
  • Topics
  • Instructor (1)
1 Introduction
  • Introduction to Snowflake
  • Create a Free Snowflake Account
  • Explore - Databases, Schemas and Tables
  • Snowflake Architecture
  • Virtual Warehouses (Compute Engine) – Intro
  • Different Roles in Snowflake
  • Snowflake Pricing - Overview
  • What are Snowflake Credits
  • Snowflake Editions
  • Storage Cost
  • Resource Monitors - Introduction
  • Properties of Resource Monitor
  • Suspension or Resumption
  • Detailed Example - How Resource Monitors Work
  • Create a Resource Monitor using WebUI
  • Partitioning in Traditional Data Warehouses
  • Partitioning in Snowflake - Micro Partitioning
  • Advantages of Micro-Partitioning
  • Structure of Micro-Partition
  • Query Processing in Snowflake
  • Clustering Introduction
  • Clustering Keys
  • Clustering Metadata
  • Clustering Depth
  • Automatic Re-clustering
  • Query History
  • Detailed Lab - Query History
  • SQL Queries to fetch Query History
  • Caching in Snowflake
  • Caching - Detailed using Examples
  • Worksheets - Databases, Schemas, Tables, etc
  • Setting up Context/Parameters for worksheet
  • Run the first SQL statement
  • More about Worksheet's Results section
  • What is AWS s3 and how to create buckets under it
  • What is IAM (Identity & Access Management)
  • Create an IAM Group
  • Create IAM User
  • Create AWS IAM Role
  • Upload data to AWS s3 using the web console
  • Loading Data - Create Table Schema, Integration object
  • Loading CSV Data to Snowflake using the COPY command
  • Load Complete CSV data from S3
  • Introduction to Snowpipe
  • Load CSV Data from s3 using Snowpipe
  • Different Types of Tables
  • Create Permanent & Transient Database
  • Create Permanent & Transient Schema
  • Create Permanent & Transient Schema
  • Create Temporary, Permanent & Transient Table
  • Convert the Table to a Different type
  • What is Time Travel - Detailed
  • Set & Alter Retention Time Property
  • Query Historical Results
  • Clone Historical Objects
  • Restore the Dropped Objects [IMP]
  • What is Failsafe - Detailed Overview
  • Check Failsafe Storage Consumption
  • Introduction to Streams
  • How Streams work under the hood
  • Capture & Process INSERT Operations
  • Capture & Process UPDATE Operations
  • Capture & Process DELETE Operations
  • How streams work within a Transaction
  • What is Zero-Copy Cloning
  • Clone Database, Pipes, Streams, Tasks & Stages
  • Clone Schema & Tables
  • Data Sharing - Definition
  • Provider and Consumer Accounts
  • Allowed list of objects to Share
  • How Data Sharing Works on Snowflake
  • Data Sharing - Architecture
  • Materialized Views - Introduction
  • Materialized Views - When to create
  • Materialized Views - Advantages
  • Materialized Views - Limitations
  • Secure Views - Introduction
  • Secure Views - Hands On
  • Understand the Requirements
  • Set up Users and Custom Roles
  • Grant Privileges to custom Roles
  • Data Masking - Introduction
  • Data Masking - Detailed overview
  • Data Masking - Hands-on
  • Introduction to Partner Connect
  • Know about available Tools
  • SnowSQL (CLI Client) - Installation, Configuring and Usage

...
YASWANTH SINGH
About Instructor

HAVING 16 YEARS OF IT EXPERIENCE IN WHICH, 5+ YEARS IN SNOWFLAKE (CERTIFIED) Professional Corporate Trainer, Informatica cloud(IICS), Tableau/ eLearning/ Knowledge check questions/ Recorded deliveries of the content/ Document preparation/Interviewer/Career Coach

0

Rating

0

Review

0

Student

1

Course