Snowflake DBT Course Online

22 Lesson

32 Hours

Add to Wishlist

igmGuru offers the best Snowflake DBT course online worldwide. This comprehensive data engineering training program covers key topics such as Snowflake architecture, SQL fundamentals, real-time data loading, DBT models and snapshots, ADF pipeline integration, and more. These Snowflake and DBT course modules are designed by industry experts with over 12 years of experience in real-time Snowflake projects and cloud data integration. Enroll in the Snowflake DBT training today to master end-to-end Snowflake development and prepare for real-world data engineering roles.

Enroll Now

Overview

Prerequisites:

Basic understanding of SQL
Familiarity with data warehousing concepts
Awareness of cloud computing fundamentals
No prior experience with Snowflake, DBT, or ADF required

What You Will Learn:

Real-time Snowflake tasks based on business requirements
Hands-on practice with Snowflake, DBT, ADF, and AWS
End-to-end Snowflake development with real-time project implementation
SQL basics and advanced concepts (joins, constraints, functions, etc.)
Snowflake architecture, roles, virtual warehouses, and database objects
Data loading/unloading (on-premise and cloud sources)
Snowpipe and continuous data loading
Handling semi-structured data (JSON, XML)
Time Travel, Fail Safe, and Zero Copy Cloning
Streams, Tasks, and Change Data Capture (CDC)
Data sharing, secure views, and reader accounts
UDFs, procedures, performance tuning, and masking policies
Working with dates and timestamps
DBT features: models, seeds, snapshots, materializations, macros, Git integration
ADF pipeline creation and Snowflake integration
Resume building and interview preparation with Q&A

Key Features

Instructor Led Training : 32Hrs
Experienced & Professional Trainers
24 X 7 Lifetime Support & Access
1 On 1 Training Option Available

Course Curriculum

Lesson 1 - SQL Basics

1. Basics of RDMBS

2. DDL, DML, DQL and TCL Commands

3. Operators in Oracle (And, OR, Not, IN, LIKE, Between)

4. Null, Not Null

5. Order By in Oracle

6. Group By, Group functions and Having Clause

7. Constraints (Not Null, Unique, Primary key, Foreign Key and Check)

8. Joins (Inner join, Left outer, right outer, Full outer joins, Self-join and Cross join)

9. Set Operators (Union, Union All, Intersect, Minus)

10. Rank and Dense Rank functions

11. Views and indexes

Lesson 2 - Snowflake - Architecture and Concepts

1. Key Concepts & Architecture

2. Cloud Platforms

3. Snowflake Editions

4. Overview of Key Features

Lesson 3 - Connecting to Snowflake

1. Overview of the Ecosystem

2. Snowflake Partner Connect

3. SnowSQL (CLI Client) - Installation, Configuring and Usage

4. Lab – Snowsql Lab & Exercises

Lesson 4 - Roles and Users in snowflake

1. Creation of Roles

2. Creation of Users

3. Explanation of Roles and Users Management

Lesson 5 - Virtual Warehouses in Snowflake

1. Creation of Virtual Warehouses

2. Resource Monitors Management and Alerts

3. Explanation of Virtual Warehouses Privileges

Lesson 6 - Database Objects and Storage in Snowflake

1. Creation of Databases and Schema

2. Explanation of Databases and Schema Privileges

3. Creation Types of Tables

4. Explanation of Table Privileges

5. Explanation of Snowflake Cache Layer

Lesson 7 - Snowflake Time Travel and Fail Safe

1. Time Travel

2. Time Travel considerations

3. Fail Safe - Recovery

4. Lab – Time Travel and Fail-Safe Lab & Exercises

Lesson 8 - Zero Copy Cloning in Snowflake

1. Explanation of zero copy cloning using different object

2. What can be cloned and what cannot

Lesson 9 - Types of Stages

1. Internal Stages

2. External Stage

Lesson 10 - Loading into Snowflake (On-Premises to Cloud)

1. Overview of Data Loading/Unloading

2. Bulk Data Loading/Unloading from a Local File System

3. Loading Using the Web Interface (Limited)

4. Querying Data in Staged Files

5. Troubleshooting Bulk Data Loads

6. Lab – Data Loading / Unloading Lab & Exercises

Lesson 11 - Loading into Snowflake (Cloud to Cloud)

1. AWS Integration Process

2. AWS to Snowflake Data Loading

Lesson 12 - Continuous Data Loading into Snowflake -

1. Continuous Data Loading using Snowpipe

2. Snowpipe Configuration

Lesson 13 - Loading Semi Structure Data into Snowflake

1. Loading Semi-Structure data from on-premises to cloud

2. JSON and XML

Lesson 14 - Advance Topics

1. Streams and Tasks

2. Types of SCD’s

3. Email Notification creation

4. Lab – Streams & Tasks Lab & Exercises

Lesson 15 - Sharing Data and Views in Snowflake

1. Introduction to Data Sharing, Data Providers, Data Consumers, Working with Shares

2. Using Secure Objects to Control Data Access, Configuring a Reader Account, Managing Reader Accounts, Lab – Data Sharing Exercises

Lesson 16 - UDF and Procedures

1. Analytical Functions, User Defined Functions, Procedures

Lesson 17 - Performance Tuning

1. Query Tuning, Clustering, Micro Partitions, Materialized Views, Performance Considerations

Lesson 18 - Masking Policies – Column Level and Row Level

1. Column level Masking Policies, Row level Masking Policies

Lesson 19 - Working With Dates and Time Stamps

1. Dates and time Stamps, Date and Time Stamp conversions

Lesson 20 - DBT Topics

1. DBT Overview, Models, Materialization, Source and Seed, Snapshot, Macros, Exposures, Git integration

Lesson 21 - Pipelines from ADF to Snowflake

1. Creation of Azure Blob storage

2. ADF Pipeline configuration and set up

3. Data Load from Azure Blob to Snowflake using ADF

Lesson 22 - Realtime Project with Explanation using Snowflake, DBT and ADF

1. Unix Basic Commands

2. Interview Questions

3. Resume Building

Talk To Us

We are happy to help you

1-800-7430-173 (US Toll Free)

+91 7240740740 (India)

Drop Us a Query

Fields marked * are mandatory

Name

Phone Number

Comments

Request For Live Demo Class

Course Fees

SELF PACED LEARNING

US $ 299.00

Refund Policy

Duration : 32 hrs
Lifetime Free Upgrade
Reference Documents
24x7 Support & Access

Online Class Room Program

US $ 699.00

100% Money Back Guarantee

Duration : 32 Hrs
Plus Self Paced

Classes Starting From

Fast Track Batch 07 Jul 2026
Weekday Batch 13 Jul 2026
Weekend Batch 11 Jul 2026

Corporate Training

Customized Training Delivery Model
Flexible Training Schedule Options
Industry Experienced Trainers
24x7 Support

Trusted By Top Companies Worldwide

Want to know Today's Offer

Snowflake DBT Certification

Upon successful completion of the Snowflake DBT course and final project, learners will receive a Snowflake DBT Course Completion Certificate from igmGuru, validating your knowledge and practical skills in Snowflake data warehousing, DBT development, and cloud data integration.

Reviews

Login

Email ID*

Password*

Forgot Password?