Premium

A list of premium posts for academy members containing hands-on tutorials, best practices, career advices and learning paths.

301 premium posts
What Is n8n and Why Is It So Powerful?
Academy Membership n8nAgentic AI

What Is n8n and Why Is It So Powerful?

📘 Introduction Automation has become a central pillar of modern digital operations, but most tools either limit flexibility or lock you into rigid, predefined steps. n8n stands out because it bridges the gap between low-code usability and deep technical power. It brings together visual workflow building, full control over data, effortless...

Load Data from a JSON File into DuckDB using Python
Academy Membership DuckDBPython

Load Data from a JSON File into DuckDB using Python

📘 Introduction Working with structured data is a core part of any data engineering or analytics workflow. DuckDB, often called the SQLite for analytics, makes it incredibly easy to query local data files—including JSON—without requiring a complex setup. In this tutorial, you’ll learn how to load JSON data...

Install n8n Locally with npm: A Step-by-Step Guide
Academy Membership n8nAgentic AI

Install n8n Locally with npm: A Step-by-Step Guide

📘 Introduction n8n is a flexible and powerful automation platform that helps you connect apps, orchestrate workflows, and even build AI-driven processes — all without writing code. Installing n8n locally with npm gives you a lightweight, customizable setup that runs directly on your system, making it perfect for development, debugging, and experimenting...

How to convert CSV to JSON in Python using Pandas
Academy Membership PandasPython

How to convert CSV to JSON in Python using Pandas

📘 Introduction JSON is one of the most widely used data formats for APIs, configurations, storage, and modern applications. Converting CSV to JSON in Python is incredibly simple using Pandas. In this tutorial, we will walk through the full process: creating a sample CSV file, loading it into a Pandas DataFrame,...

Load Data from a Parquet File into DuckDB using Python
Academy Membership DuckDBPython

Load Data from a Parquet File into DuckDB using Python

📘 Introduction In this tutorial, you’ll learn how to load data from a Parquet file into a DuckDB database using Python. DuckDB’s native Parquet support makes it fast and efficient to work with columnar data, making it ideal for analytics, ETL pipelines, and Python data projects. You’ll see...

How to convert CSV to Parquet in Python using Pandas
Academy Membership PandasPython

How to convert CSV to Parquet in Python using Pandas

📘 Introduction In modern data workflows, Parquet is a popular columnar storage format for efficient data storage and faster analytics. Converting CSV to Parquet in Python is straightforward using Pandas and PyArrow. In this tutorial, we will walk you through the complete process: from creating a sample CSV file, reading it...

Install n8n Locally with Docker Desktop: A Step-by-Step Guide
Academy Membership n8nDocker

Install n8n Locally with Docker Desktop: A Step-by-Step Guide

📘 Introduction n8n is a powerful automation platform that gives you the freedom to build workflows, integrate apps, and create AI-powered automations without writing any code. Running n8n locally with Docker Desktop provides a fast, clean, and reliable setup that isolates your environment while keeping your system clutter-free. With Docker Desktop,...

Insert Data from a CSV File into DuckDB using Python
Academy Membership DuckDBPython

Insert Data from a CSV File into DuckDB using Python

📘 Introduction In this tutorial, you will learn how to insert data from a CSV file into a DuckDB database using Python. DuckDB is a powerful in-process analytical database that makes working with structured data fast, simple, and efficient—perfect for data projects, notebooks, and local analytics. ✅ Prerequisites Before you begin,...

Install n8n Locally with Docker Compose: A Step-by-Step Guide
Academy Membership n8nDocker

Install n8n Locally with Docker Compose: A Step-by-Step Guide

📘 Introduction n8n is a powerful workflow automation platform that lets you connect apps, automate processes, and even build AI agents — all without writing a single line of code. Running n8n locally using Docker Compose gives you a clean, reliable, and easily reproducible environment that’s perfect for development, experimentation, and...

Insert Data into DuckDB Using Python: A Practical Guide
Academy Membership DuckDBPython

Insert Data into DuckDB Using Python: A Practical Guide

📘 Introduction DuckDB has quickly become a favorite tool among data engineers and analysts because of its speed, simplicity, and ability to run analytical SQL queries directly within Python. Whether you’re prototyping data pipelines, running local analytics, or managing lightweight data storage, knowing how to insert data into DuckDB is...

How to Rename Multiple DataFrame Columns at Once in PySpark
Academy Membership PySparkPython

How to Rename Multiple DataFrame Columns at Once in PySpark

📘 Introduction Renaming columns is one of the most common transformations you’ll perform when cleaning or standardizing data in PySpark. Whether you’re aligning tables from different systems, preparing data for machine learning, or simply making column names more readable, updating many column names at once can quickly become tedious...

