FREE Course
Course Description
Welcome to Intro to dbt, a course designed to get you up and running with one of the most widely used transformation tools in the modern data stack.
We'll kick things off with a dbt overview — what it is, how it differs from writing raw SQL scripts, and how it fits into the modern data stack alongside tools like Snowflake, Fivetran, and Airflow. You'll also set up your local dbt environment and connect it to Snowflake, so you can code along with us throughout the course.
From there, we'll dig into the dbt project structure. You'll learn how a dbt project is organized, including its various folders and configuration files, and cover key concepts like staging vs. mart models to understand how dbt helps teams build clean, reusable transformation layers.
Next, we'll walk step-by-step through building a dbt project, applying dbt's modeling conventions and best practices as we work with data from Maven Marketplace, a fictional online retailer. Along the way, we'll write tests to validate data quality and generate documentation.
Beyond the core workflow, we'll also touch on additional dbt features you'll encounter as you go further — materializations, seeds vs. sources, macros, packages, snapshots, and more — giving you a broader sense of what's possible as you continue building with dbt after this course.
Whether you're a data analyst adding dbt to your toolkit or coming from a SQL background and exploring analytics engineering for the first time, this is the course for you.
Course Content
2 course hours
3 quizzes
Who should take this course
Aspiring analytics engineers looking to transition or break into the field
Data professionals who want a better understanding of modern data transformation
Anyone who wants to get hands-on practice using dbt and Snowflake
Meet your instructors
Alice Zhao
Lead Data Science Instructor
Alice Zhao is a seasoned data scientist and author of the book, SQL Pocket Guide, 4th Edition (O'Reilly). She's an adjunct lecturer for Northwestern University's Machine Learning and Data Science program, where she teaches Python, SQL, R, data warehousing and data visualization.
Featured review
Included learning paths
Course credential
You’ll earn the course certification by completing this course and passing the assessment requirements
Intro to dbt
CPE Accreditation
CPE Credits:
0
Field of Study:
Information Technology
Delivery Method:
QAS Self Study
Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.
Course Description
Welcome to Intro to dbt, a course designed to get you up and running with one of the most widely used transformation tools in the modern data stack.
We'll kick things off with a dbt overview — what it is, how it differs from writing raw SQL scripts, and how it fits into the modern data stack alongside tools like Snowflake, Fivetran, and Airflow. You'll also set up your local dbt environment and connect it to Snowflake, so you can code along with us throughout the course.
From there, we'll dig into the dbt project structure. You'll learn how a dbt project is organized, including its various folders and configuration files, and cover key concepts like staging vs. mart models to understand how dbt helps teams build clean, reusable transformation layers.
Next, we'll walk step-by-step through building a dbt project, applying dbt's modeling conventions and best practices as we work with data from Maven Marketplace, a fictional online retailer. Along the way, we'll write tests to validate data quality and generate documentation.
Beyond the core workflow, we'll also touch on additional dbt features you'll encounter as you go further — materializations, seeds vs. sources, macros, packages, snapshots, and more — giving you a broader sense of what's possible as you continue building with dbt after this course.
Whether you're a data analyst adding dbt to your toolkit or coming from a SQL background and exploring analytics engineering for the first time, this is the course for you.
Curriculum
Meet your instructors
Alice Zhao
Lead Data Science Instructor
Alice Zhao is a seasoned data scientist and author of the book, SQL Pocket Guide, 4th Edition (O'Reilly). She's an adjunct lecturer for Northwestern University's Machine Learning and Data Science program, where she teaches Python, SQL, R, data warehousing and data visualization.
Student reviews
Included learning paths
Course credential
You’ll earn the course certification by completing this course and passing the assessment requirements
Intro to dbt
Intro to dbt
CPE Accreditation
CPE Credits:
0
Field of Study:
Information Technology
Delivery Method:
QAS Self Study
Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.
More courses you may like
FOR INDIVIDUALS
Master data & AI skills
Build data & AI skills to launch or accelerate your career (start for free, no credit card required).
FOR COMPANIES & TEAMS
Transform your workforce
Assess your team’s data & AI skills and follow personalized learning plans to close the gaps.
FOR INDIVIDUALS
Master data & AI skills
Build data & AI skills to launch or accelerate your career (start for free, no credit card required).
FOR COMPANIES & TEAMS
Transform your workforce
Assess your team’s data & AI skills and follow personalized learning plans to close the gaps.
FOR INDIVIDUALS
Master data & AI skills
Build data & AI skills to launch or accelerate your career (start for free, no credit card required).
FOR COMPANIES & TEAMS
Transform your workforce
Assess your team’s data & AI skills and follow personalized learning plans to close the gaps.
Empowering everyday people with life-changing data skills.
DISCOVER
Empowering everyday people with life-changing data skills.
DISCOVER
Empowering everyday people with life-changing data skills.
DISCOVER