SNOWFLAKE Logo v2
8117  Reviews star_rate star_rate star_rate star_rate star_half

Snowflake SnowPro Advanced Data Engineer

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...

Read More
Course Code INNO-SP-DATA-ENG
Duration 3 days
Available Formats Classroom

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.

Skills Gained

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

Who Can Benefit

The audience for this class is Data Engineers.

Prerequisites

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

Course Details

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