Data Engineering

Data Engineering

dbt

dbt

⚡Intermediate

⚡Intermediate

Data Transformation & Modeling with dbt

Data Transformation & Modeling with dbt

Data Transformation & Modeling with dbt

Master data transformations & modeling with dbt in this 40-hour course. Build modular SQL models, implement data quality tests, document your transformations, and prepare analytics-ready datasets.

Master data transformations & modeling with dbt in this 40-hour course. Build modular SQL models, implement data quality tests, document your transformations, and prepare analytics-ready datasets.

Master data transformations & modeling with dbt in this 40-hour course. Build modular SQL models, implement data quality tests, document your transformations, and prepare analytics-ready datasets.

HURRY ONLY 10 SEATS LEFT

HURRY ONLY 10 SEATS LEFT

HURRY ONLY 10 SEATS LEFT

17,999

17,999

17,999

20,999

20,999

20,999

14

14

14

% OFF

% OFF

% OFF

New Batch Starts on

New Batch Starts on

July 1, 2025

July 1, 2025

Limited seats only

Limited seats only

20 Students

20 Students

Course Duration

Course Duration

40 Hours

40 Hours

Registration Closes

Registration Closes

June 25, 2025

June 25, 2025

June 25, 2025

Course Overview

Course Overview

A 40-hour hands-on course designed to teach you how to transform, model, and test data directly inside cloud data warehouses and lakehouses using dbt (data build tool). Learn to create modular SQL models, implement data quality tests, and follow modern analytics engineering best practices.

A 40-hour hands-on course designed to teach you how to transform, model, and test data directly inside cloud data warehouses and lakehouses using dbt (data build tool). Learn to create modular SQL models, implement data quality tests, and follow modern analytics engineering best practices.

What will be learned

What will be learned

Understand modern ELT & analytics engineering concepts

Understand modern ELT & analytics engineering concepts

Set up dbt Core & dbt Cloud for transformations

Set up dbt Core & dbt Cloud for transformations

Build modular SQL models using Jinja & dbt macros

Build modular SQL models using Jinja & dbt macros

Implement data tests & documentation

Implement data tests & documentation

Version control & CI/CD with Git & dbt Cloud

Version control & CI/CD with Git & dbt Cloud

Orchestrate dbt models with Airflow or Prefect

Orchestrate dbt models with Airflow or Prefect

Meet the Mentor!

Deepak Surya

CEO at Wiates

Chennai, TN

English, Tamil

5.0

Fast and consistent responses

About Me

Hi, I’m a certified AWS Cloud Engineer with over 14 years of experience . As your mentor, my goal is to simplify cloud concepts and guide you step-by-step through real-world AWS scenarios. Whether you're just starting out or aiming to build a cloud career, I’m here to share the best practices, tools, and hands-on tips that have helped me in the field. Let’s dive into AWS — one service at a time!

Meet the Mentor!

Deepak Surya

CEO at Wiates

Chennai, TN

English, Tamil

5.0

Fast and consistent responses

About Me

Hi, I’m a certified AWS Cloud Engineer with over 14 years of experience . As your mentor, my goal is to simplify cloud concepts and guide you step-by-step through real-world AWS scenarios. Whether you're just starting out or aiming to build a cloud career, I’m here to share the best practices, tools, and hands-on tips that have helped me in the field. Let’s dive into AWS — one service at a time!

Meet the Mentor!

Deepak Surya

CEO at Wiates

Chennai, TN

English, Tamil

5.0

Fast and consistent responses

About Me

Hi, I’m a certified AWS Cloud Engineer with over 14 years of experience . As your mentor, my goal is to simplify cloud concepts and guide you step-by-step through real-world AWS scenarios. Whether you're just starting out or aiming to build a cloud career, I’m here to share the best practices, tools, and hands-on tips that have helped me in the field. Let’s dive into AWS — one service at a time!

Tech Career Program Highlights

Tech Career Program Highlights

Tech Career Program Highlights

Transform raw data into analytics-ready models in warehouses/lakehouses

Transform raw data into analytics-ready models in warehouses/lakehouses

Implement data quality tests & maintain reliable transformations

Implement data quality tests & maintain reliable transformations

Build incremental models for large datasets

