Course Hive
Courses
Summaries
Continue with Google
or

dbt (data-build-tool)

4.0 (0)
9 learners

What you'll learn

This course includes

  • 5.5 hours of video
  • Certificate of completion
  • Access on mobile and TV

Course content

1 modules • 48 lessons • 5.5 hours of video

dbt (data-build-tool)

48 lessons • 5.5 hours
  • Intro to Data Build Tool (dbt) // Create your first project!14:55
  • 5 Tips to Improve Your dbt Project08:13
  • Add raw "sources" to your dbt project10:43
  • How does dbt actually compile queries?03:03
  • Deploy to custom schemas & override dbt defaults06:41
  • How to test and debug your dbt models06:07
  • Change the materialization (aka how dbt models deploy)04:41
  • Package management and dbt Hub // packages.yml02:52
  • View your dbt documentation as a website03:41
  • Use dbt Seeds to work with static CSV data05:09
  • Create custom tests or override defaults08:20
  • Add dbt project variables & use them in models05:13
  • Use hooks to simplify repetitive dbt run activities07:06
  • Simplify dbt documentation with docs blocks05:35
  • How to monitor your source freshness in dbt07:35
  • How to use Snowflake query tags in dbt02:45
  • Use the dbt "state" method to only run modified models05:08
  • The multi-repo approach // how to structure dbt projects06:46
  • Audit your dbt runs by using {{ invocation_id }}04:28
  • Install dbt in a virtual environment // best practice03:50
  • How to "clean" your dbt project files03:33
  • An EASY way to run/test models in groups06:05
  • How do EPHEMERAL dbt models work?04:59
  • Handle JSON with dbt // jinja & macros16:56
  • How to use ONE dbt project for all environments07:23
  • How to use the dbt "analyses" directory05:40
  • A simple 4-step process for creating dbt models04:26
  • How to use managed repos on dbt Cloud05:19
  • Intro to dbt Cloud // Use Free for Life13:19
  • 3 Time-Saving dbt Cloud Features (for free)04:13
  • How to use Exposures in dbt06:46
  • How to use dbt Operators to run dynamic commands07:45
  • dbt Project Naming Conventions (recommended approach)07:10
  • How to use dbt Snapshots to track data history10:54
  • dbt Environments vs Targets | What's the Difference?10:21
  • dbt & Reverse ETL | Census Integration & CI Checks07:08
  • What are "intermediate" models in dbt?08:27
  • How to Run Queries from the Terminal (dbt Show Command)04:36
  • How to Build Incremental Models | dbt tutorial10:51
  • How to Use Jinja w/ dbt Macros (3 Examples)11:34
  • The Power of Naming in Data Projects (especially dbt)08:58
  • SQL vs dbt Models (& the value of CTEs)04:08
  • dbt vs Stored Procedures (3 key differences)10:27
  • Creating a Data Model w/ dbt: Dimensions (Part 1/3)14:06
  • Creating a Data Model w/ dbt: Facts (Part 2/3)08:40
  • Creating a Data Model w/ dbt: Tests (Part 3/3)05:30
  • Data Architecture w/ dbt: Putting It All Together09:02
  • The Modern Data Viewpoint (3 Principles)08:43

You may also be interested in

FAQs

Suggest a Youtube Course

Our catalog is built based on the recommendations and interests of students like you.

Course Hive
Download now and unlock unlimited audiobooks — 100% free
Explore Now