Snowflake SnowPro Advanced Data Engineer

Snowflake SnowPro Advanced Data Engineer

Snowflake

Course Description

This course prepares attendees to take the SnowPro Advanced Data Engineer exam. The advanced-level certification validates the skills and knowledge required to design and implement complex Snowflake data solutions. This class covers advanced data modeling, advanced SQL, data integration, advanced data transformation, data quality, data visualization and reporting, performance tuning and optimization, and Snowflake deployment and management.

Duration Delivery Method Mandatory Prerequisites Who Should Attend
3 days Virtual – Intructor led Attendees should have:

  • Completed the Snowflake Fundamentals training or have equivalent experience
  • Ideally, achieved the SnowPro Core Certification
  • Ideally, a working knowledge of restful APIs, SQL, and a solid programming background
The audience for this class is Data Engineers.

Course Objectives:

The focus is on leveraging Snowflake with common data engineering competencies. This includes:

  • Source data from Data Lakes, APIs, and on-premises
  • Transform, replicate, and share data across cloud platforms
  • Design end-to-end near real-time streams
  • Design scalable compute solutions for DE workloads
  • Evaluate performance metrics

Agenda:

Data Movement

  • Loading and unloading data
  • Data formats and types
  • Data pipelines
  • Connectors
  • Data sharing
  • External tables and materialized views
  • Partitioning

Performance Optimization

  • Query optimization
  • Caching
  • Monitoring continuous data pipelines

Storage and Data Protection

  • Time Travel
  • Fail Sage
  • Backups and Rollbacks
  • Testing pre-deployment

Security

  • Authentication methods
  • RBAC
  • Data governance
  • Column/Row-level security

Data Transformation

  • User Defined Functions (UDFs) – SQL, JavaScript
  • External Functions
  • Transaction management
  • Semi-structured data transformation
  • Snowpark