Data Build Tool (DBT)

Gain the fundamental skills of an advanced data transformation tool by enrolling in DASVM Technologies DBT training. Our certified trainer will make you an expert in transforming, testing, and documenting data in the cloud data warehouse. In this DBT certification course, you will gain a clear understanding of areas like DBT fundamentals, DBT cloud configuration, Tests, Models, Sources, Documentation, Jinja Primer, Materializations, Deployment, Packages, Analyses, and Seeds, Macros, and much more through real-time examples. During this training, you will be working on two real-time projects to gain hands-on experience. Learn DBT from industry top professionals by enrolling in our DBT data-built tool certification training program.

img
request

Can’t find a batch you were looking for?

 

Gain the fundamental skills of an advanced data transformation tool by enrolling in DASVM Technologies DBT training. Our certified trainer will make you an expert in transforming, testing, and documenting data in the cloud data warehouse. In this DBT certification course, you will gain a clear understanding of areas like DBT fundamentals, DBT cloud configuration, Tests, Models, Sources, Documentation, Jinja Primer, Materializations, Deployment, Packages, Analyses, and Seeds, Macros, and much more through real-time examples. During this training, you will be working on two real-time projects to gain hands-on experience. Learn DBT from industry top professionals by enrolling in our DBT data-built tool certification training program.

 

Course Objectives:
 

The following are the core objectives of this DBT certification training course:

 
  • Fundamentals of Data Built Tool
  • Why do we use DBT?
  • Configuring DBT locally and in the cloud
  • Connect DBT to a Database
  • Creation of SQL transformations
  • Testing underlying data and SQL transformation
  • Scheduling transformations
  • Testing code in a dev environment
  • Data built tool best practices
  • Materialization
  • Models Integration
  • Seeds & Sources
  • Source Integration & Freshness
  • Slowly Changing Dimensions
  • Analyses and Hooks
  • Macros
  • Documentation
 

Course content

 

DBT – Data Engineering Basics
  • Traditional Data Teams
  • Analytics Engineer
  • ETL vs ELT
  • Overview of Modern Data Stack
  • Learn DBT
Introduction to DBT Fundamentals
  • What is DBT
  • DBT Features
  • DBT Maturity Model
  • Data Platforms
  • Version Control
  • DBT Cloud Configuration
  • DBT Cloud UI
  • Typical data transformation challenges
  • How does DBT eliminate traditional Data challenges?
Set up DBT Cloud
  • Data Built Tool and databases
  • Version Control
  • Data loading into the data warehouse
  • Data repository set up & connect to DBT cloud
  • Fundamentals of DBT cloud IDE
  • The process to connect to Repository
  • The process to connect to your warehouse
Models
  • Overview of Models and types
  • The process to build a model
  • Basics of modularity
  • Ref functions
  • Data modeling fundamentals
  • Naming conventions
  • Project reorganization
Lab:
  • Writing Models
  • Interpolating a schema using ref()

Tests
  • What is Testing?
  • Need of Testing
  • Testing in DBT
  • Testing Sources
  • Data tests
  • Schema tests
  • Live test scenarios
Lab:
  • Adding Tests to a Project
  • Executing a custom data test
  • Writing a schema test
Documentation
  • Fundamentals of Documentation
  • Importance of documentation
  • The process to write doc blocks
  • Documentation writing
  • Documentation generation and view
  • Working with real-time documentation & gaining hands-on experience.
Sources
  • Introduction to Sources
  • Source Configuration
  • Selecting from sources
  • Testing Sources
  • Documenting Sources
  • Source Freshness
  • Working with real-time source scenarios.
Lab:
  • Assigning Sources
  • Configuration of source freshness
  • Writing Models
Deployment
  • What is Deployment
  • The process to schedule a job in the DBT cloud
  • Reviewing scheduled jobs.
Jinja Premier
  • Introduction to Jinja
  • Jinja fundamentals
  • Jinja basics
  • Jinja applications
  • Working with real-time Jinja scenarios.
Macros
  • What are Macros?
  • Cents to dollar Macros
  • Dry code vs readability
  • Limit data in dev macro