Query CSV files in Python using DuckDB
Academy Membership DuckDBPython

Query CSV files in Python using DuckDB

📘 Introduction One of DuckDB’s most useful features is the ability to query CSV files directly—no need to load them into a database first. This tutorial will guide you through running SQL queries on a CSV file using Python. ✅ Prerequisites Before you begin, make sure you have: 🐍☑️ Installed Python...

Query a Pandas DataFrame using DuckDB
Academy Membership DuckDBPython

Query a Pandas DataFrame using DuckDB

📘 Introduction If you enjoy working with pandas but wish you could use clean, powerful SQL at any time, then DuckDB is the right tool for you. With DuckDB, you can query your DataFrames instantly without having to set up a database, run a server, or change your workflow. ✅ Prerequisites Before...

How to install DuckDB with pip
Academy Membership DuckDBData Engineering

How to install DuckDB with pip

📘Introduction In this blog post, we’ll walk through how to install DuckDB, a fast and lightweight analytical database engine designed for modern data workflows. Whether you're working on data analysis, ETL pipelines, or experimenting with in-process SQL queries, DuckDB is incredibly easy to set up and use....

PySpark coalesce() Function Explained
Academy Membership PySparkPython

PySpark coalesce() Function Explained

📘 Introduction In many real-world datasets, the same type of information can appear in more than one column. A customer may provide an email address, a phone number, or a backup contact, and different systems may populate different fields. When you want to select the first available non-null value from several...

Using pre-hooks in dbt: A Hands-On Guide
Academy Membership dbtData Engineering

Using pre-hooks in dbt: A Hands-On Guide

📘Introduction In this hands-on dbt tutorial, you'll learn how to use pre-hooks to automate tasks such as creating backup tables before a model runs. Pre-hooks allow you to execute SQL before your dbt model builds, which is useful for auditing, data quality checks, or preparing the environment. 🎓 Preparing...

Kafka Producers and Consumers Explained: How Data Flows in Apache Kafka
Academy Membership Kafka

Kafka Producers and Consumers Explained: How Data Flows in Apache Kafka

📘 Introduction Modern systems produce endless streams of real-time data — from app events and online purchases to sensor readings and transactions. To handle this flow efficiently, applications need a fast, reliable way to move data between services as it happens. That’s where Apache Kafka comes in. Kafka is a distributed...

How to Ingest Data from Kafka Streams to Delta Tables Using PySpark in Databricks
Academy Membership DatabricksPySpark

How to Ingest Data from Kafka Streams to Delta Tables Using PySpark in Databricks

📘 Introduction Real-time data ingestion is a critical part of modern data architectures. Organizations need to process and store continuous streams of information for analytics, monitoring, and machine learning. Databricks, with the combined power of PySpark and Delta Lake, provides an efficient way to build end-to-end streaming pipelines that handle data...

Overview of all important YAML Files in dbt
Academy Membership dbtData Engineering

Overview of all important YAML Files in dbt

📘Introduction When working with dbt (data build tool), YAML files are the backbone of your project’s configuration. They define how dbt behaves, how your models connect to data sources, and how metadata, documentation, and tests are managed. Understanding these YAML files and knowing where they are located within your...

How to Generate a Hash from Multiple Columns in PySpark
Academy Membership PySparkData Engineering

How to Generate a Hash from Multiple Columns in PySpark

📘 Introduction When processing massive datasets in PySpark, it’s often necessary to uniquely identify rows or efficiently detect changes across records. Using multiple columns as a composite key can quickly become cumbersome and inefficient — especially during joins or deduplication. A better solution is to generate a single hash value derived...

Configuring DEV and PROD Environments in dbt
Academy Membership dbtData Engineering

Configuring DEV and PROD Environments in dbt

📘Introduction In this hands-on dbt tutorial, you’ll learn how to configure separate development (DEV) and production (PROD) environments to safely build, test, and deploy your data models. We’ll walk through why environment separation matters and how to configure your profiles.yml so you can switch between environments with...

Using Jinja loops for flexible Aggregations in dbt
Academy Membership dbtData Engineering

Using Jinja loops for flexible Aggregations in dbt

📘Introduction In this hands-on dbt tutorial, you’ll learn how to make your aggregations dynamic and flexible using Jinja loops inside your SQL models. Instead of writing multiple aggregation functions, you’ll see how to dynamically generate aggregation logic — saving time and reducing repetitive SQL code. 🎓 Preparing for dbt Analytics...

Making CASE Statements dynamic with Jinja Loops in dbt
Academy Membership dbtData Engineering

