Catalogue
/
Data Engineering
/
Snowflake Cloud Data Warehousing and Enterprise Data Platform

Snowflake Cloud Data Warehousing and Enterprise Data Platform

A practical four day technical course for participants who are new to Snowflake and want to become productive quickly with cloud data warehousing and enterprise data platform workloads. The agenda progresses from Snowflake architecture, SQL, and data modeling through data loading, transformations, pipelines, security, administration, and performance optimization. The course emphasizes reliable enterprise patterns and the practical decisions needed to build, operate, and optimize Snowflake environments.

What will you learn?

You will learn how Snowflake separates storage, compute, and platform services and how this architecture affects data engineering, analytics, security, and cost. You will work with Snowflake SQL, warehouses, stages, loading, Dynamic Tables, Streams, Tasks, roles, privileges, and administrative capabilities. You will also learn how to design and operate maintainable data pipelines and optimize production workloads for performance and efficient resource use.

  • Build and query structured and semi-structured datasets using Snowflake SQL
  • Implement batch, continuous, and incremental data loading and transformation pipelines
  • Configure roles, privileges, warehouses, and core administrative controls
  • Monitor and optimize Snowflake workloads for reliable production operation

Requirements:

  • Technical background in software development, data engineering, analytics, databases, or a related field
  • Basic SQL knowledge
  • General understanding of databases and data processing concepts
  • Previous Snowflake experience is not required

Course Outline*:

*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

Hands-on learning with expert instructors at your location for organizations.

7,722€*
Graph Icon - Education X Webflow Template
Level:
advanced
Clock Icon - Education X Webflow Template
Duration:
28
Hours (days:
4
)
Camera Icon - Education X Webflow Template
Training customized to your needs
Star Icon - Education X Webflow Template
Immersive hands-on experience in a dedicated setting
*Price can range depending on number of participants, change of outline, location etc.

Master new skills guided by experienced instructors from anywhere.

6,087€*
Graph Icon - Education X Webflow Template
Level:
advanced
Clock Icon - Education X Webflow Template
Duration:
28
Hours (days:
4
)
Camera Icon - Education X Webflow Template
Training customized to your needs
Star Icon - Education X Webflow Template
Reduced training costs
*Price can range depending on number of participants, change of outline, location etc.

Upcoming Sessions

11-14 Jan 2027
Berlin
18-21 Jan 2027
Stockholm
1-4 Mar 2027
Frankfurt
22-25 Mar 2027
Milan
5-8 Apr 2027
Stockholm
24-27 May 2027
Stockholm
14-17 Jun 2027
Paris

Can't find a suitable date? Get in touch and we'll arrange one that works for you.

We use cookies to improve site navigation, analyse how the site is used, and support our marketing. You can accept all cookies, reject non-essential ones, or choose individual categories. Read our Cookie Notice