dbt Bootcamp (core & cloud) : Beginner to Pro

dbt Bootcamp (core & cloud) : Beginner to Pro, available at $54.99, has an average rating of 3.67, with 82 lectures, 6 quizzes, based on 3 reviews, and has 28 subscribers.

You will learn about Understand the core concepts and principles of dbt (data build tool), including the concepts of models, sources, and tests. Gain proficiency in writing dbt models to transform raw data into meaningful and analytically valuable datasets. Learn how to structure dbt projects effectively and use version control to manage changes in your analytics codebase Understand the importance of data testing in the analytics workflow and how to create and execute tests in dbt. This course is ideal for individuals who are Data Analysts and Data Scientists or Business Intelligence Professionals or Data Engineers or Beginners in Analytics It is particularly useful for Data Analysts and Data Scientists or Business Intelligence Professionals or Data Engineers or Beginners in Analytics.

Enroll now: dbt Bootcamp (core & cloud) : Beginner to Pro

Summary

Title: dbt Bootcamp (core & cloud) : Beginner to Pro

Price: $54.99

Average Rating: 3.67

Number of Lectures: 82

Number of Quizzes: 6

Number of Published Lectures: 82

Number of Published Quizzes: 6

Number of Curriculum Items: 88

Number of Published Curriculum Objects: 88

Original Price: ₹799

Quality Status: approved

Status: Live

What You Will Learn

Understand the core concepts and principles of dbt (data build tool), including the concepts of models, sources, and tests.
Gain proficiency in writing dbt models to transform raw data into meaningful and analytically valuable datasets.
Learn how to structure dbt projects effectively and use version control to manage changes in your analytics codebase
Understand the importance of data testing in the analytics workflow and how to create and execute tests in dbt.

Who Should Attend

Data Analysts and Data Scientists
Business Intelligence Professionals
Data Engineers
Beginners in Analytics

Target Audiences

Data Analysts and Data Scientists
Business Intelligence Professionals
Data Engineers
Beginners in Analytics

Course Description:

Unlock the full potential of your data analytics workflow with our comprehensive “dbt Core Fundamentals part 1” course. In this hands-on and accessible learning experience, you’ll dive into the world of dbt (data build tool) to revolutionize the way you transform and model data for analytics.

Course Highlights:

Build a Solid Foundation: Gain a deep understanding of dbt’s core concepts, including models, snapshots, seeds, and tests. Learn how to structure dbt projects for maximum efficiency and maintainability.

Efficient Data Transformations: Master the art of crafting efficient and scalable data transformations using dbt. Explore advanced techniques, optimize queries, and apply best practices for top-notch analytics.

Data Quality Assurance: Learn the importance of data testing and validation in the analytics pipeline. Develop skills to create and execute tests, ensuring the integrity and accuracy of your transformed data.

Collaborative Development: Elevate your collaborative analytics development skills. Work seamlessly with teammates, manage codebase changes using version control, and create impactful documentation to enhance team collaboration.

Hands-On Practice: Apply your knowledge through hands-on exercises and real-world scenarios. Gain practical experience in a dbt environment to reinforce your learning and build confidence in your analytics capabilities.

Who Should Enroll:

Data Analysts, Data Scientists, and Business Intelligence Professionals

Data Engineers and Database Administrators

Analytics Managers and Team Leads

SQL Practitioners and Beginners in Analytics

Prerequisites:

Basic SQL knowledge

Familiarity with data concepts

Understanding of data warehousing (not mandatory)

Basic command line interface (CLI) skills (useful)

Course Outcome:

Upon completion, you’ll be equipped with the skills to transform raw data into actionable insights efficiently, collaborate effectively in a team environment, and ensure the quality and reliability of your analytics data. Empower your analytics journey – enroll in the “dbt Core Fundamentals part 1” course and take your data transformation skills to the next level!

Course Curriculum

Chapter 1: Introduction to dbt

Lecture 1: what is dbt

Lecture 2: Key Features

Lecture 3: why dbt

Lecture 4: what is analytical Engineering

Chapter 2: set up dbt core

Lecture 1: list of set up tools

Lecture 2: set up dbt core

Lecture 3: how to sign up for snowflake (optional)

Chapter 3: dbt project setup

Lecture 1: dbt project setup

Lecture 2: what is dbt project.yml file

Lecture 3: load sample data into snowflake

Chapter 4: Models

Lecture 1: model definition

Lecture 2: what is model in dbt

Lecture 3: what is config in dbt

Lecture 4: what is ref function

Lecture 5: reorganize your project

Lecture 6: building stg_payments model

Lecture 7: building fact_orders model

Lecture 8: configure your materializations

Chapter 5: sources

Lecture 1: what is sources in dbt

Lecture 2: creating source for payment

Lecture 3: what is source freshness

Chapter 6: Tests

Lecture 1: what is dbt test

Lecture 2: types of dbt test

Lecture 3: generic test

Lecture 4: singular test

Lecture 5: testing sources

Chapter 7: Documentation

Lecture 1: dbt documentation

Chapter 8: dbt cloud

Lecture 1: Create a DBT account

Lecture 2: Top Features of DBT

Lecture 3: Why use DBT? Exploring the Benefits for your Data Workflow

Lecture 4: What is Analytical Engineering?

Lecture 5: Create a snowflake Account

Lecture 6: Explore the Snowflake Web UI interface

Lecture 7: load sample data

Lecture 8: Create a DBT Cloud account

Lecture 9: Setup the dbt project

Lecture 10: initilize the dbt project

Lecture 11: Explore the DBT Cloud Web UI interface

Lecture 12: Explore DBT Project Config file

Lecture 13: What are DBT models?

Lecture 14: Introduction to Creating a simple model

Lecture 15: Create Table in dbt

Lecture 16: What is dbt schema

Lecture 17: Build Your First dbt Model

Lecture 18: what is ref function in dbt

Lecture 19: Best Practices for Organizing Your dbt Project Structure

Lecture 20: Configuring Materializations in dbt

Lecture 21: refactor your dim_customers model

Lecture 22: what is dbt schema

Lecture 23: what is macro

Lecture 24: what is testing

Lecture 25: what is dbt test

Lecture 26: Different types of test in dbt

Lecture 27: what is generic test

Lecture 28: Writing Generic Tests in dbt

Lecture 29: Writing singular Tests in dbt

Lecture 30: dbt Test Commands: Syntax and Usage

Lecture 31: What are materializations in DBT?

Lecture 32: Default Materializations in dbt

Lecture 33: Using config block for materializations

Lecture 34: what is sources in dbt

Lecture 35: How to add sources in dbt

Lecture 36: what is dbt source freshness

Lecture 37: Implementing Source Freshness Checks in dbt

Lecture 38: what is dbt seed

Lecture 39: Implementing dbt seeds in dbt

Lecture 40: How to manage version control in dbt

Lecture 41: How to set up Monitoring and Alerting in dbt

Lecture 42: How to schedule DBT runs and automate data transformations

Lecture 43: Introduction to Jinja

Lecture 44: what is dbt docs

Lecture 45: Implementing table,view and ephemeral model

Lecture 46: Implementing incremental load in dbt

Lecture 47: Create Custom Macro

Lecture 48: what is dbt packages

Lecture 49: What are snapshots in DBT?

Lecture 50: Implementing snapshots in dbt

Lecture 51: What are hooks in DBT?

Lecture 52: Implementing hooks in DBT

Lecture 53: what is analyses

Lecture 54: Implementing analyses in dbt

Lecture 55: How to tuning dbt project

Instructors

MD Imran
instructor

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 0 votes
5 stars: 2 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu