> Formations > Snowflake Fundamentals (ILT-FUND)
Course : Snowflake Fundamentals (ILT-FUND)Official Course: Snowflake Certification Preparation
Practical course - 4d
- 28h00 - Ref. SNF
|
Download in PDF format
Share this course by email
 | Describe the architecture of the Snowflake AI Data Cloud |
| Load, transform, and manage data using Snowflake's SQL features |
| Manage user access and permissions to secure the Snowflake environment |
| Optimize performance and costs by using virtual warehouses and caching mechanisms |
| Take advantage of the platform's advanced features: data protection, data sharing, and Snowflake account management |
Intended audience
Data Analysts, Data Engineers, Data Scientists, Database Architects, Database Administrators.
Prerequisites
It is recommended that you have completed the free on-demand training course “Snowflake Multi-Factor Authentication (MFA) Essentials.” Prior knowledge of data warehouses is required. A good understanding of written English is required.
Course schedule
1 Overview and Architecture of Snowflake
- Introduction to Snowflake.
- Snowflake's Structure.
- Using Snowsight.
- Storage Layer.
- Compute Layer.
- Cloud Services Layer.
- Snowgrid.
- Generative artificial intelligence.
2 Connecting to Snowflake
- Connection option.
- Snowflake CLI.
- Visualizations in Snowsight.
3 Data Protection Features
- Cloning.
- Time Travel.
- Fail-safe.
- Introduction to Replication.
- Snowflakes Backups.
4 SQL Support in Snowflake
- Tables, views, and data types.
- Transactions.
- Standard SQL and Snowflake SQL.
- Collation Rules.
- Multi-table inserts.
- Query Tags.
- Using Settings.
5 Metadata and Caching Mechanisms
- Overview of Metadata.
- Metadata.
- Caches query results.
- Data cache.
6 Query Performance
- Using the Explain command.
- Query Profile.
- Tips for Optimizing SQL Performance.
7 Data Upload and Download
- Data loading objects.
- Data loading process.
- Transformations and copy options.
- Recommendations for Data Uploading.
- Data is being loaded continuously.
- Unloading data.
8 Snowflake Functions, Procedures, and Scripts
- User-defined functions.
- Stored procedures.
- Snowflake Scripts.
9 Using Tasks, Workflows, and Dynamic Tables
- Overview of Tasks.
- Creating Tasks.
- Task Management.
- Overview of the data flows.
- Introduction to Dynamic Tables.
10 Security Management
- Overview of Security.
- Access.
- Authentication.
- Authorization.
- Data Protection.
- Center of Trust.
11 Access Control and User Management
- Concepts.
- Types of roles.
- Ownership.
- View access permissions.
12 Semi-structured data
- Overview.
- Query for semi-structured data.
13 Introduction to Data Sharing
- An Introduction to Data Sharing in Snowflake.
- Shares.
14 Scalability of Virtual Warehouses
- Types of Scalability in Virtual Warehouses.
- Automatic scalability policies.
15 Cost Management
- Introduction.
- Visibility.
- Check.
- Optimization.
16 Snowflake's Introduction to AI and Machine Learning
- An Overview of Cortex's AI Features.
- An Overview of Snowflake's ML Features.
Options
Certification : 210 € H.T.
Snowflake SnowPro Core
Comment passer votre examen ?
Comment passer votre examen ?
PARTICIPANTS
Data Analysts, Data Engineers, Data Scientists, Database Architects, Database Administrators.
PREREQUISITES
It is recommended that you have completed the free on-demand training course “Snowflake Multi-Factor Authentication (MFA) Essentials.” Prior knowledge of data warehouses is required. A good understanding of written English is required.
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 Architects, Database Administrators.
PREREQUISITES
It is recommended that you have completed the free on-demand training course “Snowflake Multi-Factor Authentication (MFA) Essentials.” Prior knowledge of data warehouses is required. A good understanding of written English is required.
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
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.