- Thread Starter
- #1
Published 5/2023
Created by Henry Habib,Imran Immu
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 70 Lectures ( 6h 20m ) | 2.22 GB
What you'll learn
Learn DBT, a data build tool used for transforming and deploying data in data warehouses
DBT's key features and functionalities that make it a powerful tool for data transformation and analytics
Create a DBT project, including how to initialize the project and explore the project configuration file
Understand the concept of DBT models and how to build a simple model with SQL
Learn to define, structure, and organize your data transformations using DBT models
Master the art of writing tests to ensure the quality and accuracy of your DBT models
Explore different materialization techniques to optimize the performance and scalability of your DBT models
Understand how to incorporate seeds and sources into your DBT projects for data ingestion and initial data setup
Discover the powerful features and functionalities offered by DBT Cloud for seamless collaboration and deployment
Harness the power of Jinja templating and generate automated documentation for your DBT projects
Enhance your data loading capabilities and create custom macros to extend the functionality of DBT
Learn how to leverage DBT snapshots to capture historical versions of your data for auditing and analysis purposes
Dive into DBT hooks and learn how to integrate external scripts and actions into your DBT workflows
Gain expertise in DBT analyses to perform complex data analysis and generate actionable insights using SQL within your DBT projects
Requirements
Background in data analysis or data engineering is recommended, but not required (it will just provide a strong foundation for understanding the purpose and value of DBT)
Basic understanding of SQL is again recommended, but not required (DBT relies on SQL for data transformations and modelling)
Understanding of Snowflake or data warehousing concepts
