Join us for a FREE hands-on Meetup webinar on Introduction to Agentic AI | Friday, March 21st, 2025 · 7:30 PM IST/ 10:00 AM EDT Join us for a FREE hands-on Meetup webinar on Introduction to Agentic AI | Friday, March 21st, 2025 · 7:30 PM IST/ 10:00 AM EDT
Search
Close this search box.
Search
Close this search box.

Snowflake Fundamentals

Mastering the Basics of Cloud Data Warehousing with Snowflake

Duration

4 Days

Level

Fundamentals Level

Design and Tailor this course

Official Course

Edit Content

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

ACQUIRED SKILLS

  • Outline the unique and differentiated architecture of the Snowflake 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 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 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.
Edit Content
  • Data Analysts
  • Data Engineers
  • Data Scientists
  • Database Architects
  • Database Administrators
Edit Content
  • Overview of Snowflake
  • Snowflake Structure
  • Using Snowsight
  • Storage Layer
  • Compute Layer
  • Cloud Services Layer
  • Snowgrid
  • Connection Options
  • SnowSQL
  • Cloning
  • Time Travel
  • Fail-safe
  • Introduction to Replication
  • Tables, Views, and Data Types
  • Transactions
  • Standard SQL and Snowflake
  • Estimation Functions
  • Sampling
  • Collation
  • Multi-table Inserts
  • Query Tags
  • Working with Parameters
  • Overview
  • Metadata
  • Query Result Cache
  • Data Cache
  • Using Explain
  • Query Profile
  • SQL Performance 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
  • Overview
  • Creating Tasks
  • Managing Tasks
  • Security Overview
  • Access
  • Authentication
  • Authorization
  • Data Protection
  • Concepts
  • Types of Roles
  • Ownership
  • View Grants
  • Overview
  • Query Semi-structured Data
  • Snowflake Data Sharing Overview
  • Shares
  • Types of Virtual Warehouse Scaling
  • Auto-scaling Policies
  • Overview
  • Visibility
  • Control
  • Optimization
Edit Content

Previous Data Warehouse knowledge is assumed.

Connect

we'd love to have your feedback on your experience so far