Snowflake training - First steps

Discover Snowflake

 

Contact us
Our training courses

"This Snowflake training course enabled me to master the basics in just two days. The practical exercises were particularly useful. I highly recommend it!"

 

"As IT Manager, this training has helped me integrate Snowflake effectively into our infrastructure."

"Enriching and well-structured training. I acquired a good level of autonomy on Snowflake thanks to the practical sessions and clear explanations."

Snowflake - First steps

Objectives

On completion of the course, you will be able to :

    • Describing Snowflake architecture
    • Configuring Snowflake
    • Load data
    • Handling data
    • Managing access to snowflake
    • Integrate your Snowflake data into a reporting tool

Program

Introduction
    • Introducing Snowflake: What is Snowflake?
    • Snowflake history and development
    • Advantages of Snowflake over other data warehousing solutions
Snowflake architecture
    • Understanding Snowflake's unique architecture
    • Basic concepts: virtual clusters, storage and services
Initial configuration
    • Creating a Snowflake account
    • Navigating the Snowflake user interface
    • User and role configuration
Loading Data
    • Introduction to data formats supported by Snowflake
    • Data loading methods: COPY INTO, Snowpipe
    • Practical exercise: Loading data from CSV files
Data handling
    • Introduction to SQL commands in Snowflake
    • Table creation and management
    • Practical exercise: Writing SQL queries to manipulate data
Security and Access Management
    • Understanding security concepts in Snowflake
    • Roles and permissions management
    • Practical exercise: Configuring roles and permissions
Conclusion and Q&A
    • Summary of key points covered
    • Question-and-answer session

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.
Download the training program
Update : 09/04/2025

2 days (14 hours)

1,100 excl. tax / person

 

 

Contact us

Target audience

    • Data developers/engineers
    • Analysts
    • Database administrators

Prerequisites

    • Good knowledge of SQL language

Location

    • On-site & distance learning

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