# advanced dbt Day 1 Lecture

> Advanced Jinja, macros, and incremental models are key topics in this lesson, designed for data engineers looking to enhance their DBT skills. Participants will learn how to leverage Jinja for writing dynamic SQL, utilize macros for reusable code snippets, and implement incremental models to optimi…

- Web page: https://www.dataexpert.io/lesson/advanceddbtday1lecture-jan2026
- Program: [Winter 2026 Analytics Engineering Camp](https://www.dataexpert.io/program/winter-2026-snowflake-boot-camp)
- Access: Requires enrollment in Winter 2026 Analytics Engineering Camp
- Length: 1 h 8 min video
- Skills: SQL, ETL/ELT, dbt
- Academy: DataExpert.io Academy

## About this lesson

Advanced Jinja, macros, and incremental models are key topics in this lesson, designed for data engineers looking to enhance their DBT skills. Participants will learn how to leverage Jinja for writing dynamic SQL, utilize macros for reusable code snippets, and implement incremental models to optimize data processing. The lesson covers practical examples and strategies, including append, merge, and delete-plus-insert methods, making it ideal for those seeking to improve efficiency in data transformation workflows.

## Navigation

- Previous lesson: [dbt basics Day2 Lab](https://www.dataexpert.io/lesson/dbtbasicsday2lab-jan2026.md)
- Next lesson: [advanced dbt Day 1 Lab](https://www.dataexpert.io/lesson/advanceddbtday1lab-jan2026.md)