Making CASE Statements dynamic with Jinja Loops in dbt

📘Introduction In this hands-on dbt tutorial, you’ll learn how to make your SQL transformations dynamic and reusable by using Jinja loops inside CASE statements. This approach helps you replace repetitive SQL logic with concise, maintainable code — a valuable skill for any Data Engineer. 🎓 Preparing for dbt Analytics Engineering Certification?...

Using For Loops in your dbt models with Jinja
Academy Membership dbtData Engineering

Using For Loops in your dbt models with Jinja

📘Introduction In this hands-on dbt tutorial, you'll learn how to use Jinja for loops inside your dbt models to make your SQL code more dynamic and automated. Instead of manually repeating similar SQL logic for multiple columns, tables, or conditions — you can use for loops with Jinja to...

Overwriting Project Variables at Runtime in dbt
Academy Membership dbtData Engineering

Overwriting Project Variables at Runtime in dbt

📘 Introduction In this hands-on dbt tutorial, you'll learn how to overwrite project variables at runtime — a powerful feature that lets you dynamically change your dbt model behavior without modifying your code or dbt_project.yml. This is especially useful when you need to run the same transformation logic...

GraphQL vs. REST: Understanding the Key Differences
Academy Membership APIData Engineering

GraphQL vs. REST: Understanding the Key Differences

📘Introduction In this tutorial, you'll learn how GraphQL and REST differ and why developers choose one over the other. Whether you’re building modern web apps or managing large datasets, understanding these differences is essential for efficient, scalable applications. 🟣 GraphQL GraphQL (Graph Query Language) is a query language...

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....

Getting Started with OpenAI Agent Builder: Build Multi-Agent Workflows with Drag-and-Drop Interface
Academy Membership OpenAIAgentic AI

Getting Started with OpenAI Agent Builder: Build Multi-Agent Workflows with Drag-and-Drop Interface

📘 Introduction Welcome to this hands-on guide to OpenAI Agent Builder — a revolutionary no-code tool that lets you design and deploy multi-agent workflows using a drag-and-drop interface. In this post, we’ll walk you through how to access the Agent Builder and create your first agent workflow step-by-step. 💡 What is OpenAI...

Set up Medallion Architecture in Databricks: From Raw Data to Gold Standard
Academy Membership DatabricksData Engineering

Set up Medallion Architecture in Databricks: From Raw Data to Gold Standard

📘 Introduction In the age of data-driven decision making, a well-structured and scalable data architecture is essential. The Medallion Architecture is a proven framework that organizes data into multiple layers of refinement — ensuring clarity, governance, and trust as data flows from raw ingestion to business-ready insights. When combined with Databricks and...

Add a Background Image to your Streamlit App
Academy Membership StreamlitPython

Add a Background Image to your Streamlit App

📘 Introduction Streamlit makes it super easy to build interactive data apps in Python — without needing HTML, CSS, or JavaScript. But sometimes, you want your app to look more polished and visually appealing. One simple way to achieve that is by adding a background image. Whether you want to match your...

Speed up your Streamlit App with Caching
Academy Membership StreamlitPython

Speed up your Streamlit App with Caching

📘 Introduction Streamlit makes it super easy to build interactive apps in Python. But as your app grows — loading datasets, running expensive computations, or calling APIs — you might notice it slows down. The good news: Streamlit has a built-in caching system that stores results of expensive operations and reuses them instead...

How to deploy a Docusaurus Website to GitHub Pages
Academy Membership DocusaurusGit

How to deploy a Docusaurus Website to GitHub Pages

📘 Introduction Welcome to this hands-on Docusaurus deployment tutorial! In this guide, we’ll walk you step-by-step through deploying your Docusaurus site to GitHub Pages — a simple and free hosting solution for websites. Perfect for open-source projects, documentation sites, or personal projects that you want to share with the world. 💡 What...

How to build an interactive Documentation Website with Docusaurus: A Step-by-Step Guide
Academy Membership DocusaurusReact

How to build an interactive Documentation Website with Docusaurus: A Step-by-Step Guide

📘 Introduction Welcome to this hands-on Docusaurus tutorial! In this guide, we’ll walk you step-by-step through creating your first interactive documentation site using Docusaurus — perfect for developers, startups, or teams who want to provide clean, user-friendly, and dynamic documentation. 💡 What is Docusaurus? Docusaurus is a static site generator built by...

Build an AI Agent with LangChain, LangGraph and OpenAI Models
Academy Membership Agentic AILangChain

Build an AI Agent with LangChain, LangGraph and OpenAI Models

