Subcribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..
Batch
Date: Dec
4th @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