• Post category:StudyBullet-16
  • Reading time:6 mins read


So This Course is About Teaching The DBT Framework for Data Engineers and Data Analysts for Building Data Warehouses

What you will learn

in This Course You will Master DBT the Modern mainstream Tool for Data Analytics with lots of hands on labs and examples

DBT is Well Known for the Modern Data Stack as an Essential Part of The Lake-house Architecture

you will learn how does it fit inside your Orgnization as a Solution from an architectural Standpoint

you will get Glimpse of the Tools Built around DBT and how Handy they could become when tackling Multiple Business Problems

and Last but not least we are going to infold together all the techniques to use DBT in a Developmrnt Envitonment as well as a Production Environment

we are going to Practice together how to deploy DBT Projects

Description

Data Build Tool is Becoming a Viral Tool Used Among Analysts and Data Engineers in Big corporations nowadays, especially with the fact that it’s in the center of all Modern Data Platforms like Data Warehouses and Lake-houses.

It’s become essential for these Career enthusiasts to be able to not only use it but also Master it in a Professional Context … so This Course is Designed from Scratch to help technical People unfold the tool with all its tips and tricks so that it can be Mastered … with Labs and demos to make sure that everyone is getting the hang of it.

we shall also mention some of the Most Important Tools that are built Only around DBT as being Part of the future to drive intelligence among Corporats, with lots of cool applications like governance and lineage graphs and Data Cataloging, and all of that is actually out of the box in DBT, Cool right!
just i would like to draw to your attention that, it’s kind of a MUST to know SQL, The Language of Analysts.


Get Instant Notification of New Courses on our Telegram channel.


This course also has pretty advanced topics from Other areas, we shall mention them briefly, but it’s good to have skills like git and maybe docker along the way, that would actually come to use later, other than this … our Primary focus will be on DBT

So get started !, and I wish you a happy learning experience!

English
language

Content

Welcome

Intro to Data build tool From The Beginner to Expert
About the Instructor
About The Course

Introduction to Important Concepts​

What is DBT ?​
ETL vs ELT
Programming Paradigms … Declarative VS Imperative
Types of SQL Statements​
Types of Database Engines (Adapters)​

The Idea Behind DBT​ ​

When to Use DBT​ ?
Why DBT ?​
Need to know Technologies​

Installation & Configuration​

Installation of dbt Prerequisites ​
Kicking Start & Configuring The DBT Project
Going through the Project Skeleton​

Getting Started with DBT Development​

Models
Extra Model Configurations
Sources.yml
Typical Development Workflow in DBT
Models.yml
Analysis
Seeds
Tests
Singular Tests’ Configurations
Extra Test Configurations
Snapshots
Snapshot Configurations​

Best Practices for DBT Projects

The Folder Structure
Playing With The Catalog
Customizing Lineage​

Advanced Topics in DBT

DBT Macros​
Incremental Models​
Docs Blocks​

The Complete Guide for DBT CLI​

Troubleshooting and Diagnosing Commands​
Related To The Catalog Commands​
Development Commands​
Development Commands – Selection Criterion
Managing Multiple DBT Dev Environments
Other Commands

Extending DBT​

DBT Packages​
DBT Plugins ​
External Tools Built for it​