📘 Introduction Welcome to this hands-on LangChain + LangGraph tutorial! In this guide, we’ll walk you step-by-step through creating your first AI agent using LangChain, LangGraph, and OpenAI models — perfect for beginners who want to build intelligent, autonomous assistants with flexible workflows. 💡 What are LangChain and LangGraph? * LangChain is a powerful...

How to Serve a React App with FastAPI Using Static Files
Academy Membership PythonFastAPI

How to Serve a React App with FastAPI Using Static Files

📘 Introduction FastAPI is a powerful Python framework for building APIs that is both fast and modern. But sometimes you want more than just an API—you also want a user-friendly interface. Instead of running React and FastAPI on two separate servers, you can bundle your React frontend inside FastAPI and...

How to style your Streamlit App with Custom Themes
Academy Membership StreamlitPython

How to style your Streamlit App with Custom Themes

📘 Introduction Streamlit makes it easy to turn Python scripts into interactive web apps — no front-end coding needed. But what if you want to adjust the look and feel? Maybe you want a dark theme, different fonts, or brand colors. The good news: Streamlit has a built-in theme system that lets...

How to deploy your FastMCP Server on FastMCP Cloud
Academy Membership MCPAgentic AI

How to deploy your FastMCP Server on FastMCP Cloud

📘Introduction Welcome to this hands-on FastMCP tutorial! In this guide, we’ll walk you step by step through deploying and testing your first FastMCP server on FastMCP Cloud. Deploying is a crucial step because it makes your FastMCP server accessible, usable, and ready for real-world applications. ✅ Prerequisites Before you begin,...

How to build a Chatbot with Gradio and the OpenAI Python SDK
Academy Membership Agentic AIOpenAI

How to build a Chatbot with Gradio and the OpenAI Python SDK

📘 Introduction Chatbots are no longer just futuristic concepts—they’re now powering customer service, virtual assistants, and productivity tools everywhere. With the OpenAI Python SDK, you can build a powerful conversational model in just a few lines of code. And when paired with Gradio, you get a clean, interactive web...

Understanding JSON-RPC: The Backbone of MCP Communication
Academy Membership DataMCP

Understanding JSON-RPC: The Backbone of MCP Communication

📘Introduction In this guide, we’ll walk through the basics of JSON-RPC, a lightweight protocol for structured communication between systems. It’s widely used in APIs, blockchain, and even newer standards like the Model Context Protocol (MCP). 💡 What is JSON-RPC? JSON-RPC is a remote procedure call (RPC) protocol encoded in...

Scheduling dbt models with Dagster: A Step-by-Step Guide
Academy Membership Dagsterdbt

Scheduling dbt models with Dagster: A Step-by-Step Guide

📘 Introduction In this hands-on tutorial, we’ll walk step-by-step through scheduling dbt models with Dagster. By integrating Dagster, you can easily orchestrate your dbt workflows and automating model runs. ✅ Prerequisites 🐍☑️ Installed Python 📦☑️Installed Pip 🌐☑️ Created a virtual environment (venv) 🗂️☑️ A dbt project set up 🧪☑️ Existing dbt models defined in your...

Running your dbt models via Dagster UI
Academy Membership Dagsterdbt

Running your dbt models via Dagster UI

📘 Introduction In this hands-on tutorial, we’ll walk you step-by-step through running dbt models directly from the Dagster UI. By integrating dbt with Dagster, you gain an easy way to orchestrate, run, and monitor your models — all from a clean web interface. ✅ Prerequisites 🐍☑️ Installed Python 📦☑️Installed Pip 🌐☑️ Created a virtual...

Exploring your dbt models in the Dagster UI
Academy Membership Dagsterdbt

Exploring your dbt models in the Dagster UI

📘 Introduction n this hands-on tutorial, we’ll walk you step-by-step through the Dagster UI and show you where to find your dbt models, along with important details such as column descriptions, SQL code, and data lineage. ✅ Prerequisites 🐍☑️ Installed Python 📦☑️Installed Pip 🌐☑️ Created a virtual environment (venv) 🗂️☑️ A dbt project set...

Defining dbt models as Assets in Dagster
Academy Membership Dagsterdbt

Defining dbt models as Assets in Dagster

📘 Introduction In this hands-on tutorial, we’ll walk you step-by-step through adding your dbt models as assets to your Dagster projects. Once done, your dbt models will appear in the Dagster UI, making it easy to orchestrate, run, and monitor them. ✅ Prerequisites 🐍☑️ Installed Python 📦☑️Installed Pip 🌐☑️ Created a virtual environment...

Running Dagster with your dbt project locally
Academy Membership Dagsterdbt

Running Dagster with your dbt project locally

