*We customize the course outline and content to your specific needs and relevant use cases.
Module 1: Snowflake architecture and platform fundamentals
- Understanding the separation of database storage, compute, and cloud services
- Understanding Snowflake accounts, databases, schemas, tables, and other core objects
- Working with virtual warehouses as independent compute resources
- Navigating Snowsight and understanding the main development and administration areas
Module 2: Working with Snowflake SQL
- Creating databases, schemas, tables, views, and other common objects
- Querying, filtering, joining, aggregating, and transforming relational data
- Using common SQL functions, expressions, and analytical functions
- Working with transactions and understanding Snowflake SQL behavior
Module 3: Data types and semi-structured data
- Working with standard Snowflake numeric, string, date, time, and Boolean data types
- Understanding VARIANT, OBJECT, and ARRAY for semi-structured information
- Loading and querying JSON and other semi-structured data
- Using FLATTEN and path expressions to transform nested structures
Module 4: Data modeling for analytics
- Designing tables and views for analytical workloads
- Understanding dimensional modeling concepts in a Snowflake environment
- Separating raw, transformed, and consumption-oriented datasets
- Choosing appropriate table and view structures for maintainability and reuse
Module 5: Stages and bulk data loading
- Understanding internal and external stages
- Creating file formats for common structured and semi-structured files
- Loading data with COPY INTO and validating incoming files
- Handling rejected rows, loading errors, and load history
Module 6: Continuous ingestion with Snowpipe
- Understanding the difference between bulk loading and continuous ingestion
- Configuring Snowpipe concepts for automated file ingestion
- Understanding Snowpipe Streaming and when streaming ingestion is appropriate
- Selecting ingestion patterns based on volume, latency, and source architecture
Module 7: Incremental transformation with Streams and Tasks
- Using Streams to capture inserted, updated, and deleted records
- Creating scheduled and triggered Tasks for transformation processing
- Combining Streams and Tasks for incremental data pipelines
- Building task dependencies and understanding task graph concepts
Module 8: Declarative pipelines with Dynamic Tables
- Understanding Dynamic Tables and target lag
- Creating multi-stage SQL transformation pipelines
- Comparing Dynamic Tables with Streams and Tasks
- Selecting declarative or procedural pipeline patterns based on transformation requirements
Module 9: Snowflake access control fundamentals
- Understanding roles, users, privileges, ownership, and securable objects
- Building role hierarchies using custom account roles
- Granting database, schema, table, and warehouse privileges
- Applying least privilege principles to common enterprise access patterns
Module 10: Advanced data access and protection concepts
- Using database roles and managed access schemas
- Understanding future grants and scalable privilege management
- Introducing masking policies, row access policies, and secure views
- Separating administrative, engineering, analytics, and consumer responsibilities
Module 11: Warehouse and resource administration
- Creating, sizing, suspending, resuming, and configuring virtual warehouses
- Understanding auto-suspend, auto-resume, and multi-cluster concepts
- Separating workloads across warehouses for isolation and predictable performance
- Monitoring warehouse activity, utilization, and credit consumption
Module 12: Account operations and administrative monitoring
- Understanding system roles and administrative responsibilities
- Using account usage and information schema views for operational visibility
- Reviewing query history, login activity, object usage, and storage information
- Establishing basic operational processes for users, roles, warehouses, and data objects
Module 13: Query performance analysis
- Reading query profiles and identifying expensive execution stages
- Understanding pruning, scanning, joins, aggregation, and data movement
- Identifying warehouse queuing, memory pressure, and inefficient queries
- Using query history and workload information to investigate recurring performance issues
Module 14: Storage and query optimization
- Understanding micro-partitioning and data pruning
- Recognizing when clustering can improve large table performance
- Introducing Search Optimization Service, materialized views, and query acceleration
- Selecting optimization techniques based on workload behavior rather than applying them universally
Module 15: Designing production data pipelines
- Combining ingestion, transformation, orchestration, and curated data layers
- Designing pipelines for incremental processing, retries, and recoverability
- Managing dependencies and deciding between Dynamic Tables, Streams, and Tasks
- Separating development, testing, and production configurations
Module 16: Production readiness and cost-aware operation
- Monitoring pipelines, warehouses, query performance, and operational failures
- Balancing warehouse size, concurrency, performance, and credit consumption
- Establishing standards for access control, deployment, troubleshooting, and ownership
- Building a practical production readiness checklist covering reliability, security, performance, cost, and maintainability