Data Transformation with DBT

TDXBI-110


55 Hours

Download Full Syllabus Request a Quote
All Our Courses Now Also LIVE

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

Modules

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

Prerequisites

  • SQL – must
  • Python – nice to have.
  • Git – nice to have.

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

Target Audience

Contact Us

    • Israel
    • Poland
    • USA
    • India
    Skip to content