# DataExpert.io Academy

> Master data engineering and AI like a big tech engineer

Pages are server-rendered HTML. Course lessons require enrollment; lesson pages show a public overview. Program and lesson pages also have a markdown version: add `.md` to the URL (e.g. https://www.dataexpert.io/program/<slug>.md). Full-text version of this file: https://www.dataexpert.io/llms-full.txt

## Programs

- [Snowflake and dbt Analytics Engineering Boot Camp](https://www.dataexpert.io/program/snowflake-dbt-analytics-engineering-boot-camp-4721): Master Snowflake, Airflow and dbt and become a powerful analytics engineer
- [All-Access DataExpert.io Subscription](https://www.dataexpert.io/program/all-access-dataexpert-io-subscription): This gets you access to all self-paced content and the discord community of highly motivated learners!

## Interview Practice

- [Mock interviews](https://www.dataexpert.io/interviews): AI-graded mock interviews by role
- [Netflix Data Engineer Interview](https://www.dataexpert.io/interviews/netflix-data-engineer): A themed six-round mock interview simulating a real Netflix Data Engineer loop. Covers SQL analytics on viewing behavior, data pipeline architecture for streaming events, dimensional modeling for the…
- [Airbnb Analytics Engineer Interview](https://www.dataexpert.io/interviews/airbnb-analytics-engineer): A themed six-round mock interview simulating a real Airbnb Analytics Engineer loop. Covers marketplace SQL analytics (funnels, cohorts, occupancy), dimensional modeling for a two-sided marketplace, e…
- [OpenAI AI Engineer Interview](https://www.dataexpert.io/interviews/openai-ai-engineer): A themed six-round mock interview simulating a real OpenAI AI Engineer loop. Covers SQL for ML monitoring and usage analytics, system design for LLM-powered infrastructure, evaluation framework archi…
- [Data Modeling Gauntlet](https://www.dataexpert.io/interviews/data-modeling-gauntlet): A five-round, escalating deep-dive on dimensional modeling. Start with basic star schemas, progress through Slowly Changing Dimensions and multi-valued relationships, design petabyte-scale facts, and…
- [Data System Design Gauntlet](https://www.dataexpert.io/interviews/system-design-gauntlet): A five-round deep-dive mock interview focused entirely on data architecture design at production scale. Each round escalates in complexity: from batch warehouse design, to real-time streaming, to exp…
- [DSA Gauntlet](https://www.dataexpert.io/interviews/dsa-gauntlet): A deep-dive five-question DSA interview for Senior Data Engineers. Covers sliding-window stream processing, heap-based merging with memory budgets, graph dependency traversal with topological sorting…
- [SQL practice questions](https://www.dataexpert.io/questions): 67 hands-on SQL problems with an in-browser editor

## Free Lessons

- [Scala Dataset vs Dataframe API Dec 15, 2023](https://www.dataexpert.io/lesson/spark-bonus-v3): Interview Skills
- [Dimensional Data Modeling: Graph Data Modeling Day 3 Lecture](https://www.dataexpert.io/lesson/dimensional-data-modeling-day-3-lecture-yt-p736-l666)
- [Bootcamp Kickoff](https://www.dataexpert.io/lesson/bootcamp-kickoff-yt-p736-l703): Kickoff
- [The Data Modeling Interview](https://www.dataexpert.io/lesson/the-data-modeling-interview): Interview Skills
- [Dimensional Data Modeling: Building Slowly Changing Dimensions Day 2 Lab](https://www.dataexpert.io/lesson/dimensional-data-modeling-day-2-lab-yt-p736-l661)
- [Intro to HTML & CSS](https://www.dataexpert.io/lesson/intro-to-html-and-css-94d04): Web Dev Fundamentals
- [LLMs - Using LLMs to provide business value Day 1 Lab](https://www.dataexpert.io/lesson/machine-learning-day-1-lab-v4): Week 6: Machine Learning
- [The Data Architecture Interview](https://www.dataexpert.io/lesson/the-data-architecture-interview): Interview Skills
- [LLMs - Vector database for RAG applications Day 2 Lab](https://www.dataexpert.io/lesson/machine-learning-day-2-lab-v4): Week 6: Machine Learning
- [Boot Camp Database Setup](https://www.dataexpert.io/lesson/boot-camp-database-setup-yt-p736-l704): Kickoff
- [Applying Analytical Patterns: Recursive CTEs and Window Functions Day 2 Lecture](https://www.dataexpert.io/lesson/applying-analytical-patterns-day-2-lecture-yt-p736-l672)
- [The Data Structures and Algorithms Interview](https://www.dataexpert.io/lesson/the-data-structures-and-algorithms-interview): Interview Skills
- [Dimensional Data Modeling Complex Data Type and Cumulation Day 1 Lab](https://www.dataexpert.io/lesson/dimensional-data-modeling-lab-day-1-yt-p736-l659)
- [Capstone Project](https://www.dataexpert.io/lesson/capstone-project-v3): Capstone Project
- [LLM-Driven Data Engineering Day 1 Lecture](https://www.dataexpert.io/lesson/large-language-models-day-1-lecture)
- [Data Pipeline Maintenance: Navigating the Complexities of Data Engineering Day 1 Lecture](https://www.dataexpert.io/lesson/data-pipeline-maintenance-day-1-lecture-yt-p736-l686)
- [Staff Engineer Career Progression](https://www.dataexpert.io/lesson/staff-engineer-career-progression-4308)
- [Staff Engineer Career Progression](https://www.dataexpert.io/lesson/staff-engineer-career-progression)
- [Dimensional Data Modeling Complex Data Type and Cumulation Day 1 Lecture](https://www.dataexpert.io/lesson/dimensional-data-modeling-lecture-day-1-yt-p736-l658)
- [Dimensional Data Modeling: Graph Data Modeling Day 3 Lab](https://www.dataexpert.io/lesson/dimensional-data-modeling-day-3-lab-yt-p736-l667)
- [The Behavioral Interview](https://www.dataexpert.io/lesson/the-behavioral-interview): Interview Skills
- [Dimensional Data Modeling: Building Slowly Changing Dimensions Day 2 Lecture](https://www.dataexpert.io/lesson/dimensional-data-modeling-day-2-lecture-yt-p736-l660)
- [LLM-Driven Data Engineering Day 2 Lab](https://www.dataexpert.io/lesson/large-language-models-day-2-lab)
- [Test Loom](https://www.dataexpert.io/lesson/test-loom): test module
- [Monetizing Part 3: Products & Funnels  by Zach Wilson
](https://www.dataexpert.io/lesson/linkedin-masterclass-6): Making Content on LinkedIn
- [LLM-Driven Data Engineering Day 2 Lecture](https://www.dataexpert.io/lesson/large-language-models-day-2-lecture)
- [KPIs and Experimentation: Setting up and Analysing Experiments Day 1 Lab](https://www.dataexpert.io/lesson/kpis-and-experimentation-day-1-lab-yt-p736-l695)
- [LLMs - Using LLMs to provide business value Day 1 Lecture](https://www.dataexpert.io/lesson/machine-learning-day-1-lecture-v4): Week 6: Machine Learning
- [The SQL Interview](https://www.dataexpert.io/lesson/the-sql-interview): Interview Skills
- [Applying Analytical Patterns: Mastering Growth Accounting and Retention Analysis Day 1 Lab](https://www.dataexpert.io/lesson/applying-analytical-patterns-day-1-lab-yt-p736-l671)
- [Test Loom](https://www.dataexpert.io/lesson/test-loom-6831): test module
- [LLMs - Vector database for RAG applications Day 2 Lecture](https://www.dataexpert.io/lesson/machine-learning-day-2-lecture-v4): Week 6: Machine Learning
- [Onboard to DataExpert Platform](https://www.dataexpert.io/lesson/subscription-onboarding-lesson)
- [LLM-Driven Data Engineering Day 1 Lab](https://www.dataexpert.io/lesson/large-language-models-day-1-lab)

## Company

- [Pricing](https://www.dataexpert.io/pricing): Plans and subscription options
- [Reviews](https://www.dataexpert.io/reviews): Student reviews and outcomes
- [About the instructor](https://www.dataexpert.io/about)
- [Scholarships](https://www.dataexpert.io/scholarships)
- [Contact](https://www.dataexpert.io/contact)
- [Blog](https://www.dataexpert.io/blog): Articles and newsletter

## Optional

- [Full text for LLMs](https://www.dataexpert.io/llms-full.txt)
- [Sitemap](https://www.dataexpert.io/sitemap.xml)
- [TA Office Hour 5](https://www.dataexpert.io/lesson/ta-office-hour-5-jan2025)
- [RAG and LLMs Day2 Lecture](https://www.dataexpert.io/lesson/rag-and-llms-day-2-lecture-jan2025)
- [Q&A with Zach Week 3 (2025-07-25)](https://www.dataexpert.io/lesson/qa-with-zach-week3-july2025-p737-l1304): Q&A with Zach
- [Data Quality Patterns: WAP Patterns Day 2 Lecture](https://www.dataexpert.io/lesson/data-quality-patterns-day-2-lecture-yt-p736-l700)
- [Course 2 updating - test](https://www.dataexpert.io/lesson/course-2-updating-test-6933)
- [RAG optimisation + Reranking Day 1 Lecture](https://www.dataexpert.io/lesson/rag-optimisation-reranking-day1-lecture-oct-2025-p737-l1510): Week 2: Advanced RAG, Reranking & Dev Workflow
- [Real Time data with Delta Live Table Day2 Lab](https://www.dataexpert.io/lesson/realtimedatawithdeltalivetableday2lab-aug26)
- [How to use snowpark and Snowflake optimization Lab](https://www.dataexpert.io/lesson/how-to-use-snowpark-and-snowflake-optimization-lab): Applying Analytical Patterns
- [Capstone Project Day 2 Class](https://www.dataexpert.io/lesson/capstone-project-day-2-class-april2025-p735-l1055): Week 8: End-to-End Project Hacking
- [Dimensional Data Modeling - Complex Data Types Arrays and Structs with Iceberg (Day 1 Lecture)](https://www.dataexpert.io/lesson/dimensional-data-modeling-day-1-lecture-v3): Week 1: Dimensional Data Modeling in Iceberg
- [Data Accessibility and Privacy (Day 4 Lecture)](https://www.dataexpert.io/lesson/fact-data-modeling-day-4-lecture-v4): Week 2: Fact Data Modeling in Iceberg
- [Test 2](https://www.dataexpert.io/lesson/890964a6-282e-4a75-921d-9b757dd788a3test2)
- [AI Application Setup](https://www.dataexpert.io/lesson/ai-application-setup-22551-p737-l1568): Kickoff & Setup
- [Test Course](https://www.dataexpert.io/lesson/631f3b55-d50a-452f-bb99-da927574e13atestcourse)
- [TA Office hour 6](https://www.dataexpert.io/lesson/taofficehour6-7abba-p735-l1944)
- [Book Club 5](https://www.dataexpert.io/lesson/bookclub5-mar26)
- [Q&A Week 3](https://www.dataexpert.io/lesson/qa-week-3-jan2025-p736-l781): Q&A with Zach
- [test 2](https://www.dataexpert.io/lesson/test2-6dc1a)
- [TA Office Hour 1 (2025-10-09)](https://www.dataexpert.io/lesson/ta-office-hour1-oct2025-p737-l1536)
- [Slowly Changing Dimensions Lecture](https://www.dataexpert.io/lesson/slowly-changing-dimensions-lecture): Bonus
- [Advanced dbt Lecture Day 1](https://www.dataexpert.io/lesson/advanced-dbt-lecture-day-1-april2025)
- [Chat with Zach](https://www.dataexpert.io/lesson/week-1-zach-qa-v4)
- [TA Office Hour 6 (2025-01-29)](https://www.dataexpert.io/lesson/ta-office-hour-6-jan2025-p736-l791)
- [Snowflake Basics Day 1 Lab](https://www.dataexpert.io/lesson/snowflake-basics-day-1-lab-jan2025)
- [TA Office Hour 5](https://www.dataexpert.io/lesson/ta-office-hour5-july2025)
- [Tech Talk with Carly](https://www.dataexpert.io/lesson/tech-talk4-oct2025)
- [Chat with Zach July 27, 2023](https://www.dataexpert.io/lesson/week-2-zach-qa-v2)
- [Apache Iceberg: Data Contracts Lecture](https://www.dataexpert.io/lesson/apache-iceberg-lecture-day-3-april2025-p735-l960): Week 5: Data Modeling on Iceberg
- [Azure - Week 5 (Copy)](https://www.dataexpert.io/lesson/azure-week-5-3166)
- [Loom](https://www.dataexpert.io/lesson/loom-4046)
- [Fact Data Modeling: Core Concepts, Deduplication Day 1 Lecture](https://www.dataexpert.io/lesson/fact-data-modeling-day-1-lecture-yt-p736-l662)
- [Q&A with Zach Week2](https://www.dataexpert.io/lesson/qawithzachweek2-feb26)
- [Book Club 2](https://www.dataexpert.io/lesson/bookclub2-mar26)
- [Career Development - Resume Review](https://www.dataexpert.io/lesson/career-development-resume-review-jan2025)
- [Write a comprehensive pipeline spec document Lab](https://www.dataexpert.io/lesson/pipeline-spec-building-lab): Pipeline Spec Building + Airflow Fundamentals
- [TA Office Hour 2 (2025-10-09)](https://www.dataexpert.io/lesson/ta-office-hour2-oct2025-p737-l1537)
- [Day 1 Lab: Vectorizing Inputs into Milvus](https://www.dataexpert.io/lesson/understanding-rag-day1-lab-july2025)
- [Introduction to Spark Day 2 Lecture](https://www.dataexpert.io/lesson/introduction-to-spark-day-2-lecture-jan2025)
- [TA Office Hour 6](https://www.dataexpert.io/lesson/ta-office-hour-6-jan2025)
- [TA Office Hour 5 (2025-01-29)](https://www.dataexpert.io/lesson/ta-office-hour-5-jan2025-p736-l790)
- [Introduction to IDEs](https://www.dataexpert.io/lesson/introduction-to-ides-af3aa): Web Dev Fundamentals
- [Q&A with Zach Week 1 (2025-07-10)](https://www.dataexpert.io/lesson/qa-with-zach-week1-july2025-p737-l1286): Q&A with Zach
- [Q&A with Zach Week4](https://www.dataexpert.io/lesson/qawithzachweek4-feb26)
- [OpenClaw Safeguards & Measuring business value for AI Agents Day2 Lab](https://www.dataexpert.io/lesson/openclawsafeguardsmeasuringbusinessvalueforaiagentsday2lab-mar26)
- [TA Office Hour 4 (2025-06-17)](https://www.dataexpert.io/lesson/ta-office-hour-4-p736-l1153)
- [Growth Accounting Lab](https://www.dataexpert.io/lesson/growthaccountinglab-c17bb)
- [Databricks and Advanced Spark Day1 Lecture](https://www.dataexpert.io/lesson/databricksandadvancedsparkday1lecture-feb26)
- [Analytics Data Quality - Mastering DBT Projects with Bruno: Practical Overview and Hands-On Demonstrations (Day 2 Lecture)](https://www.dataexpert.io/lesson/analytics-data-quality-day-2-lecture-v3): Week 5: DBT and Pipeline Spec Building
- [advanced dbt Day 1 Lecture](https://www.dataexpert.io/lesson/advanceddbtday1lecture-55678)
- [LinkedIn like a pro](https://www.dataexpert.io/lesson/career-dev-session2-july2025-p737-l1301): Career Development
- [Tech Talk - Joe Reis](https://www.dataexpert.io/lesson/v4-tech-talk-joe-reis-906)
- [Expanding Scope & Influence Without Authority](https://www.dataexpert.io/lesson/expandingscopeinfluencewithoutauthority-1f6e2)
- [Fact Data Modeling Lecture](https://www.dataexpert.io/lesson/fact-data-modeling-lecture): Bonus
- [TA Office Hour 1](https://www.dataexpert.io/lesson/ta-office-hour1-jul2025)
- [YZ](https://www.dataexpert.io/lesson/yz-jan2025)
- [Applying Analytical Patterns Day 1 Lab](https://www.dataexpert.io/lesson/applying-analytical-patterns-day-1-lab-jan2025)
- [Special Guests, Stephanie Nuesi and Joe Reis July 26, 2023](https://www.dataexpert.io/lesson/v2-special-guests-stephanie-nuesi-and-joe-reis-july-26-2023-3258)
- [TA Office hour 8](https://www.dataexpert.io/lesson/taofficehour8-feb26)
- [Advanced dbt Lab Day 1](https://www.dataexpert.io/lesson/advanced-dbt-lab-day-1-april2025)
- [Apache Spark Memory Turning, Partitioning Day 2 Lecture](https://www.dataexpert.io/lesson/apache-spark-memory-turning-partitioning-day-2-lecture-jan2025)
- [Snowflake Basics Day 1 Lab](https://www.dataexpert.io/lesson/snowflake-basics-day-1-lab-jan2025-p736-l770)
- [TA Office hours 3](https://www.dataexpert.io/lesson/taofficehours3-mar26-p737-l2131)
- [TA Office hour 4](https://www.dataexpert.io/lesson/taofficehour4-3892c-p736-l2050)
- [Special Guests, Stephanie Nuesi and Joe Reis July 26, 2023](https://www.dataexpert.io/lesson/week-2-speaker-v2)
- [RAG optimisation + Reranking Day 1 Lecture](https://www.dataexpert.io/lesson/rag-optimisation-reranking-day1-lecture-oct-2025)
- [Career Development - Data Modeling Interview  ](https://www.dataexpert.io/lesson/career-development-data-modeling-interview-jan2025-p736-l801): Career Development
- [Youtube](https://www.dataexpert.io/lesson/56ab37f4-896d-43a1-afbf-e0b7aebf8c18cours)
- [Understanding Read Streams and SCD Implementation Lab](https://www.dataexpert.io/lesson/understandingreadstreamsandscdimplementationlab-jan2026)
- [How to do Growth Accounting like Meta](https://www.dataexpert.io/lesson/howtodogrowthaccountinglikemeta-jan2026-p735-l1903): Week 7: Analytical Patterns & CDC
- [Managing Unstructured Data - Day 1 Lab](https://www.dataexpert.io/lesson/managing-unstructured-data-day-1-lab-may2025)
- [Apache Spark Shuffle Joins Day 1 Lab](https://www.dataexpert.io/lesson/apache-spark-shuffle-joins-day-1-lab-may2025)
- [Snowflake Basics Day 1 Lecture](https://www.dataexpert.io/lesson/snowflake-basics-day-1-lecture-jan2025)
- [Chat with Zach Nov 15, 2023](https://www.dataexpert.io/lesson/v3-2-chat-with-zach-nov-15-2023-6706)
- [Apache iceberg: WAP patterns and Querying branched Data Lab](https://www.dataexpert.io/lesson/apache-iceberg-lab-day-3-april2025-p735-l961): Week 5: Data Modeling on Iceberg
- [Q&A with Zach Week1](https://www.dataexpert.io/lesson/qawithzachweek1-jan2026-p735-l1929): Q&A with Zach
- [Tech Talk - Li](https://www.dataexpert.io/lesson/tech-talk-li-july2025)
- [Tech Talk - 2](https://www.dataexpert.io/lesson/tech-talk2-oct2025)
- [Apache Spark: Managing Spark Jobs and Notebooks Day 2 Lecture](https://www.dataexpert.io/lesson/apache-spark-day-2-lecture-yt-p736-l680)
- [Advanced SQL and Applying Analytical patterns  (Day 1 Lecture)](https://www.dataexpert.io/lesson/analytical-patterns-day-1-lecture-v4): Week 5: Analytical Patterns & Analysis in Iceberg
- [Azure - Week 4](https://www.dataexpert.io/lesson/azure-week-4-may2025)
- [Spark Data Quality (Day 3 Lab)](https://www.dataexpert.io/lesson/spark-batch-day-3-lab-v4): Week 4: Batch Pipelines with Apache Spark
- [How to load data into Iceberg with Airflow](https://www.dataexpert.io/lesson/howtoloaddataintoicebergwithairflow-16dc3)
- [Wednesday Quiz](https://www.dataexpert.io/lesson/wednesdayquiz-0d421)
- [Q&A with Zach 4](https://www.dataexpert.io/lesson/qawithzach4-mar26-p737-l2122): Q&A with Zach
- [Applying Advanced SQL for Analytical Insights - Aggregations and Cardinality Reduction in Bootcamp Web Events (Day 2 Lab)](https://www.dataexpert.io/lesson/analytical-patterns-day-2-lab-v3): Week 3: Analytical Patterns & Analysis in Iceberg
- [Azure - Week 3](https://www.dataexpert.io/lesson/azure-week-3-may2025-p736-l1149)
- [Advanced Spark (Day 2 Lab)](https://www.dataexpert.io/lesson/spark-batch-day-2-lab-v4): Week 4: Batch Pipelines with Apache Spark
- [MCP and Agentic AI Day 1 Lecture](https://www.dataexpert.io/lesson/mcpandagenticaiday1lecture-oct2025)
- [Carly Taylor - Field CTO at Databricks (2.0)](https://www.dataexpert.io/lesson/tech-talk-with-carly-taylor-p735-l592): Tech Talks
- [Special Guests, Carly Taylor and Ben Rogojan July 19, 2023](https://www.dataexpert.io/lesson/week-1-speaker-v2)
- [TA Office hour 2](https://www.dataexpert.io/lesson/taofficehour2-jan2026)
- [Building functional AI agents using LangChain Day1 Lecture](https://www.dataexpert.io/lesson/buildingfunctionalaiagentsusinglangchainday1lecture-mar26-p737-l2137): Week 1: Prompt Engineering & Basic RAG
- [Book Club 4](https://www.dataexpert.io/lesson/bookclub4-feb26)
- [Day 1 Lecture: Graph RAG vs Vector RAG](https://www.dataexpert.io/lesson/advanced-rag-and-agentic-ai-day1-lecture-july2025-p737-l1178): Week 2: Advanced RAG, Reranking & Dev Workflow
- [Build your first pipeline with dbt](https://www.dataexpert.io/lesson/buildyourfirstpipelinewithdbt-jan2026)
- [Snowflake and Glue Catalog Integration Lab](https://www.dataexpert.io/lesson/snowflakeandgluecatalogintegrationlab-jan2026-p735-l2005): Week 7: Analytical Patterns & CDC
- [Your Action Plan and wrap-up](https://www.dataexpert.io/lesson/youractionplanandwrapup-2a75b)
- [OpenClaw and Automating business processes Day2 Lecture](https://www.dataexpert.io/lesson/openclawandautomatingbusinessprocessesday2lecture-mar26)
- [Grouping sets and Window functions Lab](https://www.dataexpert.io/lesson/grouping-sets-and-window-functions-lab-p735-l581): Week 7: Analytical Patterns & CDC
- [Data Visualization and Impact: Mastering Data Engineering Day 1 Lecture](https://www.dataexpert.io/lesson/data-visualization-and-impact-day-1-lecture-yt-p736-l690)
- [Deep Dive On Workflows Day 3 Lecture](https://www.dataexpert.io/lesson/deep-dive-on-workflows-day-3-lecture-jan2025)
- [Deep Dive On Workflows Day 3 Lab](https://www.dataexpert.io/lesson/deep-dive-on-workflows-day-3-lab-jan2025)
- [Tuesday Quiz](https://www.dataexpert.io/lesson/tuesdayquiz-3abf8)
- [Prasad Rao - Principal Solutions Architect](https://www.dataexpert.io/lesson/tech-talk-8-prasad-rao-april2025-p735-l1062): Tech Talks
- [Intro to Javascript](https://www.dataexpert.io/lesson/intro-to-javascript-f6146): Web Dev Fundamentals
- [Advanced dbt: Understanding incremental models Lab](https://www.dataexpert.io/lesson/advanced-dbt-understanding-incremental-models-lab-p735-l569): Week 2: Advanced dbt
- [Tech Talk 5 - Carly Taylor](https://www.dataexpert.io/lesson/tech-talk-5-carly-taylor-april2025)
- [Tech talk with Tim Chan](https://www.dataexpert.io/lesson/tech-talk- with-tim-chan): Tech Talk
- [Dimensional Data Modeling - Complex Data Types Arrays and Structs with Iceberg (Day 1 Lab) - Pre-recorded from V3](https://www.dataexpert.io/lesson/dimensional-data-modeling-day-1-lab-v4): Week 1: Dimensional Data Modeling in Iceberg
- [Special Guests, Parth Parekh and Nick Singh August 16, 2023](https://www.dataexpert.io/lesson/week-5-speaker-v2)
- [Tech Talk - Sai](https://www.dataexpert.io/lesson/techtalks3-mar26)
- [Azure - Week 2 (Copy)](https://www.dataexpert.io/lesson/azure-week-2-7072)
- [Advanced Spark Optimization Techniques Day 1 Lab](https://www.dataexpert.io/lesson/advanced-spark-optimization-techniques-day-1-lab-jan2025-p736-l813): Week 4: Structured Streaming with Spark & Kafka
- [TA Office Hour 6](https://www.dataexpert.io/lesson/taofficehour6-3254f)
- [Chat with Zach July 20, 2023](https://www.dataexpert.io/lesson/week-1-zach-qa-v2)
- [advanced dbt Day 1 Lab](https://www.dataexpert.io/lesson/advanceddbtday1lab-jan2026)
- [Tech Talks - Carly](https://www.dataexpert.io/lesson/techtalksweek3-jan2026)
- [RAG optimisation + Reranking Day 1 Lab](https://www.dataexpert.io/lesson/rag-optimisation-reranking-day-oct)
- [Q&A with Zach Week 3](https://www.dataexpert.io/lesson/qa-with-zach-week-3-april2025-p735-l1000): Q&A with Zach
- [Dimensional Data Modeling - Graph Data Modeling with Iceberg (Day 3 Lecture)](https://www.dataexpert.io/lesson/dimensional-data-modeling-day-3-lecture-v3): Week 1: Dimensional Data Modeling in Iceberg
- [Thursday Quiz](https://www.dataexpert.io/lesson/thursdayquiz-3ef15)
- [Advanced Data Pipeline Maintenance - Understanding Complex Pipeline Topology (Day 2 Lab)](https://www.dataexpert.io/lesson/pipeline-maintenance-day-2-lab-v3): Week 6: Data Pipeline Maintenance
- [Day 2 Lecture: How to link your AI agent to value ](https://www.dataexpert.io/lesson/building-end-to-end-ai-application-day2-lecture-july25)
- [Flink Lab Setup](https://www.dataexpert.io/lesson/flink-lab-setup-yt-p736-l708)
- [TA Office hour 4](https://www.dataexpert.io/lesson/taofficehour4-jan2026)
- [Apache Iceberg Day 2 Lab](https://www.dataexpert.io/lesson/apache-iceberg-day-2-lab-jan2025)
- [Apache Iceberg Lab Day1](https://www.dataexpert.io/lesson/apacheiceberglabday1-cbfc8)
- [Tech Talk - Carly Taylor](https://www.dataexpert.io/lesson/guest-speaker-10-v4)
- [Introduction to Spark Day 2 Lab](https://www.dataexpert.io/lesson/introduction-to-spark-day-2-lab-jan2025-p736-l776): Week 1: Databricks Basics
- [Sunday Quiz](https://www.dataexpert.io/lesson/sundayquiz-1b699)
- [QnA with Zach 2](https://www.dataexpert.io/lesson/qnawithzach2-aug26)
- [Apache Iceberg Data Contracts Lecture](https://www.dataexpert.io/lesson/apache-iceberg-data-contracts-day-3-lecture-may2025)
- [Databricks Platform Overview Day 1 Lab](https://www.dataexpert.io/lesson/databricks-platform-overview-day-1-lab-jan2025-p736-l772): Week 1: Databricks Basics
- [CDC Pipelines and Triggers ](https://www.dataexpert.io/lesson/cdc-and-push-pipelines)
- [Yuzheng Sun - Staff Data Scientist at Statsig](https://www.dataexpert.io/lesson/yz-jan2025-p736-l802): Guest Speakers
- [End-to-End AI Applications Day 2 Lab](https://www.dataexpert.io/lesson/building-end-to-end-ai-application-day2-lab-oct25)
- [Building functional AI agents using LangChain Day2 Lab](https://www.dataexpert.io/lesson/buildingfunctionalaiagentsusinglangchainday2lab-mar26)
- [Unit Testing](https://www.dataexpert.io/lesson/unit-testing-cd643): Office Hours
- [Structured Streaming Kafka to Delta Live Table Day1 Lecture](https://www.dataexpert.io/lesson/structuredstreamingkafkatodeltalivetableday1lecture-feb26-p736-l2029): Week 4: Structured Streaming with Spark & Kafka
- [The 2026 Context Engineering QnA](https://www.dataexpert.io/lesson/the2026contextengineering-qna)
- [Q&A with Zach Week5](https://www.dataexpert.io/lesson/qawithzachweek5-jan2026-p735-l1933): Q&A with Zach
- [OpenClaw Safeguards & Measuring business value for AI Agents Day1 Lab](https://www.dataexpert.io/lesson/openclawsafeguardsmeasuringbusinessvalueforaiagentsday1lab-mar26-p737-l2150): Week 4: MLOps, Guardrails & Business Value
- [TA Office Hour 1 (2025-01-14)](https://www.dataexpert.io/lesson/ta-office-hour-1-jan2025-p736-l721)
- [Azure - Week 1](https://www.dataexpert.io/lesson/azure-week-1-may2025-p736-l1080)
- [Tech Talk 4 - John Kutay](https://www.dataexpert.io/lesson/tech-talk-4-john-kutay-april2025)
- [Build your first pipeline with dbt](https://www.dataexpert.io/lesson/buildyourfirstpipelinewithdbt-93144)
- [TA Office Hour 6 (2025-06-19)](https://www.dataexpert.io/lesson/ta-office-hour-6-may2025-p736-l1158)
- [Navigating Data Engineering -Tips, Tools, and Career Insights](https://www.dataexpert.io/lesson/navigating-data-engineering-tips-tools-and-career-insights-may2025-p736-l1196): Q&A with Zach
- [dbt Basics Day 3 Lecture](https://www.dataexpert.io/lesson/dbt-basics-day-3-lecture-jan2025)
- [TA Office Hour 2](https://www.dataexpert.io/lesson/ta-office-hour-2-may2025)
- [Jason Reid - Co-founder at Tabular](https://www.dataexpert.io/lesson/jason-reid-cofounder-of-tabular-p736-l719): Guest Speakers
- [Snowflake Lab](https://www.dataexpert.io/lesson/snowflake-lab-jan2025)
- [Q&A with Zach Week1](https://www.dataexpert.io/lesson/qawithzachweek1-jan2026)
- [Building AI Agents with Databricks Day2 Lecture](https://www.dataexpert.io/lesson/buildingaiagentswithdatabricksday2lecture-feb26)
- [Q&A with Zach Week 5](https://www.dataexpert.io/lesson/qa-with-zach-week5-oct2025)
- [Joe Reis - Author of Fundamentals of Data Engineering](https://www.dataexpert.io/lesson/techtalksweek1-jan2026-p735-l1934): Tech Talks
- [Week 6 lab part 1](https://www.dataexpert.io/lesson/week-6-lab-part-1): Advanced Frontend Development
- [Book Club 1](https://www.dataexpert.io/lesson/bookclub1-c98da)
- [Career Dev Session 4](https://www.dataexpert.io/lesson/careerdevsession4-94f20)
- [Prompt Engineering Day1 Lab](https://www.dataexpert.io/lesson/prompt-engineering-day1-lab-oct2025)
- [Book Club 4](https://www.dataexpert.io/lesson/bookclub4-mar26)
- [Exploring UDFs and SQL Benchmarks in Spark Streaming](https://www.dataexpert.io/lesson/exploringudfsandsqlbenchmarksinsparkstreaming-feb26-p736-l2113): Week 4: Structured Streaming with Spark & Kafka
- [TA Office hours 7](https://www.dataexpert.io/lesson/taofficehours7-mar26-p737-l2135)
- [Onboarding Guide for the Data and AI Engineering Bootcamp](https://www.dataexpert.io/lesson/onboardingguideforthedataandaiengineeringbootcamp-jan2026)
- [Tech Talk with Xinran Waibel](https://www.dataexpert.io/lesson/tech-talk1-oct2025)
- [Advanced Snowflake: Data Modeling and UDFs Lecture](https://www.dataexpert.io/lesson/advanced-snowflake-data-modeling-and-udfs-lecture): Advanced Snowflake
- [Injecting quality into your Airflow DAG Lab](https://www.dataexpert.io/lesson/injectingqualityintoyourairflowdaglab-jan2026)
- [Write a comprehensive pipeline spec document Lab](https://www.dataexpert.io/lesson/pipeline-spec-building-lab-p735-l556): Week 6: Airflow & Pipeline Specs with Trino
- [Delta Table Day 1 Lab](https://www.dataexpert.io/lesson/delta-table-day-1-lab-may2025-p736-l1087): Week 3: Data Lakes with Delta Table
- [Slowly Changing Dimensions Lecture](https://www.dataexpert.io/lesson/slowly-changing-dimensions-lecture-p735-l576): Bonus
- [Applying Analytical Patterns Day 1 Lecture](https://www.dataexpert.io/lesson/applying-analytical-patterns-day-1-lecture-jan2025)
- [Data Quality Patterns: Spec-Building Document Day 1 Lab](https://www.dataexpert.io/lesson/data-quality-patterns-day-1-lab-yt-p736-l699)
- [Airflow Data Quality (Day 1 Lecture)](https://www.dataexpert.io/lesson/airflow-data-quality-day-1-lecture-v4): Week 3: Airflow and Airflow Data Quality
- [Local Video](https://www.dataexpert.io/lesson/localvideo-963b1)
- [Core Data Modeling Elements Saturday Quiz](https://www.dataexpert.io/lesson/core-data-modeling-quiz)
- [Chat with Zach](https://www.dataexpert.io/lesson/v4-5-chat-with-zach-686)
- [Advanced SQL Patterns Day 2 Lecture](https://www.dataexpert.io/lesson/advanced-sql-patterns-day-2-lecture-jan2025-p736-l818)
- [Youtube](https://www.dataexpert.io/lesson/youtube-2165)
- [V4 Boot Camp Kick-Off](https://www.dataexpert.io/lesson/boot-camp-kick-off-v4): Boot Camp Orientation
- [Advanced dbt: Production Pipelines and dbt with Airflow Lab](https://www.dataexpert.io/lesson/advanceddbtday2lab-jan2026-p735-l1924): Week 2: Advanced dbt
- [Managing Unstructured Data - Day 2 Lecture](https://www.dataexpert.io/lesson/managing-unstructured-data-day-2-lecture-may2025-p736-l1198): Week 5: Managing Unstructured Data
- [Q&A with Zach Week 3](https://www.dataexpert.io/lesson/qa-with-zach-week3-oct2025)
- [Loom](https://www.dataexpert.io/lesson/loom-8070)
- [Q&A with Zach Week1](https://www.dataexpert.io/lesson/qawithzachweek1-feb26-p736-l2037): Q&A with Zach
- [Apache Spark Unit Testing Day 3 Lab](https://www.dataexpert.io/lesson/apache-spark-unit-testing-day-3-lab-jan2025)
- [MLOPs and Guardrails Day 1 Lab](https://www.dataexpert.io/lesson/ml-ops-day1-lab-oct25)
- [Apache Spark Shuffle Joins Day 1 Lab](https://www.dataexpert.io/lesson/apache-spark-shuffle-joins-day-1-lab-jan2025-p736-l789): Week 2: Databricks & Advanced Spark
- [Lesson 4](https://www.dataexpert.io/lesson/lesson-4-8341)
- [TA Office Hour 4 (2025-10-09)](https://www.dataexpert.io/lesson/ta-office-hour4-oct2025-p737-l1539)
- [Tech Talk 8 - Prasad Rao](https://www.dataexpert.io/lesson/tech-talk-8-prasad-rao-april2025)
- [Infrastructure Data Quality - Implementing Data Quality Measures with Astronomer and Airflow: Hands-On Lab with Marc Lamberti (Day 2 Lab)](https://www.dataexpert.io/lesson/infra-data-quality-day-2-lab-v3): Week 5: Unit Testing Pipelines & Write-audit-publish
- [Chat with Zach](https://www.dataexpert.io/lesson/v4-4-chat-with-zach-5051)
- [Local Video](https://www.dataexpert.io/lesson/local-video-1727)
- [Analytics Data Quality - Exploring Data Modeling and Quality Checks (Day 1 Lab)](https://www.dataexpert.io/lesson/analytics-data-quality-day-1-lab-v3): Week 5: DBT and Pipeline Spec Building
- [Analytics Engineering Bootcamp Kickoff](https://www.dataexpert.io/lesson/analytics-engineering-bootcamp-kickoff): Bootcamp Orientation
- [MCP and Agentic AI Day 1 Lecture](https://www.dataexpert.io/lesson/mcpandagenticaiday1lecture-oct2025-p737-l1606): Week 3: Agentic AI, MCP & Automation
- [Book Club 4](https://www.dataexpert.io/lesson/book-club-4-oct2025)
- [TA Office Hour 7](https://www.dataexpert.io/lesson/ta-office-hour-7-may2025)
- [Orchestration and Airflow Fundamentals Lecture](https://www.dataexpert.io/lesson/orchestration-and-airflow-fundamentals-lecture): Pipeline Spec Building + Airflow Fundamentals
- [dbt basics: creating a full dbt project lecture](https://www.dataexpert.io/lesson/dbt-basics-creating-a-full-dbt-project-lecture): dbt basics
- [Q&A with Zach 3](https://www.dataexpert.io/lesson/qawithzach3-mar26)
- [Chat with Zach Aug 10, 2023](https://www.dataexpert.io/lesson/week-4-zach-qa-v2)
- [TA Office Hour 3](https://www.dataexpert.io/lesson/ta-office-hour-3-may2025)
- [OpenClaw Safeguards & Measuring business value for AI Agents Day1 Lab](https://www.dataexpert.io/lesson/openclawsafeguardsmeasuringbusinessvalueforaiagentsday1lab-mar26)
- [advanced dbt Day 2 Lab](https://www.dataexpert.io/lesson/advanceddbtday2lab-jan2026)
- [Spark Structured Streaming Day 2 Lecture](https://www.dataexpert.io/lesson/spark-structured-streaming-day-2-lecture-jan2025)
- [advanced dbt Day 1 Lab](https://www.dataexpert.io/lesson/advanceddbtday1lab-e01c7)
- [Q&A with Zach 1](https://www.dataexpert.io/lesson/qawithzach1-mar26-p737-l2119): Q&A with Zach
- [MCP and Agentic AI Day 2 Lab](https://www.dataexpert.io/lesson/mcp-and-agentic-ai-day2lab-oct2025-p737-l1609): Week 3: Agentic AI, MCP & Automation
- [Special Guests, Parth Parekh and Nick Singh August 16, 2023](https://www.dataexpert.io/lesson/v2-special-guests-parth-parekh-and-nick-singh-august-16-2023-4496)
- [Friday Quiz](https://www.dataexpert.io/lesson/fridayquiz-efa43)
- [dbt Basics Day 3 Lab](https://www.dataexpert.io/lesson/dbt-basics-day-3-lab-jan2025)
- [Connecting the database to the service](https://www.dataexpert.io/lesson/9108e798-515c-438e-9344-1610f25ff638connectingthedatabasetotheservice): Intermediate Backend Development
- [QnA with Zach 4](https://www.dataexpert.io/lesson/qnawithzach4-aug26)
- [Building AI Agents with Databricks Day1 Lab](https://www.dataexpert.io/lesson/buildingaiagentswithdatabricksday1lab-feb26-p736-l2034): Week 6: Building AI Agents with Databricks
- [TA Office Hour 1 (2025-06-04)](https://www.dataexpert.io/lesson/ta-office-hour-1-may2025-p736-l1085)
- [Communicating Ideas and Getting Alignment](https://www.dataexpert.io/lesson/communicating-ideas-and-getting-alignment): Soft Skills
- [Q&A with Zach Week 5 (2025-10-09)](https://www.dataexpert.io/lesson/qa-with-zach-week5-oct2025-p737-l1548): Q&A with Zach
- [Day 1 Lab: Auto Prompt Optimization with dspy](https://www.dataexpert.io/lesson/prompt-engineering-day1-lab-jul2025)
- [Apache Flink Streaming - Exploring Data Collection and Processing with Kafka in Flink (Day 2 Lecture)](https://www.dataexpert.io/lesson/infra-flink-streaming-day-2-lecture-v3): Week 3: Streaming Pipelines with Apache Flink
- [TA Office Hour 5](https://www.dataexpert.io/lesson/ta-office-hour5-oct2025)
- [Building functional AI agents using LangChain Day1 Lab](https://www.dataexpert.io/lesson/buildingfunctionalaiagentsusinglangchainday1lab-mar26-p737-l2138): Week 1: Prompt Engineering & Basic RAG
- [Special Guests, Stephanie Nuesi and Joe Reis July 26, 2023](https://www.dataexpert.io/lesson/v2-special-guests-stephanie-nuesi-and-joe-reis-july-26-2023-6878)
- [Career Dev Session 5](https://www.dataexpert.io/lesson/careerdevsession5-f1228)
- [Tuesday Quiz](https://www.dataexpert.io/lesson/tuesdayquiz-a58fc)
- [TA Office hour 1](https://www.dataexpert.io/lesson/taofficehour1-jan2026-p735-l1939)
- [Special Guest, Alex Freberg August 2, 2023](https://www.dataexpert.io/lesson/week-3-speaker-v2)
- [Advanced dbt: Understanding incremental models Lecture](https://www.dataexpert.io/lesson/advanced-dbt-understanding-incremental-models-lecture-p735-l568): Week 2: Advanced dbt
- [Test Lesson](https://www.dataexpert.io/lesson/a4859c01-6e2f-4d69-b0ed-b86960deaf7ftestlesson)
- [Q&A with Zach 5](https://www.dataexpert.io/lesson/qawithzach5-mar26-p737-l2123): Q&A with Zach
- [TA Office Hour 1](https://www.dataexpert.io/lesson/ta-office-hour-1-april2025)
- [OpenClaw Safeguards & Measuring business value for AI Agents Day1 Lecture](https://www.dataexpert.io/lesson/openclawsafeguardsmeasuringbusinessvalueforaiagentsday1lecture-mar26)
- [Brian Pulliam - Career Developement Coach (2.0)](https://www.dataexpert.io/lesson/brian-pulliam-jan2025-p736-l783): Guest Speakers
- [advanced dbt Day 2 Lecture](https://www.dataexpert.io/lesson/advanceddbtday2lecture-jan2026)
- [Conceptual Data Modeling (Day 3 Lecture)](https://www.dataexpert.io/lesson/dimensional-data-modeling-day-3-lecture-v4): Week 1: Dimensional Data Modeling in Iceberg
- [test 5](https://www.dataexpert.io/lesson/test5-ac697)
- [Career Dev Session 3](https://www.dataexpert.io/lesson/career-dev-session3-oct2025-p737-l1530): Career Development
- [Q&A with Zach Week 2](https://www.dataexpert.io/lesson/qa-with-zach-week2-july2025)
- [Real Time data with Delta Live Table Day1 Lab](https://www.dataexpert.io/lesson/realtimedatawithdeltalivetableday1lab-aug26)
- [OpenClaw Safeguards & Measuring business value for AI Agents Day2 Lecture](https://www.dataexpert.io/lesson/openclawsafeguardsmeasuringbusinessvalueforaiagentsday2lecture-mar26)
- [You must learn Databricks in 2026 - The DataExpert.io Roadmap Lab](https://www.dataexpert.io/lesson/youmustlearndatabricksin2026thedataexpertioroadmap-lab)
- [Analytical Patterns Recognizing Business Value Day 3 Lecture](https://www.dataexpert.io/lesson/analytical-patterns-recognizing-business-value-day-3-lecture-jan2025-p736-l820)
- [How to use Snowpark and Snowflake Optimizations Lab Day 2](https://www.dataexpert.io/lesson/how-to use-snowpark-and-snowflake-optimizations-lab-day-2-april2025)
- [Airflow Data Quality (Day 2 Lecture)](https://www.dataexpert.io/lesson/airflow-data-quality-day-2-lecture-v4): Week 3: Airflow and Airflow Data Quality
- [Dimensional Data Modeling - Graph Data Modeling with Iceberg (Day 3 Lab)](https://www.dataexpert.io/lesson/dimensional-data-modeling-day-3-lab-v3): Week 1: Dimensional Data Modeling in Iceberg
- [Live SQL Training January 25th, Window Functions and Common Table Expressions](https://www.dataexpert.io/lesson/live-sql-training-jan-25-window-functions-common-table-expressions): Interview Skills
- [How to deploy AI Agents using Claude managed Agents Lab](https://www.dataexpert.io/lesson/endtoendaiapplicationsday2lab-mar26-p737-l2156): Week 5: End-to-End AI Applications
- [Backfilling with Airflow](https://www.dataexpert.io/lesson/backfillingwithairflow-3483a-p735-l2003): Week 6: Airflow & Pipeline Specs with Trino
- [MLOPs and Guardrails Day 2 Lecture](https://www.dataexpert.io/lesson/ml-ops-day2-lecture-oct25)
- [Cumulative DAGs in Production Day 3 Lab](https://www.dataexpert.io/lesson/cumulative-dags-in-production-day-3-lab-jan2025)
- [Chip Huyen - Author of AI Engineering](https://www.dataexpert.io/lesson/tech-talk-chip-july25-p737-l1379): Tech Talks
- [Apache Spark Unit Testing Day 3 Lecture](https://www.dataexpert.io/lesson/apache-spark-unit-testing-day-3-lecture-may2025-p736-l1147): Week 2: Databricks & Advanced Spark
- [Apache Flink Streaming - Mastering Streaming and Real-Time Data Processing with Apache Flink (Day 1 Lecture)](https://www.dataexpert.io/lesson/infra-flink-streaming-day-1-lecture-v3): Week 3: Streaming Pipelines with Apache Flink
- [TA Office hours 2](https://www.dataexpert.io/lesson/taofficehours2-mar26)
- [Orchestration and Airflow Fundamentals Lab](https://www.dataexpert.io/lesson/orchestration-and-airflow-fundamentals-lab-p735-l554): Week 6: Airflow & Pipeline Specs with Trino
- [Book Club 5](https://www.dataexpert.io/lesson/bookclub5-12234)
- [How to deploy AI Agents using Claude managed Agents Lecture](https://www.dataexpert.io/lesson/endtoendaiapplicationsday2lecture-mar26-p737-l2155): Week 5: End-to-End AI Applications
- [Databricks and Advanced Spark Day2 Lab](https://www.dataexpert.io/lesson/databricksandadvancedsparkday2lab-feb26-p736-l2028): Week 2: Databricks & Advanced Spark
- [Snowflake and Glue Catalog Integration Lab](https://www.dataexpert.io/lesson/snowflakeandgluecatalogintegrationlab-jan2026)
- [Book Club 1](https://www.dataexpert.io/lesson/bookclub1-51a9d)
- [Tim Chan - Data at OpenAI](https://www.dataexpert.io/lesson/tech-talk- with-tim-chan-p735-l596): Tech Talks
- [Day 1 Lab: Setting up CI/CD for an AI application](https://www.dataexpert.io/lesson/ml-ops-day1-lab-july25-p737-l1184): Week 4: MLOps, Guardrails & Business Value
- [Managing Unstructured Data Day1 Lecture](https://www.dataexpert.io/lesson/managingunstructureddataday1lecture-feb26-p736-l2084): Week 5: Managing Unstructured Data
- [Structure of a Program](https://www.dataexpert.io/lesson/structure-of-a-program-596e3): Web Dev Fundamentals
- [Special Guests, Jitender Aswani and Bill Inmon August 23, 2023](https://www.dataexpert.io/lesson/v2-special-guests-jitender-aswani-and-bill-inmon-august-23-2023-4321)
- [Apache Spark programming with Databricks Day 1 Lecture](https://www.dataexpert.io/lesson/apache-spark-programming-with-databricks-day-1-lecture-may2025-1-p736-l1157): Week 4: Structured Streaming with Spark & Kafka
- [Setting up your Databricks App](https://www.dataexpert.io/lesson/setting-up-your-databricks-app)
- [TA Office hour 4](https://www.dataexpert.io/lesson/taofficehour4-jan2026-p735-l1942)
- [Day 2 Lab: Tracing LLM reasoning with LangChain + LangSmith](https://www.dataexpert.io/lesson/ml-ops-day2-lab-july25)
- [Understanding Capstone Requirements](https://www.dataexpert.io/lesson/understanding-capstone-requirements-p735-l655): Kickoff
- [TA Office Hour 5](https://www.dataexpert.io/lesson/taofficehour5-fea37)
- [Analytical Patterns (Day 2 Lecture)](https://www.dataexpert.io/lesson/analytical-patterns-day-2-lecture-v4): Week 5: Analytical Patterns & Analysis in Iceberg
- [Advanced dbt Day 2 Lab](https://www.dataexpert.io/lesson/advanced-dbt-day-2-lab-jan2025)
- [Tech Talk - 2](https://www.dataexpert.io/lesson/tech-talk2-oct2025-p737-l1550): Tech Talks
- [Data Quality Patterns: MIDAS Process from Airbnb Day 1 Lecture](https://www.dataexpert.io/lesson/data-quality-patterns-day-1-lecture-yt-p736-l698)
- [Advanced pipelines: Blue-green and WAP with Airflow Lab](https://www.dataexpert.io/lesson/advanced-pipelines-blue-green-and-wap-with-airflow-lab): Advanced dbt
- [Data Pipeline Maintenance: Strategies for Maintenance and Dock Building Day 2 Lecture](https://www.dataexpert.io/lesson/data-pipeline-maintenance-day-2-lecture-yt-p736-l688)
- [Fact Data Modeling Lecture](https://www.dataexpert.io/lesson/fact-data-modeling-lecture-p735-l578): Bonus
- [Data Impact Communication & Visualization - Insights and Best Practices (Day 2 Lecture) ](https://www.dataexpert.io/lesson/visual-impact-day-2-lecture-v3): Week 6: Data Impact Communication & Visualization with Tableau
- [Apache Iceberg Lecture Day3](https://www.dataexpert.io/lesson/apacheiceberglectureday3-6fb59)
- [Full Stack Bootcamp Orientation](https://www.dataexpert.io/lesson/fullstack-bootcamp-orientation): Fullstack Bootcamp Orientation
- [Local Video 2](https://www.dataexpert.io/lesson/lesson4-7ec44)
- [Applying KPIs and Experimentation - Setting Up and Analyzing Experiments in Statsig (Day 1 Lab) ](https://www.dataexpert.io/lesson/kpi-metrics-day-1-lab-v3): Week 4: KPIs and Experimentation with Statsig
- [End-to-End AI Applications Day2 Lab](https://www.dataexpert.io/lesson/endtoendaiapplicationsday2lab-mar26)
- [Hard Orchestration Lessons Day 2 Lab](https://www.dataexpert.io/lesson/hard-orchestration-lessons-day-2-lab-jan2025)
- [Databricks Boot Camp Kickoff](https://www.dataexpert.io/lesson/databricksbootcampkickoff-feb2026)
- [Apache Spark Memory Turning, Partitioning Day 2 Lab](https://www.dataexpert.io/lesson/apache-spark-memory-turning-partitioning-day-2-lab-may2025)
- [Q&A with Zach Week 1](https://www.dataexpert.io/lesson/qa-with-zach-week1-oct2025)
- [Wednesday SQL Quiz](https://www.dataexpert.io/lesson/window-functions-wednesday-quiz)
- [Jason Reid (cofounder of Tabular)](https://www.dataexpert.io/lesson/jason-reid-cofounder-of-tabular)
- [Apache Spark programming with Databricks Day 2 Lab](https://www.dataexpert.io/lesson/apache-spark-programming-with-databricks-day-2-lab-may2025-p736-l1160): Week 4: Structured Streaming with Spark & Kafka
- [Li Yin - Founder at Adal (2026-03-13)](https://www.dataexpert.io/lesson/techtalks1-mar26-p737-l2114): Tech Talks
- [Analytical Patterns (Day 2 Lab)](https://www.dataexpert.io/lesson/analytical-patterns-day-2-lab-v4): Week 5: Analytical Patterns & Analysis in Iceberg
- [Friday Quiz](https://www.dataexpert.io/lesson/fridayquiz-53b9c)
- [TA Office Hour 3 (2025-06-11)](https://www.dataexpert.io/lesson/ta-office-hour-3-may2025-p736-l1144)
- [dbt basics Day2 Lab](https://www.dataexpert.io/lesson/dbtbasicsday2lab-c7486)
- [AI Engineering Bootcamp Kick off](https://www.dataexpert.io/lesson/aiengineeringbootcampkickoff-mar26)
- [Day 1 Lecture: RAG Fundamentals and types of RAG](https://www.dataexpert.io/lesson/understanding-rag-lecture-day1-july2025-p737-l1174): Week 1: Prompt Engineering & Basic RAG
- [Chat with Zach](https://www.dataexpert.io/lesson/week-3-zach-qa-v4)
- [dbt day 1 lecture](https://www.dataexpert.io/lesson/dbt-day-1-lecture): DBT
- [Month with the Highest Total Births](https://www.dataexpert.io/question/highest-birth-month): easy SQL question
- [Find Viewers with Multiple Article Views in a Day](https://www.dataexpert.io/question/find-multiple-article-viewers): easy SQL question
- [Find Product Prices](https://www.dataexpert.io/question/find-product-prices): medium SQL question
- [Comparing State Fatal Collisions to the National Average](https://www.dataexpert.io/question/state-fatal-collisions): medium SQL question
- [Calculating Median Searches per User](https://www.dataexpert.io/question/calculate-median-searches): hard SQL question
- [Who are the top 10 authors by number of reviews?](https://www.dataexpert.io/question/top-10-authors-by-reviews): medium SQL question
- [Finding Highest Grade and Corresponding Course per Student](https://www.dataexpert.io/question/highest-grade-corresponding-course): medium SQL question
- [Determining Optimal Packaging for Christmas Gifts](https://www.dataexpert.io/question/optimal-gift-packaging): hard SQL question
- [Total Number of Births Per Year](https://www.dataexpert.io/question/total-births-per-year): easy SQL question
- [Countries and Their Preferences for Beer, Spirit, and Wine](https://www.dataexpert.io/question/countries-drink-preferences): hard SQL question
- [Identifying students with the best grade](https://www.dataexpert.io/question/option3-students-best-mark): medium SQL question
- [Most Frequently Purchased Sub-Category in Each Region](https://www.dataexpert.io/question/subcat-per-region): hard SQL question
- [Identifying Active Businesses Based on Event Occurrences](https://www.dataexpert.io/question/active-businesses-identification): medium SQL question
- [Which states have high risk of fatal collisions involving Alcohol](https://www.dataexpert.io/question/high-risk-state-analysis): medium SQL question
- [Calculate 3-Day Rolling Average of Posts per User](https://www.dataexpert.io/question/calculate-3-day-rolling-average): medium SQL question
- [Top 2 Customers with Highest Sales Every Month](https://www.dataexpert.io/question/top-customers-monthly-sales): medium SQL question
- [Cars with Above Average Engine Size](https://www.dataexpert.io/question/cars-above-average-engine-size): easy SQL question
- [Total Server Fleet Uptime in Full Days](https://www.dataexpert.io/question/server-fleet-uptime-full-days): hard SQL question
- [Optimizing Stock of Prime and Non-Prime Items in a Warehouse](https://www.dataexpert.io/question/warehouse-item-optimization): hard SQL question
- [Check Test Answers](https://www.dataexpert.io/question/check-test-answers): easy SQL question
- [Average Number of Births by Day of the Week](https://www.dataexpert.io/question/average-births-per-day-of-week): easy SQL question
- [Check Second Sale Brand Preference Match](https://www.dataexpert.io/question/second-item-preferred-brand-match): hard SQL question
- [Identifying Empty Departments](https://www.dataexpert.io/question/empty-departments-list): easy SQL question
- [Filtering Students in Active Clubs](https://www.dataexpert.io/question/active-club-members): easy SQL question
- [Find Top 3 Commonly Bought Product Pairs](https://www.dataexpert.io/question/commonly-bought-product-pairs): hard SQL question
- [Count Unique Conversation Threads](https://www.dataexpert.io/question/unique-conversation-threads): hard SQL question
- [Most Popular Fuel System for Each Fuel Type](https://www.dataexpert.io/question/popular-fuel-system-by-fuel-type): medium SQL question
- [Identifying the Bank Robber](https://www.dataexpert.io/question/bank-robber-identification): easy SQL question
- [Identifying Multi-Component Bugs and Their Impact](https://www.dataexpert.io/question/multi-component-bugs-impact): hard SQL question
- [Calculate Average Lead Time for Each Shipping Option](https://www.dataexpert.io/question/average-lead-time-shipping-option): medium SQL question
- [Salary Range Difference](https://www.dataexpert.io/question/salary-range-difference): medium SQL question
- [Finding Actors by Favorite Movie Genre](https://www.dataexpert.io/question/actors-by-favorite-genre): medium SQL question
- [Determining the Order of Succession](https://www.dataexpert.io/question/order-of-succession): easy SQL question
- [Top Reviewed Customers per Product](https://www.dataexpert.io/question/top-reviewed-customers-per-product): easy SQL question
- [Identify Department for Reduction](https://www.dataexpert.io/question/department-reduction-criteria): hard SQL question
- [Analyze Engine Efficiency by Fuel Type](https://www.dataexpert.io/question/analyze-engine-efficiency): medium SQL question
- [Determining the Soccer Series Winner](https://www.dataexpert.io/question/soccer-series-winner): hard SQL question
- [Find US Customers Who Rented and Streamed Videos in Early February](https://www.dataexpert.io/question/us-customers-rented-streamed-early-feb): easy SQL question
- [Who are the top 10 NBA players by consecutive 20+ point seasons?](https://www.dataexpert.io/question/consecutive-20-point-seasons): hard SQL question
- [Analyze Yearly Profit Performance](https://www.dataexpert.io/question/yearly-profit-performance): easy SQL question
- [Filtering Dance Contest Scores](https://www.dataexpert.io/question/dance-contest-score-filtering): medium SQL question
- [Summarizing Leisure Activity Resorts by Country](https://www.dataexpert.io/question/leisure-activity-resorts-by-country): hard SQL question
- [Identify Products Sold Exclusively in January 2024](https://www.dataexpert.io/question/products-exclusive-jan-sales): medium SQL question
- [Select Rows With Maximum Revenue](https://www.dataexpert.io/question/select-max-revenue-rows): easy SQL question
- [Top N per group with ties](https://www.dataexpert.io/question/top-n-per-group-with-ties): medium SQL question
- [Customer Orders](https://www.dataexpert.io/question/customer-orders): medium SQL question
- [Detecting Gaps in a Sequence](https://www.dataexpert.io/question/detecting-gaps-in-a-sequence): medium SQL question
- [Question 1](https://www.dataexpert.io/question/question-1): easy SQL question
- [Find Overlapping Date Ranges](https://www.dataexpert.io/question/find-overlapping-date-ranges): hard SQL question
- [SQL Question 2](https://www.dataexpert.io/question/sql-question): hard SQL question
- [Hierarchical JSON Aggregation with Conditional Flattening](https://www.dataexpert.io/question/hierarchical-json-aggregation-with-conditional-flattening): medium SQL question
- [Latest price per product](https://www.dataexpert.io/question/latest-price-per-product): medium SQL question
- [Orders with missing customers](https://www.dataexpert.io/question/orders-with-missing-customers): medium SQL question
- [Running total amount](https://www.dataexpert.io/question/running-total-amount): easy SQL question
- [Sessionization and gap-based grouping](https://www.dataexpert.io/question/sessionization-and-gap-based-grouping): hard SQL question
- [Calculate Monthly Average Product Rating](https://www.dataexpert.io/question/monthly-average-product-rating): medium SQL question
- [Year-on-Year Growth Rate Calculation](https://www.dataexpert.io/question/year-on-year-growth-rate): hard SQL question
- [Get nba player from bootcamp.nba_player_seasons table with age 25 and name is Aaron McKie](https://www.dataexpert.io/question/get-nba-player-from-bootcamp-nba-player-seasons-table-with-age-and-name-is-aaron-mckie): hard SQL question
- [Select all nba players with college as Connecticut and ordered by player_name desc](https://www.dataexpert.io/question/select-all-nba-players-with-college-as-connecticut-and-ordered-by-player-name-desc): hard SQL question
- [Testing sql question](https://www.dataexpert.io/question/testing-sql-question): hard SQL question
- [Summarizing Foreign Competitors by Country with Total Summary](https://www.dataexpert.io/question/foreign-competitors-summary): medium SQL question
- [Calculating Available Seats on Flights](https://www.dataexpert.io/question/available-seats-per-flight): medium SQL question
- [Customers with More Than 20 Orders](https://www.dataexpert.io/question/loyal-customers): easy SQL question
- [Transform workers_info Table to Exclude NULL Values](https://www.dataexpert.io/question/exclude-null-values-workers-info): medium SQL question
- [Data Engineer Interview — SQL](https://www.dataexpert.io/question/data-engineer-sql): medium SQL question
- [Analytics Engineer Interview — SQL](https://www.dataexpert.io/question/analytics-engineer-sql): medium SQL question
- [AI Engineer Interview — SQL](https://www.dataexpert.io/question/ai-engineer-sql): medium SQL question