> Formations > Snowflake Advanced (ILT-ADV)
Course : Snowflake Advanced (ILT-ADV)Official Course: Preparation for SnowPro Advanced Certifications
Practical course - 3d
- 21h00 - Ref. SNA
|
Download in PDF format
Share this course by email
 | Master the advanced concepts of the Snowflake AI Data Cloud architecture |
| Design, Optimize, and Troubleshoot Bulk Data Loads |
| Optimize Performance and Implement Data Sharing in the Snowflake AI Data Cloud |
| Analyze semi-structured data and perform advanced queries |
| Analyze logs and events to monitor and troubleshoot processes |
Intended audience
Data Analysts, Data Engineers, Data Scientists, Database Administrators, Database Architects.
Prerequisites
It is recommended that you have completed the “Snowflake Multi-Factor Authentication (MFA) Essentials” online training course. You must have completed the “Snowflake Fundamentals” training course (ref. SNF) or have equivalent knowledge of Snowflake. Good written English skills.
Course schedule
1 Managing Dates, Times, and Time Series
- Dates, times, and timestamps.
- Working with Dates and Times.
- Time Series and ASOF Joins.
2 Use of Geospatial Data
- Overview of geospatial data.
- Geography and Geometry Data.
- Introduction to Geospatial Functions.
3 Unstructured Data Management
- Presentation of Unstructured Data.
- Fundamental Concepts.
- Process flow.
4 Snowflake Advanced Tables
- Dynamic Tables.
- Hybrid Tables.
- External tables: querying data lakes, creating tables, virtual columns, and partitions.
- Apache Iceberg™ and Apache Polaris™ Tables / Snowflake Open Catalog.
5 Data Flows and Ingestion
- Streams: Principles and Usage for the CDC and SCD Approaches.
- Loading and processing semi-structured data.
- Inference and the Evolution of Schemas.
6 Advanced SQL Queries
- GROUP BY and Grouping Sets.
- Subqueries and Common Table Expressions (CTEs).
- Window functions (cumulative and moving).
- Queries on hierarchical data.
7 Development and Automation
- Snowflake Notebooks.
- Configuring and managing alerts and notifications.
8 Performance Optimization
- Automatic clustering.
- Search Optimization.
- Faster query processing.
9 Data Collaboration
- Data sharing.
- Creating Listings.
- Provider Studio.
10 Artificial Intelligence and Machine Learning
- Introduction to Snowflake ML.
- Cortex AI.
- Cortex Search.
- Cortex Analyst.
- Cortex Agents and Snowflake Intelligence.
11 Data Quality
- Data Metrics Functions (DMFs).
- Workflow and metric monitoring.
Options
Certification : 210 € H.T.
SnowPro® Advanced: Data Engineer
Comment passer votre examen ?
Comment passer votre examen ?
PARTICIPANTS
Data Analysts, Data Engineers, Data Scientists, Database Administrators, Database Architects.
PREREQUISITES
It is recommended that you have completed the “Snowflake Multi-Factor Authentication (MFA) Essentials” online training course. You must have completed the “Snowflake Fundamentals” training course (ref. SNF) or have equivalent knowledge of Snowflake. Good written English skills.
TRAINER QUALIFICATIONS
The experts who lead the training courses are specialists in the subjects covered. They are approved by the publisher and certified for the course. They have also been validated by our teaching teams in terms of both professional knowledge and teaching skills for each course they teach. They have at least three to ten years of experience in their field and hold or have held positions of responsibility in companies.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training course.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you have specific accessibility requirements? Contact Ms FOSSE, disability advisor, at the following address: psh-accueil@orsys.fr so that we can assess your request and its feasibility.
Data Analysts, Data Engineers, Data Scientists, Database Administrators, Database Architects.
PREREQUISITES
It is recommended that you have completed the “Snowflake Multi-Factor Authentication (MFA) Essentials” online training course. You must have completed the “Snowflake Fundamentals” training course (ref. SNF) or have equivalent knowledge of Snowflake. Good written English skills.
TRAINER QUALIFICATIONS
The experts who lead the training courses are specialists in the subjects covered. They are approved by the publisher and certified for the course. They have also been validated by our teaching teams in terms of both professional knowledge and teaching skills for each course they teach. They have at least three to ten years of experience in their field and hold or have held positions of responsibility in companies.
ASSESSMENT TERMS
Assessment of targeted skills prior to training.
Assessment by the participant, at the end of the training course, of the skills acquired during the training course.
Validation by the trainer of the participant's learning outcomes, specifying the tools used: multiple-choice questions, role-playing exercises, etc.
At the end of each training course, ITTCERT provides participants with a course evaluation questionnaire, which is then analysed by our teaching teams. Participants also complete an official evaluation of the publisher.
An attendance sheet for each half-day of attendance is provided at the end of the training course, along with a certificate of completion if the participant has attended the entire session.
Assessment of targeted skills prior to training.
Assessment by the participant, at the end of the training course, of the skills acquired during the training course.
Validation by the trainer of the participant's learning outcomes, specifying the tools used: multiple-choice questions, role-playing exercises, etc.
At the end of each training course, ITTCERT provides participants with a course evaluation questionnaire, which is then analysed by our teaching teams. Participants also complete an official evaluation of the publisher.
An attendance sheet for each half-day of attendance is provided at the end of the training course, along with a certificate of completion if the participant has attended the entire session.
TEACHING AIDS AND TECHNICAL RESOURCES
The teaching resources used are the publisher's official materials and practical exercises.
The teaching resources used are the publisher's official materials and practical exercises.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training course.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you have specific accessibility requirements? Contact Ms FOSSE, disability advisor, at the following address: psh-accueil@orsys.fr so that we can assess your request and its feasibility.
This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.
Dates and locations
Select your location or opt for the remote class then choose your date.
Remote class
Dernières places
Date garantie en présentiel ou à distance
Session garantie
This programme is an original creation, developed by the teaching teams at ORSYS Formation. Any reproduction, representation, adaptation or use, in whole or in part, without the prior written authorisation of ORSYS, is strictly prohibited. ORSYS reserves the right to take any action necessary to protect its intellectual property rights.