Snowflake – The Fundamentals
This course offers a complete introduction to the platform, giving participants the skills needed to configure and optimise data warehouses. Acquire the essential foundations, with a focus on data modelling, user management and query performance.
- duration
- 2 days
- format
- In-house, at your company
- lead time
- 2 to 3 weeks
- price
- €1,800 excl. VAT / day
Objectives
learning
Discover Snowflake's key concepts and architecture. Understand and use the different user roles.
on the job
Create and transform data in Snowflake databases. Import complex structured and semi-structured data. Use the cache to optimise queries and costs. Create data pipes and streams.
Syllabus
8 modules · 2 days
- Introduction to data
- Introducing Snowflake — key concepts and architecture
- Getting started with Snowflake
- Snowflake warehouse — DB objects, transformations
- Storage and advanced querying
- Performance and best practices
- Design & Deploy
- Exercises and case study
Prerequisites
- A Snowflake account
- A good grasp of SQL
- Good knowledge of DBMSs
Who it's for
- Project managers
- BI experts
- Systems engineers
Practical information
Assessment
- Informal interview and needs analysis
- Knowledge checks through questions and answers
- Hands-on exercises
- Attendance sheet and certificate of completion
- Satisfaction survey
Administrative formalities
Attendance sheet and certificate of completion.
Lead time
Setting up a session usually takes 2 to 3 weeks. Sessions can also be scheduled in advance.
Accessibility for people with disabilities
Email us at contact@heydata.fr so we can adapt the course.