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