Course Name
Course Code : JRA38
Venue Details
Postal Code : 11001
Session Dates
Duration: 2 days (14 hours)
This course provides a foundational understanding of the Snowflake Data Cloud platform. It covers key architectural principles, hands-on usage of core features, and best practices for managing data, users, and workloads in Snowflake.
Snowflake Architecture & Core Concepts
Introduction to Snowflake: Overview and Use Cases
Cloud-native architecture: Separation of Storage and Compute
Virtual Warehouses: Scaling and Performance
Databases, Schemas, and Objects
Data Loading Techniques:
Using Web UI
SnowSQL CLI
COPY INTO and External Stages
File formats: CSV, JSON, Parquet, Avro
Understanding Time Travel and Fail-safe features
Advanced Features & Performance Management
Roles and Access Control: RBAC in Snowflake
Resource Monitoring and Query Profiling
Data Sharing and Secure Data Exchange
Cloning for Dev/Test/Prod environments
Working with Semi-Structured Data (JSON, VARIANT)
Basic Optimization: Partitioning (Micro-partitions), Pruning
Introduction to Tasks, Streams, and Pipelines
Integrations with BI tools (Power BI, Tableau)
Hands-On Activities
Mode of Delivery : The event can be attended both online and at nearby ProgNXT classroom by Individual Professionals and Corporate Employees as per the seat availability. Please Contact Us at [email protected] for checking the seat availability
Audience : We have a global audience that logs in to using their own computers to work hand in hand with our world-class instructors.
Assessment : Each training course will have ProgNXT Assessment at the end.
Certification : After successful passing of ProgNXT Assessment, ProgNXT Certification will be provided, which has got acceptance in 55+ Countries.
| Global Region | Location | Start Date | End Date | Action |
|---|---|---|---|---|
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |