Snowflake Fundamentals
Instructor-led Snowflake-aligned training in Snowflake Fundamentals. Delivered live online by senior practitioners, with hands-on labs and a final assessment. Includes an Skilvi course-completion certificate.
Overview
The Snowflake Fundamentals course provides a comprehensive introduction to Snowflake, a leading cloud-based data warehousing platform. This course is essential for anyone looking to leverage Snowflake's powerful capabilities for data storage, processing, and analytics in modern data environments.
What you'll learn
- You will be able to navigate the Snowflake interface and understand its architecture.
- You will be able to create and manage Snowflake accounts and databases.
- You will be able to load and unload data into Snowflake from various sources.
- You will be able to write and execute basic SQL queries in Snowflake.
- You will be able to understand and implement Snowflake's data sharing capabilities.
- You will be able to optimize performance and manage resources within Snowflake.
- You will be able to apply best practices for data governance and security in Snowflake.
Curriculum
7 modules · outline is indicative and can be tailored to your team.
1Introduction to Snowflake
- Overview of Cloud Data Warehousing
- Key Features of Snowflake
- Understanding Snowflake Architecture
2Setting Up Snowflake
- Creating a Snowflake Account
- Configuring Your Environment
- Managing Users and Roles
3Data Loading and Unloading
- Loading Data from Various Sources
- Unloading Data from Snowflake
- Using Snowpipe for Continuous Data Ingestion
4Querying Data with SQL
- Introduction to SQL in Snowflake
- Writing Basic Queries
- Using Functions and Operators
5Data Sharing and Collaboration
- Understanding Data Sharing Features
- Setting Up Secure Data Shares
- Collaborating with External Partners
6Performance Optimization
- Understanding Virtual Warehouses
- Query Optimization Techniques
- Managing Storage and Compute Resources
7Data Governance and Security
- Implementing Security Best Practices
- Data Encryption and Masking
- Managing Compliance and Auditing
Prerequisites
No prior experience required.
Who should attend
This course is ideal for data analysts, engineers, and business professionals seeking to understand and utilize Snowflake for data management.
Certification
Prepares you for the official Snowflake certification exam.
Skilvi is an independent training provider and is not affiliated with, or endorsed by, Snowflake. Trademarks are the property of their respective owners.
Frequently asked questions
What is the delivery format of this course?
This course is delivered instructor-led and live online.
How long is the course?
The course typically spans over 16 hours, divided into multiple sessions.
Will I receive a certificate upon completion?
Yes, you will receive an Skilvi course-completion certificate after finishing the course.
Are exam vouchers included with the course?
Exam vouchers are available through authorized channels on request.
Do I need any prior knowledge of data warehousing?
No prior knowledge of data warehousing is required for this beginner course.
Pricing on request
- Live online (VILT)
- 16–24 hours
- Hands-on labs & assignments
- Skilvi completion certificate
- Exam voucher on request
Related courses
Advanced Program Generative AI
Instructor-led training in Advanced Program Generative AI. Delivered live online by senior practitioners, with hands-on labs and a final assessment. Includes an Skilvi course-completion certificate.
AI ML Python Deep Learning
Instructor-led training in AI ML Python Deep Learning. Delivered live online by senior practitioners, with hands-on labs and a final assessment. Includes an Skilvi course-completion certificate.
Apache Kafka
Instructor-led training in Apache Kafka. Delivered live online by senior practitioners, with hands-on labs and a final assessment. Includes an Skilvi course-completion certificate.
Apache Pig Hive
Instructor-led training in Apache Pig Hive. Delivered live online by senior practitioners, with hands-on labs and a final assessment. Includes an Skilvi course-completion certificate.