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

Batch Date: Aug 10th @7:30AM

Faculty: Mr. Venkatesh (8+ Yrs of Exp,.. & Real Time Expert)

Duration : 45 Days

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

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

Syllabus:

MASTERING SNOWFLAKE

Section 1: Introduction & Setup

• What is Snowflake?
• History and evolution
• Self-registration and free trial setup
• Key features: cloud-native, scalable, elastic compute
• Benefits over traditional data warehouses

Section 2: Architecture & Interface

• Snowflake multi-cluster shared data architecture
• Components: compute, storage, services
• Classic Legacy Web UI overview
• SnowSight (Modern UI) features and navigation
• Working with Worksheets and Dashboards

Section 3: Core Components & Object Management

• Containers: Databases, Schemas, Tables
• Table types: Permanent, Transient, Temporary
• Creating and managing Snowflake objects
• Overview of latest object types (Stages, Pipes, Tasks, Streams)
• Virtual Warehouse: Sizing, scaling, suspend/resume

Section 4: Data Loading – Batch & Continuous

• Bulk data loading using PUT, GET, COPY INTO
• Snowpipe for continuous data ingestion
• File formats: CSV, JSON, Avro, Parquet
• Loading from AWS S3, Azure Blob, GCP Buckets
• Creating and querying External Tables

Section 5: Performance Optimization

• Micro-partitioning and data clustering
• Manual vs automatic clustering strategies
• Query tuning and profiling
• Creating and using resource monitors

Section 6: Data Time Travel & Cloning

• Understanding Time Travel feature
• Recovering deleted or changed data
• Querying historical snapshots
• Zero-copy Cloning for Databases, Schemas, and Tables
• Use cases: versioning, testing, branching

Section 7: Secure Data Sharing & Access Control

• Secure Data Sharing via Provider and Reader accounts
• Data consumer models
• Creating Reader accounts
• Role-based Access Control (RBAC)
• Designing and managing role hierarchies

Section 8: Streams, Tasks & ETL Automation

• Using Streams for Change Data Capture (CDC)
• Creating and scheduling Tasks
• Automating ETL pipelines using Streams and Tasks
• Scheduling via Cron expressions
• Real-time data transformation workflows

Section 9: Advanced Development & Views

• Creating Stored Procedures (SQL/JavaScript)
• User Defined Functions (UDFs)
• Views and Materialized Views
• Encapsulation and reuse of logic
• Auditing and querying metadata via Information Schema

Section 10: Monitoring, Billing & Cost Control

• Monitoring compute and storage usage
• Query history, user activity
• Setting up alerts and thresholds
• Billing dashboards and credit usage views
• Best practices for cost optimization

2-Day Mini Project: End-to-End Snowflake Implementation

Day 1 – Data Ingestion & Modeling

• Create a Snowflake trial account
• Set up database, schema, tables (e.g., sales_data, customer_data)
• Load batch data using COPY INTO from staged files
• Use Snowpipe for continuous loading from cloud storage
• Create External Tables and query external JSON data
• Apply clustering and define a Virtual Warehouse

Day 2 – Automation, Sharing & Reporting

• Create Streams and Tasks to process and transform incoming data
• Set up secure data sharing via a Reader Account
• Build a simple Stored Procedure and UDF
• Apply Time Travel to recover a deleted record
• Clone a table and validate contents
• Use Information Schema to audit queries and monitor activity
• Review cost & warehouse billing reports