Data Transformation with DBT

55 Hours

TDXBI-110

Course outline

DBT is an open-source command line tool designed for data transformation in the context of data warehousing. This course equips data professionals with the skills to build and manage robust data pipelines using DBT, to achieve efficient data transformation and optimized ETL processes. Through lectures and hands-on exercises, participants will gain a comprehensive understanding of the core concepts, methodologies, and practical applications of DBT.

1. Understand the fundamental concepts and principles of DBT. 2. Learn to set up and configure DBT projects effectively. 3. Master the creation and management of models using DBT. 4. Explore advanced features and capabilities of DBT. 5. Apply DBT to real-world scenarios through hands-on case studies and practical exercises.

Upcoming meetings

There are no upcoming meetings for this course.
Contact us to schedule this course, which will be customized specifically for your organization.
info@hackerupro.com
Download Full Syllabus

Modules

  • Introduction to DBT
  • key concepts
  • Installation
  • DBT project structure and environmentModeling with DBT
  • Models
  • Materialization
  • jinja
  • Macros
  • Hooks
  • Seeds
  • snapshots
  • Testing
  • Sources
  • Variables
  • Packages
  • DBT run options

Prerequisites

  • 01 SQL – must
  • 02 Python – nice to have.
  • 03 Git – nice to have.

Target Audience

  • This course is designed for data engineers, BI developers, DBA, ETL developers, and data analysts who want to streamline their data transformation workflows using DBT.

Contact us

    Skip to content