Deep Learning Nerds Academy
The ultimate Learning Platform for AI, Data Science, Data Analytics and Data Engineering.

How to use variables in your dbt models with Jinja
Academy Membership dbtData Engineering

How to use variables in your dbt models with Jinja

📘 Introduction In this hands-on dbt tutorial, you’ll learn how to use Jinja variables inside your dbt models to make your SQL code more dynamic, flexible, and reusable. Instead of hardcoding values directly into your SQL logic, Jinja allows you to define variables that can be adjusted at runtime or...

Create Interactive Multiselect Columns in Streamlit
Academy Membership StreamlitPython

Create Interactive Multiselect Columns in Streamlit

📘 Introduction Streamlit makes it easy to build interactive apps — and its st.data_editor() widget lets users edit data directly inside your app. But what if a single cell needs multiple selections, like tags, skills, or categories? 🤔 That’s where st.column_config.MultiselectColumn comes in! It allows you to...

Writing Singular Tests in dbt: A Practical Example
Academy Membership dbtData Engineering

Writing Singular Tests in dbt: A Practical Example

📘 Introduction In this hands-on dbt tutorial, you’ll learn step-by-step how to create a singular test to validate custom business rules using SQL. Unlike built-in generic tests (like unique or not_null), singular tests allow you to write fully customizable SQL logic to enforce strict data quality checks. ✅ Prerequisites ☑️ A...

CTEs vs Subqueries in dbt: Why CTEs make your SQL cleaner
Academy Membership dbtData Engineering

CTEs vs Subqueries in dbt: Why CTEs make your SQL cleaner

📘Introduction In this hands-on dbt tutorial, we’ll walk you step-by-step through how to make your SQL cleaner and more maintainable by using CTEs (Common Table Expressions) instead of deeply nested subqueries.  ✅ Prerequisites ☑️ A dbt project set up ☑️ Source data loaded into your data warehouse ☑️ Source configurations defined in sources....

You’ve successfully subscribed to Deep Learning Nerds | The ultimate Learning Platform for AI and Data Science
Welcome back! You’ve successfully signed in.
Great! You’ve successfully signed up.
Success! Your email is updated.
Your link has expired
Success! Check your email for magic link to sign-in.