Courses Offered: SCJP SCWCD Design patterns EJB CORE JAVA AJAX Adv. Java XML STRUTS Web services SPRING HIBERNATE  

       

SNOWFLAKE Course Details
 

Subcribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date: May 9th @7:00AM

Faculty: Mr. Shekhar (15+ Yrs of Exp,.. & Real Time Expert)

Duration: 35 Days

Venue :
DURGA SOFTWARE SOLUTIONS,
Flat No : 202, 2nd Floor,
HUDA Maitrivanam,
Ameerpet, Hyderabad - 500038

Ph.No: +91- 9246212143, 80 96 96 96 96

Syllabus:

SNOWFLAKE

Getting Started with Snowflake Topics:

  • Snowflake CLI installation & Configuration
  • Different Roles in Snowflake Explore - Databases, Schemas and Tables
  • Snowflake Architecture
  • Snowflake Virtual warehouses overview

Using Snowflake Topics:

  • Web Interface
  • Virtual Warehouses
  • Databases, Tables & Views
  • Queries
  • Date & Time Data
  • Semi-structured Data

Micro-partitioning and Clustering in Snowflake:

  • Micro partitions in Snowflake
  • Advantages of Micro-Partitioning
  • Structure of Micro-Partition
  • Query Processing in Snowflake
  • Clustering Introduction
  • How clustering works & It's advantages
  • how to Choose the right keys for clustering
  • Performance tuning

Table types in Snowflake:

  • Permanent table and fail-safe
  • Transient table
  • Temporary table
  • Transient database in snowflake

Snowflake Continuous Data Pipelines:

  • Snowflake Continuous stream data integrations Streams,
  • Tasks
  • Snow pipe

Sharing Data in Snowflake:

  • Introduction to Data Sharing
  • Data Providers
  • Data Consumers
  • Working with Shares

Snowflake Task Feature:

  • Tasks Intro
  • Demo SF
  • task Dependency
  • Dependency demo
  • Understanding Snowflake Billing:
  • Monitoring Credit and Storage Usage
  • Resource Monitors
  • User Management

Snowflake Concepts:

  • SQL in Snowflake
  • Loading Data – Structured and Semi Structured
  • Materialized Views
  • Fail Safe and Time Travel
  • Cloud Computing
  • Access Control
  • Zero Copy Cloning
  • Swapping
  • Snowflake Roles
  • Window Functions
  • Stored Procedures
  • User Defined Functions
  • SnowSQL
  • Query Profile