Snowflake · Intermediate

Snowflake Data Engineering Bootcamp

For data engineers and SQL developers who want to build reliable, cost-aware pipelines on Snowflake.

A hands-on bootcamp that takes you from Snowflake fundamentals to production-style ELT: loading, transforming, securing and monitoring data, with realistic business scenarios throughout.

Duration
24 hours
Mode
Live online
Next batch
To be announced
Schedule
Sat–Sun, 10am–1pm IST

Who it is for

Data engineers, ETL/BI developers and database professionals moving to Snowflake.

Prerequisites

Comfortable writing SQL (joins, aggregations). Basic understanding of data warehousing concepts.

What you will be able to do

  • Design Snowflake databases, schemas and warehouses for a real workload
  • Load batch and continuous data with COPY, stages and Snowpipe
  • Build incremental ELT with streams, tasks and dynamic tables
  • Apply role-based access, masking and cost controls
  • Review AI-assisted SQL critically before it runs

Course contents · 5 modules · 24 hours

01
Snowflake architecture and setup

Storage, compute and services layers; warehouses; databases and schemas; roles and cost basics

4 h
02
Loading data

Stages, file formats, COPY INTO, Snowpipe, semi-structured data with VARIANT

5 h
03
Transformations and ELT

Streams, tasks, dynamic tables, MERGE patterns, incremental loads, time travel

6 h
04
Security and governance

RBAC design, masking and row access policies, tagging, data sharing

4 h
05
Performance, cost and capstone

Clustering, query profile, resource monitors; end-to-end capstone reviewed by the trainer

5 h

Hands-on approach

30% concepts, 70% hands-on labs on realistic business scenarios. AI practice support between sessions; every project is reviewed by the trainer.