Master data engineering and AI like a big tech engineer

Real Time Formula 1 Analytics

Big Bag Data

Chess.com Analytics

Trading Strategy for Crypto Currency - Analytics Engineering Capstone Submission

BetFlow - Real Time Sports Betting App

Showcase of student projects

Capstone Projects

Book a discovery call with Zach

Discovery call

Our students have gone on to work at companies like Meta, Airbnb and Amazon. As well as achieve 100% raises!

Fast Track Your Career

Immediate free cloud access to Databricks, AWS, Snowflake, Astronomer, and more!

Free Cloud Access with tons of hands on exercises

Weekly Guest Speaker Sessions

Why Choose DataExpert.io Academy?

Temporary lesson created only to preview the new homepage Lightning Lessons promo section. Will be deleted right after.

Riya Test

Temporary row for homepage promo preview

TEST PREVIEW 5 — SQL Window Functions Deep Dive

Ship production AI: RAG, agents, MCP, and MLOps — taught by the engineers companies are paying top dollar to hire.

RAG and LLMs Day1 Lecture

RAG and LLMs Day1 Lab

RAG and LLMs Day2 Lecture

RAG and LLMs Day2 Lab

LLMs Day 3 Part1

LLMs Day3 Part2

Capstone Proposal Assignment

Capstone Submission

Li Yin - Founder of Adal (2025-07-10)

Conor Brennan - CEO & Founder at Hypersell

Vikram Chennai - Founder at Ardent AI

Ryan Brandt - CEO at VundaAI

Chip Huyen - Author of AI Engineering

Tech Talk with Xinran Waibel

Future of Data Engineering with Archita

Data Engineering Interviews with Swetha at OpenAI

Tech Talk - 2

Ryan Brandt - CEO at VundaAI (2.0)

Carly Taylor - Field CTO at Databricks

Li Yin - Founder at Adal (2.0)

Li Yin - Founder at Adal (2026-03-13)

Brian Pulliam - Career Development Coach

Sai Bysani - Lead Data Engineer

Vaishali Macwan - Senior Data Scientist

Shwetha - Data Engineer at OpenAI

AI Application Setup

AI Engineering Bootcamp Kick off

Claude Code Onboarding

Langchain Starter Repo Setup

Q&A with Zach Week 1 (2025-07-10)

Q&A with Zach Week 2 (2025-07-18)

Q&A with Zach Week 3 (2025-07-25)

Q&A with Zach Week 4 (2025-08-01)

Q&A with Zach Week 5 (2025-08-08)

Q&A with Zach Week 1 (2025-10-09)

Q&A with Zach Week 2 (2025-10-09)

Q&A with Zach Week 3 (2025-10-09)

Q&A with Zach Week 4 (2025-10-09)

Q&A with Zach Week 5 (2025-10-09)

Q&A with Zach 1

Q&A with Zach 2

Q&A with Zach 3

Q&A with Zach 4

Q&A with Zach 5

Prompt Engineering 

Prompt Engineering Assignment

Understanding RAG Basics Assignment

MCP Middleware Assignment

Context Overflow Agent Assignment

Infinite Research Agent Assignment

Prompt Engineering Day 1 Lecture

Prompt Engineering Day1 Lab

Prompt Engineering + Basic RAG Day 2 Lecture

Prompt Engineering + Basic RAG Day 2 Lab

Day 1 Lecture: Prompt Engineering Theory

Day 1 Lab: Auto Prompt Optimization with dspy

Day 2 Lecture: Optimizing Dev Workflows with Cursor and Windsurf

Day 2 Lab: Vibe Coding Full Stack application in 45 minutes

Supplemental Session on Auto-prompt Optimization

Day 1 Lecture: RAG Fundamentals and types of RAG

Day 1 Lab: Vectorizing Inputs into Milvus

Day 2 Lecture: RAG Tradeoffs

Day 2 Lab: Integrating RAG into your full stack app

Building functional AI agents using LangChain Day1 Lecture

Building functional AI agents using LangChain Day1 Lab

Building functional AI agents using LangChain Day2 Lecture

Building functional AI agents using LangChain Day2 Lab

Claude Code Homework

Metadata Filtering Assignment

Building a Graph RAG assignment

RAG optimisation + Reranking Day 1 Lecture

RAG optimisation + Reranking Day 1 Lab

RAG optimisation + Reranking Day 2 Lecture

RAG optimisation + Reranking Day 2 Lab

Optimize your dev workflow with Claude Code and Codex Day1 Lecture

Optimize your dev workflow with Claude Code and Codex Day1 Lab

Optimize your dev workflow with Claude Code and Codex Day2 Lecture

Optimize your dev workflow with Claude Code and Codex Day2 Lab

Day 1 Lecture: Graph RAG vs Vector RAG

Day 1 Lab: Building Graph RAG in production

Day 2 Lecture: Types of Agents (reflection, plan-and-execute, rewoo)