📘 Introduction In this hands-on tutorial, we’ll walk you step-by-step through how to run Dagster with your dbt project, so you can orchestrate, monitor, and manage your data pipelines in the Dagster UI. ✅ Prerequisites 🐍☑️ Installed Python 📦☑️Installed Pip 🌐☑️ Created a virtual environment (venv) 🗂️☑️ A dbt project set up 🧪☑️ Existing dbt...

Using Dagster with dbt: A Modern Approach to Data Orchestration
Academy Membership Dagsterdbt

Using Dagster with dbt: A Modern Approach to Data Orchestration

📘 Introduction In this hands-on tutorial, we’ll walk you step-by-step through how to orchestrate your dbt workflows using Dagster. Combining Dagster’s robust orchestration capabilities with dbt’s transformation power allows you to build reliable, maintainable, and observable data pipelines.  ✅ Prerequisites 🐍☑️ Installed Python 📦☑️Installed Pip 🌐☑️ Created a virtual environment (venv)...

How to configure the transport method for your FastMCP server
Academy Membership MCPAgentic AI

How to configure the transport method for your FastMCP server

📘Introduction Welcome to this hands-on FastMCP tutorial! In this guide, we’ll walk you step-by-step through configuring the transport method for your FastMCP server. By the end, you’ll understand the different transport mechanisms available and how to use them in the run() statement. ✅ Prerequisites Before you begin, make sure...

Understanding the Transport Layer in MCP Architecture
Academy Membership MCPAgentic AI

Understanding the Transport Layer in MCP Architecture

📘Introduction Welcome to this MCP tutorial! In this guide, we’ll walk step-by-step through the Transport Layer in Model Context Protocol (MCP) architecture. By the end, you’ll understand how the transport layer facilitates efficient and reliable communication between clients and servers. 💡What is the Transport Layer? In the Model...

How to run your FastMCP Server: A Hands-On Guide
Academy Membership Agentic AIMCP

How to run your FastMCP Server: A Hands-On Guide

📘Introduction Welcome to this hands-on FastMCP tutorial! In this guide, we’ll walk step-by-step through how to run a FastMCP Server. By the end, you’ll have a fully working server with a custom tool that AI clients can call and interact with. ✅ Prerequisites Before you begin, make sure you...

How to add Tools to your FastMCP Server
Academy Membership MCPAgentic AI

How to add Tools to your FastMCP Server

📘Introduction Welcome to this hands-on FastMCP tutorial! In this guide, we’ll walk step-by-step through how to add a tool to your FastMCP Server. By the end, you’ll have a working server with a custom tool that can be called by AI clients. ✅ Prerequisites Before you begin, make sure...

How to build an AI Agent using the OpenAI Agents SDK
Academy Membership Agentic AIGenerative AI

How to build an AI Agent using the OpenAI Agents SDK

📘 Introduction Welcome to this hands-on OpenAI Agents tutorial! In this guide, we’ll walk you step-by-step through creating your first AI agent using the OpenAI Agents SDK — perfect for beginners who want to build intelligent, autonomous assistants quickly. 💡 What is the OpenAI Agents SDK? The OpenAI Agents SDK is a...

How to create your first FastMCP Server: A Beginners Tutorial
Academy Membership MCPAgentic AI

How to create your first FastMCP Server: A Beginners Tutorial

📘Introduction Welcome to this hands-on FastMCP tutorial! In this guide, we’ll walk you step-by-step through creating your first FastMCP server from scratch — perfect for beginners who want to jump into MCP quickly. ✅ Prerequisites Before you begin, make sure you have the following: 🐍☑️ Installed Python 📦☑️ Installed Pip 🌐☑️ Created and activated...

What is FastMCP and how to use it?
Academy Membership PythonMCP

What is FastMCP and how to use it?

📘 Introduction Welcome to this hands-on FastMCP tutorial! In this guide, we’ll take you step-by-step through setting up and using FastMCP to accelerate your AI projects with ease and efficiency. ✅ Prerequisites Before you begin, make sure you have the following: 🐍☑️ Installed Python 📦☑️ Installed Pip 🌐☑️ Created and activated a virtual environment...

Model Context Protocol (MCP): The USB-C Port for AI Agents
Academy Membership MCPAgentic AI

Model Context Protocol (MCP): The USB-C Port for AI Agents

📘 Introduction In the rapidly evolving world of artificial intelligence, interoperability is emerging as a critical challenge. With multiple agents, tools, memory systems, and models working in tandem, the need for a universal “plug-and-play” protocol is greater than ever. Enter the Model Context Protocol (MCP) — a new standard designed to unify...

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.