Snowflake training
SnowPro Core certification preparation
"Clear and effective training: I understood the Snowflake architecture and feel ready for the SnowPro Core certification."
"Perfect for structuring my SnowPro Core preparation. Everything is clear and practical."
"Practical training geared toward certification. I've become more efficient and confident."
Snowflake – SnowPro Core Certification Preparation
Objectives
On completion of the course, you will be able to :
-
- Understanding the Architecture of the Snowflake AI Data Platform
- Set up a complete environment
- Load and transform data
- Manage access and security
- Leveraging Snowflake in an analytical context
- Have all the keys to be independent and effective in your preparation for SnowPro Core certification
Program
Introduction
-
- Presentation and positioning: what is Snowflake?
- History, evolution, and modern use cases
- Advantages over other data warehousing platforms
Snowflake Architecture (core of the certification)
-
- Unique architecture: Storage / Compute / Cloud Services
- Multi-cluster shared data architecture
- Snowflake objects: databases, schemas, tables, views
- Warehouses, caching, micro-partitions
Initial setup and getting started
-
- Creating and organizing a Snowflake account
- Discover Snowsight and its administration tools
- User, role, and privilege management (RBAC)
Loading and unloading data
-
- Supported formats: CSV, JSON, Parquet, semi-structured
- Storage areas: internal and external stages
- Loading methods: COPY INTO, Snowpipe
- Unloading data
- Practical exercise: loading a CSV dataset
Data manipulation and transformation
-
- SQL reminders: DDL, DML, views, CTE
- Semi-structured data (VARIANT, FLATTEN)
- Discover modern transformation tools (Streams, Tasks)
- Practical exercise: creating tables and writing SQL queries
Performance and cost optimization
-
- Understanding warehouses: sizing, scaling, auto-suspend
- Use Query Profile to analyze performance
- Concepts of clustering, pruning, micro-partitions
- Best practices for optimization (compute & storage)
Security, governance, and access management
-
- Essential Security Concepts in Snowflake
- Permissions, roles, RBAC hierarchy
- Network policies and advanced options
- Practical exercise: configuring a simple role model
Data protection and sharing
-
- Time Travel & Fail-safe: restoration and historization
- Zero-copy cloning
- Secure Data Sharing: inter-account sharing
- Business use cases and best practices
Integration with reporting tools
-
- Connecting Snowflake to Power BI / Tableau / other BI tools
- Simple modeling for rendering
- Demonstration: consuming a Snowflake table in a reporting tool
Teaching methods and resources
Alternating presentation/explanation phases and situational exercises.
Quizzes throughout the course to validate knowledge acquired.
Assessment methods
The trainer ensures that trainees carry out practical exercises to validate the application of concepts and answers to quizzes.
Technical resources
-
- Trainee reception in a dedicated training room
- Trainees must bring their own professional computer to access in-house resources.
- Projected training support documents.
- Paper version of the training material provided at the start of the session.
- Electronic version of the training material sent after the course.
Updated: December 2, 2025
3 days (21 hours)
1 650 € HT / person
Target audience
-
- Data developers/engineers
- Analysts
- Database administrators
Prerequisites
-
- Good knowledge of SQL language
Location
-
- On-site at the client's premises & remotely
Accessibility
People with disabilities who would like to take this course are invited to contact us directly, so that we can examine together the possibilities of taking the course.
Access procedures and deadlines
Within 1 month.
Contact us by e-mail(formations@bilinksolutions.com) to find out about scheduled sessions or to arrange a date.
Trainer
Business intelligence expert, 15 years' experience