Virtual Snowflake Bootcamp
- Event Type: 🌐 Virtual Event
- Start: Mar 23, 2026 9:00 AM EDT
- End: Mar 26, 2026 5:00 PM EDT
- Cost: $1,995.00
- Instructor: Greg Trzeciak
- Event Categories:
- Available Seats: Limited seats remaining!
- Tickets: Get your ticket HERE
- Need help convincing your boss? We can help.
🌐 Virtual Event
Event description
Snowflake is a modern cloud data platform that enables scalable, secure, and high-performance analytics across multiple clouds. This bootcamp will guide you through the essentials of Snowflake, from architecture and core objects to advanced topics like performance tuning, security, automation, and integration with BI tools. Each day combines instructor-led slides, live demos, and hands-on labs to reinforce learning.
Prerequisites
This class is designed for data professionals, analysts, and engineers looking to leverage Snowflake for cloud data warehousing and analytics. Basic familiarity with SQL and database concepts (tables, schemas, roles) is recommended. Ideally, students should also have a basic understanding of database terminology such as tables, views, columns, rows, etc.
System Requirements
- Modern web browser (Chrome, Edge, Firefox)
- Snowflake trial account (provided or self-signup)
- Sample datasets (CSV, JSON)
- Optional: Power BI Desktop for integration labs
Course Outline:
- Module 1: Snowflake Foundations
- Overview of Cloud Data Warehousing
- What is Snowflake? Key Features & Benefits
- Snowflake vs. Traditional Data Warehouses
- Navigating Snowsight and Classic UI
- Creating and Managing Worksheets
- Module 2: Architecture & Core Objects
- Snowflake Architecture: Storage, Compute, Services
- Databases, Schemas, and Table Types (Permanent, Transient, Temporary)
- File Formats, Stages, and COPY INTO Basics
- Module 3: Data Handling & Performance
- Writing SQL in Snowflake: Querying Basics
- Data Types, Constraints, and Clustering
- Query Profiling, Caching, and Query Pruning
- Views vs. Materialized Views
- Time Travel and Fail-Safe
- Module 4: Semi-Structured Data & Integration
- Working with JSON & Semi-Structured Data (FLATTEN, LATERAL)
- External Stages & COPY INTO Deep Dive (AWS S3, Azure Blob)
- Power BI, Excel, and Tool Integration
- Zero Copy Cloning & Dev/Test Scenarios
- Module 5: Security, Governance, & Sharing
- Role-Based Access Control (RBAC)
- Row-Level Security (Row Access Policies)
- Masking Policies & Dynamic Data Masking
- Data Sharing with Reader Accounts
- Snowflake Marketplace
- Module 6: Automation & Modern Workflows
- Streams & Tasks for CDC and Automation
- Snowpipe for Continuous Loading
- Scheduling and Orchestration of Data Pipelines
- Monitoring and Alerting for Automated Workflows
- Best Practices for Automation in Snowflake
- Module 7: Administration
- User and Role Management
- Resource Monitoring and Usage
- Managing Warehouses and Scaling
- Account and Billing Management
- Best Practices for Administration
- Module 8: Wrap-up and Feedback
- Final Q&A, Wrap-up, and Feedback Collection
Get tickets:
| Ticket type | Price | Quantity |
|---|---|---|
| Virtual Snowflake Bootcamp (Mar 23, 2026 – 3/26/26) | $1,995.00 | |
Add an event to your calendar
Instructor – Greg Trzeciak
Gregory Trzeciak has his master’s degree in Education from the University of Florida. He has 9 years of teaching experience in high school, college level, and summer programs where he was recognized as a top educator and leader in interactive education. As a trainer at Pragmatic Works, his primary goal is to help individuals gain confidence in using Power BI and the Power Platform. While not in the office, he enjoys fantasy football, walking his dog, and running half-marathons!