Day 2 Lab: Enhancing RAG with Agentic AI

Capstone Architecture Feedback

Inefficient OpenClaw Agent

MCP and Agentic AI Day 1 Lecture

MCP and Agentic AI Day 1 Lab

MCP and Agentic AI Day 2 Lecture

MCP and Agentic AI Day 2 Lab

OpenClaw and Automating business processes Day1 Lecture

OpenClaw and Automating business processes Day1 Lab

OpenClaw and Automating business processes Day2 Lecture

OpenClaw and Automating business processes Day2 Lab

Guardrails and evaluation criteria

Adding Guardrails to Openclaw Agents

Creating Evaluation Criteria assignment

MLOPs and Guardrails Day 1 Lecture

MLOPs and Guardrails Day 1 Lab

MLOPs and Guardrails Day 2 Lecture

MLOPs and Guardrails Day 2 Lab

Day 1 Lecture: Trusting your workflows (evaluation metrics and guardrails)

Day 1 Lab: Setting up CI/CD for an AI application

Day 2 Lecture: Understanding LLM Reasoning traceability

Day 2 Lab: Tracing LLM reasoning with LangChain + LangSmith

Supplemental lab session on GuardrailsAI

OpenClaw Safeguards & Measuring business value for AI Agents Day1 Lecture

OpenClaw Safeguards & Measuring business value for AI Agents Day1 Lab

OpenClaw Safeguards & Measuring business value for AI Agents Day2 Lecture

OpenClaw Safeguards & Measuring business value for AI Agents Day2 Lab

Submit your Capstone Project Proposal

Submit your Capstone Project (Copy)

Submit your Captsone

Submit your Capstone Project

How to make AI that actualy provides Value Lecture

How to make AI that actualy provides Value Lab

Big Picture AI Applications Lecture

Big Picture AI Applications Lab

Evaluations and Reliability MLOps Lecture

Evaluations and Reliability MLOps Lab

How to deploy AI Agents using Claude managed Agents Lecture

How to deploy AI Agents using Claude managed Agents Lab

Day 1 Lecture: Leveraging MCP and tools to integrate effectively

Day 1 Lab: Using MCP to build more powerful agents

Day 2 Lecture: How to link your AI agent to value 

Day 2 Lab: Building an asynchronous vs synchronous agent

AIExpert

Master dbt, Snowflake, Iceberg, and Airflow — and become the analytics engineer every data team fights to hire.

Jess Ramos - Data Analyst 

Madison Schott - Analytics Engineer 

Ben Rogojan - Fractional Head of Data

John Kutay - Director of Engineering at Rippling

Vin Vashishtha - Author of From Data to Profit

Parth Parekh - Director of Data Engineering at Meta

Prasad Rao - Principal Solutions Architect

Andrew Madson - Head of DevRel at Fivetran

Gourav Khanijoe - Engineering Lead at HubSpot

Carly Taylor - Field CTO at Databricks (2.0)

Jess Ramos - Data Analyst (2.0)

Madison Schott - Analytics Engineer (2.0)

Tim Chan - Data at OpenAI

Joe Reis - Author of Fundamentals of Data Engineering

Madison Schott - Analytics Engineer (3.0)

Carly Taylor - Field CTO at Databricks (3.0)

Raaid A. - AI, Data, & Product Strategy Leader 

Parth Parekh - Director of Data Engineering at Meta (2.0)

Capstone Project

Capstone Project Proposal

Understanding Capstone Requirements

Analytics Engineering Bootcamp Kickoff

Capstone Requirements

Data Expert.io Architecture

Onboarding Guide for the Data and AI Engineering Bootcamp

Complex Data Types Lecture

Complex Data Types Lab

Slowly Changing Dimensions Lecture

Slowly Changing Dimensions Lab

Graph Data Modeling Lecture

Graph Data Modeling Lab

Fact Data Modeling Lecture

Fact Data Modeling Lab

Data modeling with Date lists Lecture

Data modeling with Date lists Lab

Q&A with Zach Week 1

Q&A with Zach Week 2

Q&A with Zach Week 3

Q&A with Zach Week 4

Q&A with Zach Week1

Q&A with Zach Week2

Q&A with Zach Week3

Q&A with Zach Week4

Q&A with Zach Week5

dbt-basics-assignment

dbt basics Jan 2026

dbt basics Apr 2025

dbt basics:  How dbt works: sources, models, packages Lecture

dbt basics:  How dbt works: sources, models, packages Lab

dbt basics: creating a full dbt project lecture

dbt basics: creating a full dbt project lab

Build your first pipeline with dbt

Build your first pipeline with dbt Lab

Creating a full dbt Project Lecture

AnalyticsExpert

This gets you access to all self-paced content and the discord community of highly motivated learners!

All-Access DataExpert.io Subscription

TEST PREVIEW 5 — SQL Window Functions Deep Dive

About this lesson

Hosted by

Join this lesson