Snowflake SnowPro Advanced Data Engineer Training

This Snowflake SnowPro Advanced Data Engineer course prepares attendees for advanced-level certification to validate their skills and knowledge for designing and implementing complex Snowflake data solutions. This class covers advanced data modeling, advanced SQL, data integration, advanced data transformation, data quality, data visualization/reporting, performance tuning/optimization, and Snowflake deployment/management.

Course Details


3 days


  • SnowPro Core training or equivalent experience.
  • A working knowledge of restful APIs, SQL, and a solid programming background are ideal.

Target Audience

Data Engineers

Skills Gained

  • 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
Course Outline
  • 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