• 30 N Gould St Ste R Sheridan, WY 82801, USA
Join us for a FREE hands-on Meetup webinar on Introduction to Agentic AI | Friday, March 21st, 2025 · 7:30 PM IST/ 10:00 AM EDT Join us for a FREE hands-on Meetup webinar on Introduction to Agentic AI | Friday, March 21st, 2025 · 7:30 PM IST/ 10:00 AM EDT
Search
Close this search box.
Search
Close this search box.
Contact Us

Snowflake Advanced

Deep Dive into Performance Tuning, Security, and Scalable Data Architecture in Snowflake
Enroll Now

Duration

3 Days

Level

Advanced Level

Design and Tailor this course

Official Course

Edit Content

This three-day course covers advanced Snowflake features related to data manipulation and movement, using specialty table types, advanced query constructs, performance, and Snowflake-recommended operational best practices. This course consists of lectures, demos, and labs.

ACQUIRED SKILLS

  • Evaluate Snowflake’s advanced architectural concepts.
  • Design a bulk loading and load troubleshooting strategy.
  • Leverage the power of semi-structured and unstructured data.
  • Use advanced query constructs for data analysis.
  • Use event tables to collect and analyze logging and trace information.
  • Develop a methodology for performance tuning your Snowflake Data Cloud.
  • Use data sharing for collaboration in the Snowflake Data Cloud.
Edit Content
  • Data Analysts
  • Data Engineers
  • Data Scientists
  • Database Architects
  • Database Administrators
Edit Content
  • Date and Time Data Types
  • Work with Dates and Times
  • Time Series Data and ASOF Joins
  • Geospatial Overview
  • Geometry Data
  • Geography Data
  • Using Geospatial Functions
  • Overview
  • Concepts
  • Workflow

 

  • Querying External Data Lakes
  • Creating and Querying External Tables
  • Partitioning External Tables

 

 

  • Data Lakes and Iceberg Tables
  • Iceberg Tables in Snowflake

 

  • Loading and Transforming Semi-structured Data
  • Schema Inference
  • Schema Evolution

 

 

 

  • Overview
  • Cumulative Window Functions
  • Sliding Window Functions

 

 

  • Configure and Manage Snowflake Alerts
  • Configure and Manage Notifications
  • What is Data Clustering?
  • Micro-partition Pruning (Elimination)
  • Evaluating Clustering
  • Implement and Test Cluster Keys

 

 

  • Overview
  • Materialized View Use Cases
  • Data Access Options
  • Direct Data Sharing Workflow
Edit Content

Completion of “Snowflake Fundamentals” or equivalent Snowflake knowledge.

Download PDF

Stay ahead with DataCouch! Your partner in mastering the latest advancements in AI, Data Science, DevOps, and more.

Quick Links

our Offerings

Get in touch

Instagram Facebook X-twitter Linkedin Youtube Meetup Medium

Sign up for DataCouch Communications

Copyright 2025 © DataCouch

Connect

we'd love to have your feedback on your experience so far