Build incremental models for large datasets

Document & share transformations with teams

Document & share transformations with teams

Integrate dbt models with orchestration tools (Airflow/Prefect)

Integrate dbt models with orchestration tools (Airflow/Prefect)

Syllabus Overview

Syllabus Overview

Syllabus Overview

Week 1

Modern ELT & dbt Basics

Week 1

Modern ELT & dbt Basics

Week 1

Modern ELT & dbt Basics

Week 2

Building dbt Models

Week 2

Building dbt Models

Week 2

Building dbt Models

Week 3

Testing & Documentation

Week 3

Testing & Documentation

Week 3

Testing & Documentation

Week 4

Certificate

Advanced dbt Concepts

Week 4

Certificate

Advanced dbt Concepts

Week 4

Certificate

Advanced dbt Concepts

Certificate Preview

Certificate Preview

Certificate Preview

Here’s what you’ll receive after successful completion:

Here’s what you’ll receive after successful completion:

Here’s what you’ll receive after successful completion:

Recognized by industry-aligned institutions

Recognized by industry-aligned institutions

Recognized by industry-aligned institutions

Success Stories

Success Stories

Success Stories

  • “dbt always confused me, but this course broke it down into simple concepts. Now I can confidently build transformations.”

    Riya

    Junior Developer

  • “The staging & marts modeling patterns were explained really well. I applied the same at work.”

    Sandeep

    Junior Developer

  • “Loved how the course integrated dbt with Snowflake and GitHub CI/CD – felt like real production work.”

    Pooja

    Junior Developer

  • “The staging & marts modeling patterns were explained really well. I applied the same at work.”

    Sandeep

    Junior Developer

  • “Loved how the course integrated dbt with Snowflake and GitHub CI/CD – felt like real production work.”

    Pooja

    Junior Developer

  • “The testing & documentation part made me realize how professional analytics engineering should be done.”

    Harish

    Junior Developer

  • “dbt always confused me, but this course broke it down into simple concepts. Now I can confidently build transformations.”

    Riya

    Junior Developer

  • “The staging & marts modeling patterns were explained really well. I applied the same at work.”

    Sandeep

    Junior Developer

  • “Loved how the course integrated dbt with Snowflake and GitHub CI/CD – felt like real production work.”

    Pooja

    Junior Developer

  • “The testing & documentation part made me realize how professional analytics engineering should be done.”

    Harish

    Junior Developer

Why Join This Program?

Why Join This Program?

Why Join This Program?

Industry Standard

Industry Standard

Industry Standard

Cloud & Lakehouse Ready

Cloud & Lakehouse Ready

Cloud & Lakehouse Ready

Analytics Engineering Best Practices

Analytics Engineering Best Practices

Analytics Engineering Best Practices

Hands-On Learning

Hands-On Learning

Hands-On Learning

Career-Oriented

Career-Oriented

Career-Oriented

Portfolio-Ready

Portfolio-Ready

Portfolio-Ready

Frequently Asked Questions

Frequently Asked Questions

Frequently Asked Questions

Do I need prior dbt experience?

Do I need prior dbt experience?

Do I need prior dbt experience?

Which warehouses are used?

Which warehouses are used?

Which warehouses are used?

Do I need coding skills?

Do I need coding skills?

Do I need coding skills?

Will I get a certificate?

Will I get a certificate?

Will I get a certificate?

What’s next after this course?

What’s next after this course?

What’s next after this course?

WIATES

ACADEMY

We are an online software training platform dedicated to empowering students with the latest programming knowledge and hands-on experience to excel in their careers.

Follow us on social media for the latest updates, free learning resources, and exclusive offers.

© 2025 WIATES. All rights reserved.

WIATES

ACADEMY

We are an online software training platform dedicated to empowering students with the latest programming knowledge and hands-on experience to excel in their careers.

Follow us on social media for the latest updates, free learning resources, and exclusive offers.

Quick Links

© 2025 WIATES. All rights reserved.

WIATES

ACADEMY

We are an online software training platform dedicated to empowering students with the latest programming knowledge and hands-on experience to excel in their careers.

Follow us on social media for the latest updates, free learning resources, and exclusive offers.

Quick Links

© 2025 WIATES. All rights reserved.