Overview
This three‐day course covers advanced Snowflake data manipulation and movement features, using spe cialty table types, advanced query constructs, performance, and Snowflake‐recommended operational best practices. It consists of lectures, demonstrations, and labs.
Skills Covered
- 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 AI Data Cloud.
- Use data sharing for collaboration in the Snowflake AI Data Cloud.
Prerequisites
- Recommended completion of the “Snowflake Multi‐Factor Authentication (MFA) Essentials” free on‐ demand course.
- Completion of “Snowflake Fundamentals” or equivalent Snowflake knowledge.
Target Audience
- Data Analysts
- Data Engineers
- Data Scientists
- Database Administrators
- Database Architects
Date, Time, and Time Series Data
- Dates, Times, and Timestamps
- Work with Dates and Times
- Time Series Data and ASOF Joins
Working with Geospatial
- Geospatial Overview
- Geography Data
- Geometry Data
- Introduction to Geospatial Functions
Working with Unstructured Data
- Overview of Unstructured Data
- Concepts
- Workflow
External Tables
- Querying External Data Lakes
- Create and Query External Tables
- Create Virtual Columns and Partitions
Apache Iceberg™ Tables
- Data Lakes and Apache Iceberg™ Tables
- Apache Iceberg™ Tables in Snowflake
- Apache Polaris™ and Snowflake Open Catalog
Streams
- Overview of Streams
- Using Streams for CDC and SCD
Schema Inference and Evolution
- Schema Inference
- Schema Evolution
Window Functions
- Overview of Window Functions
- Cumulative Window Functions
- Sliding Window Function
Notifications and Alerts
- Configure and Manage Snowflake Alerts
- Configure and Manage Snowflake Notifications
Data Collaboration
- Create a Listing
- Provider Studio
Data Metric Functions (DMFs)
- Overview of Data Metric Functions
- DMF Workflow
- Monitoring DMFs
Snowflake AI and ML
- Introduction to Snowflake ML
- Cortex AI
- Cortex Search
- Cortex Analyst
- Cortex Agents and Snowflake Intelligence
Dates & Locations
July 1, 2026 - July 3, 2026
Location:
Online
Modal:
VILT
Availability:
TBC
Exam & Certification
Training & Certification Guide
Frequently Asked Questions
Speak to a Training Consultant
All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631