Packages
  • What are packages
  • Packages with Macros
  • Installing packages
  • Packages with models
Materializations
  • Introductions to Materialization
  • Tables, views
  • Ephemeral models
  • What are snapshots?
  • Snapshot implementations
Analyses & Seeds
  • What are analyses?
  • Implementing analysis
  • What are seeds?
  • Implementing Seeds
Snapshot
  • What is Snapshot
  • Why Snapshots are Important
  • Snapshot Configuration
  • Working with Snapshots
Lab:
  • Configuring a Snapshot of a source
  • Configuring a Snapshot to a Table
DBT – Refactoring
  • Migrating Code
  • Translating Code
  • Cosmotec Cleanups
  • Staging Models
DBT Incremental Models
  • Overview Incremental Models
  • Incremental Load Configuration
  • Work with incremental models
Advanced DBT
  • DBT Environment
  • Configuring DBT for zero-copy clones
  • Pull request handling
  • Continuous Integration
  • Scheduled Runs

 

To see the full course content Download now

Course Prerequisites

 

The participant should have a basic knowledge of the below areas in order to learn DBT:

 
  • GitHub
  • SQL
  • Possess knowledge to work in the command line
  • Data warehousing Concepts

Who can attend

 

Following are the professionals who can join this course to advance their skill set:

 
  • Data Analysts
  • Data Scientists
  • Data Engineering aspirants
  • Data Analytics Managers
  • Snowflake Developers
  • Redshift Developers
  • ETL developers
  • Candidates who work with data transformation operations.

Number of Hours: 40hrs

Certification

 
DBT Certified Developer

Key features

  • One to One Training
  • Online Training
  • Fastrack & Normal Track
  • Resume Modification
  • Mock Interviews
  • Video Tutorials
  • Materials
  • Real Time Projects
  • Virtual Live Experience
  • Preparing for Certification

FAQs

DASVM Technologies offers 300+ IT training courses with 10+ years of Experienced Expert level Trainers.

  • One to One Training
  • Online Training
  • Fastrack & Normal Track
  • Resume Modification
  • Mock Interviews
  • Video Tutorials
  • Materials
  • Real Time Projects
  • Materials
  • Preparing for Certification

Call now: +91-99003 49889 and know the exciting offers available for you!

We working and coordinating with the companies exclusively to get placed. We have a placement cell focussing on training and placements in Bangalore. Our placement cell help more than 600+ students per year.

Learn from experts active in their field, not out-of-touch trainers. Leading practitioners who bring current best practices and case studies to sessions that fit into your work schedule. We have a pool of experts and trainers are composed with highly skilled and experienced in supporting you in specific tasks and provide professional support. 24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts. Our trainers has contributed in the growth of our clients as well as professionals.

All of our highly qualified trainers are industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo before they are certified to train for us. We also ensure that only those trainers with a high alumni rating continue to train for us.

No worries. DASVM technologies assure that no one misses single lectures topics. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. If required you can even attend that topic with any other batches.

DASVM Technologies provides many suitable modes of training to the students like:

  • Classroom training
  • One to One training
  • Fast track training
  • Live Instructor LED Online training
  • Customized training

Yes, the access to the course material will be available for lifetime once you have enrolled into the course.

You will receive DASVM Technologies recognized course completion certification & we will help you to crack global certification with our training.

Yes, DASVM Technologies provides corporate trainings with Course Customization, Learning Analytics, Cloud Labs, Certifications, Real time Projects with 24x7 Support.

Yes, DASVM Technologies provides group discounts for its training programs. Depending on the group size, we offer discounts as per the terms and conditions.

We accept all major kinds of payment options. Cash, Card (Master, Visa, and Maestro, etc), Wallets, Net Banking, Cheques and etc.

DASVM Technologies has a no refund policy. Fees once paid will not be refunded. If the candidate is not able to attend a training batch, he/she is to reschedule for a future batch. Due Date for Balance should be cleared as per date given. If in case trainer got cancelled or unavailable to provide training DASVM will arrange training sessions with other backup trainer.

Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.

Please Contact our course advisor +91-99003 49889. Or you can share your queries through info@dasvmtechnologies.com

like our courses