Snowflake Fundamentals Training Logo

Snowflake Fundamentals Training

Live Online & Classroom Enterprise Training

Snowflake Fundamentals introduces the core concepts, architecture, and capabilities of the Snowflake Data Cloud. It equips learners with foundational skills to load, query, and manage data confidently in Snowflake.

COURSE BROCHURE DOWNLOAD PDF

Looking for a private batch ?

REQUEST A CALLBACK

Need help finding the right training?

Your Message

  • Enterprise Reporting

  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

What is Snowflake Fundamentals Training about?

This four‐day course covers the core concepts, design considerations, and Snowflake recommended best practices intended for critical stakeholders who will be working on the Snowflake AI Data Cloud. The course consists of lectures, demos, and labs covering a wide range of essential topics.

What are the objectives of Snowflake Fundamentals Training ?

  • Outline the unique and differentiated architecture of the Snowflake AI Data Cloud.
  • Load and transform data.
  • Summarize query constructs, DDL, and DML operations.
  • Use Snowflake’s extensive SQL capabilities for data analysis.
  • Describe how user and application access can be easily managed.
  • Apply Snowflake’s recommended best practices for working with semi‐structured data.
  • Discuss Snowflake’s unique approach to caching.
  • Implement the options provided to connect and interact with the Snowflake AI Data Cloud.
  • Employ Snowflake’s continuous data protection features.
  • Utilize data sharing to send your data in real‐time to Customers and Partners.
  • Scale your Virtual Warehouses to improve performance and address concurrency needs.
  • Explain the different ways you can manage and monitor your Snowflake account.
  • Summarize Snowflake’s AI and ML capabilities.

Who is Snowflake Fundamentals Training for?

  • Data Analysts
  • Data Engineers
  • Data Scientists
  • Database Architects
  • Database Administrators

What are the prerequisites for Snowflake Fundamentals Training?

  • Recommended completion of the “Snowflake Multi‐Factor Authentication (MFA) Essentials” free on‐demand course.
  • Previous Data Warehouse knowledge is assumed.

Available Training Modes

Live Online Training

4 Days

Classroom Training

4 Days

Course Outline Expand All

Expand All

  • Overview
  • Snowflake Structure
  • Using Snowsight
  • Storage Layer
  • ComputeLayer
  • Cloud Services Layer
  • Snowgrid
  • Generative AI
  • Connection Options
  • SnowSQL
  • Visualizations in Snowsight
  • Cloning
  • TimeTravel
  • Fail‐safe
  • Introduction to Replication
  • Tables, Views, and Data Types
  • Transactions
  • Standard SQL and Snowflake
  • Collation
  • Multi‐table Inserts
  • QueryTags
  • Working with Parameters
  • Overview
  • Metadata
  • QueryResult Cache
  • Data Cache
  • Using Explain
  • QueryProfile
  • SQLPerformance Tips
  • Data Loading Objects
  • Data Loading Process
  • Transformations and Copy Options
  • Data Loading Recommendations
  • Continuous Data Loading
  • Unloading Data
  • User‐defined Functions
  • Stored Procedures
  • Snowflake Scripting
  • Tasks Overview
  • Creating Tasks
  • Managing Tasks
  • Streams Overview
  • Dynamic Tables Overview
  • Security Overview
  • Access
  • Authentication
  • Authorization
  • Data Protection
  • Trust Center
  • Concepts
  • Types of Roles
  • Ownership
  • ViewGrants
  • Overview
  • QuerySemi‐structured Data
  • Snowflake Data Sharing Overview
  • Shares
  • Types of Virtual Warehouse Scaling
  • Auto‐scaling Policies
  • Overview
  • Visibility
  • Control
  • Optimization
  • Overview of Cortex LLM Functions
  • Overview of Snowflake ML Functions

Who is the instructor for this training?

The trainer for this Snowflake Fundamentals Training has extensive experience in this domain, including years of experience training & mentoring professionals.

Reviews