Stalwart Masterclass : Snowflake Online

Loading Events

Stalwart Masterclass : Snowflake Online

This 2-day online course covers how to explore, load, visualize and extract insights from the Snowflake Platform. This course will consist of lectures, labs, and discussions.

Topics Covered are:

  • Overview of Snowflake key features & architecture Perform advanced and high-performing data analytic tasks
  • Load and work with new datasets Review key SQL extensibility features
  • Query and inspect data using SQL core constructs
  • Employ best practices for working with semi-structured data
  • Discuss query caching performance capabilities
  • Visualizing data outside of Snowflake

 

2 Days

  • Snowflake Overview
  • Architecture 101
  • How to use the Snowflake UI & ecosystem
  • Ingesting new data into Snowflake Tables
  • Working with various SQL Data Types
  • Discussing streaming data
  • Ingestion best practices & anti-patterns
  • View the Schema
  • Filtering data examples & best practices
  • Sorting data & performance considerations
  • Commonly used functions
  • Save & export data output
  • Time Travel queries
  • Result set cache
  • Metadata cache
  • Query data cache
  • Best practices of using caching for performance and cost optimization
  • Using Snowflakes high-performing approximation and estimation features
  • Join and Union queries & tuning techniques
  • Perform advanced analytic tasks using additional SQL querying capabilities including subqueries, common table expressions, and analytic functions
  • User-defined functions
  • Stored Procedures
  • Regular Views & Secured Views
  • Data source formats
  • Support of native data types
  • SQL Operations (Grouping, Sorting & more)
  • Built-in functions for traversing, flattening, and nesting of semi-structured data
  • Connecting a BI Tool to Snowflake
  • Exploring & Visualizing data outside of Snowflake

Enquire Now





Upcoming Events

June 22 @ 9:00 am - June 26 @ 1:00 pm
Virtual/Online
July 17 @ 10:00 am - 5:00 pm
Virtual/Online
July 27 @ 8:00 am - July 30 @ 11:00 am
Virtual/Online
August 6 @ 11:00 am - 12:30 pm
Virtual/Online
August 21 @ 10:00 am - 5:00 pm
Virtual/Online

Event Details

Date: July 27 @ 8:00 am - July 30 @ 11:00 am
Time: 8:00 am - 11:00 am
Venue: Virtual/Online
Organizer Name: Stalwart Learning
Phone: +91 9731 203 391
Address: Virtual/Online