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
01Snowflake architecture and setupStorage, compute and services layers; warehouses; databases and schemas; roles and cost basics
4 h 02Loading dataStages, file formats, COPY INTO, Snowpipe, semi-structured data with VARIANT
5 h 03Transformations and ELTStreams, tasks, dynamic tables, MERGE patterns, incremental loads, time travel
6 h 04Security and governanceRBAC design, masking and row access policies, tagging, data sharing
4 h 05Performance, cost and capstoneClustering, 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.