Advanced Snowflake SnowPro Training Overview
This Snowflake training takes attendees from data ingest to insightful analysis and prepares them for the SnowPro Advanced Data Engineer exam, an advanced-level certification. Participants also learn the real-world skills they need to manage, transform, and analyze data using Snowflake.
Location and Pricing
Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for private corporate training on-site or online, please contact us.
In addition, some courses are available as live, instructor-led training from one of our partners.
Objectives
- Master Snowflake, including loading files, building pipelines, and sharing insights
- Craft lightning-fast queries and monitor performance
- Shape data with UDFs, external functions, and Snowpark's Python and Scala features
- Fortify your data with authentication, granular access control, and robust backup strategies
- Extract actionable insights and make data-driven decisions
Prerequisites
- SnowPro Core training or equivalent experience.
- A working knowledge of restful APIs, SQL, and a solid programming background are ideal.
Outline
Expand All | Collapse All
Introduction
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
Conclusion
Training Materials
All Snowflake training students receive comprehensive courseware.
Software Requirements
All attendees will need access to a Snowflake SQL environment with Accelebrate’s sample data loaded.
