Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Run Machine Learning & LLMs Inside Your Database with Exasol
New
Rating: 5.0 out of 5(1 rating)
138 students

Run Machine Learning & LLMs Inside Your Database with Exasol

Build fast pipelines, run Python functions, ML models and LLMs directly inside Exasol, the scalable analytics engine.
New
Created byAndreas Kretz
Last updated 7/2026
English
English

What you'll learn

  • Set up & manage an Exasol MPP cluster on your own AWS infrastructure using Exasol Personal, completely free & with no feature limits.
  • Design tables with the right distribution and partition keys & understand how data layout decisions impact query performance across a multi-node cluster.
  • Write Python User-Defined Functions that run inside Exasol, call external APIs, & return results directly within a SQL query.
  • Train a scikit-learn model in the Exasol AI Lab, upload it to BucketFS, & run predictions on new data straight from SQL without any external Python environment.
  • Load a Hugging Face zero-shot classification model into Exasol & classify text documents from SQL, with no data leaving your database & no external API calls.
  • Build a conversational BI setup using an MCP server & a local LLM that translates plain English questions into SQL & returns answers on your own infrastructure.

Course content

5 sections • 12 lectures • 1h 7m total length

  • Introduction2:29

    Learn what this course covers and what you will build. You will get an overview of MPP databases, Exasol Personal, UDFs, the AI Lab, and the conversational BI setup with MCP.

Requirements

  • AWS account for the hands-on parts
  • Basic database, SQL, and Python knowledge

Description

Most data teams treat the database as a place to store and query data. This course shows you a different way of thinking about it.

Exasol is a massively parallel processing database that keeps your data compressed in memory and spreads the workload across nodes. That alone makes it significantly faster than traditional data warehouses. But what makes it truly powerful is what you can run inside it: Python code, machine learning models, and even language models, all called directly from SQL.

In this course you will set up a fully functional Exasol cluster on your own AWS infrastructure using Exasol Personal, which is completely free and has no feature or data limits. You will load real datasets, design tables with the right distribution and partition keys, and see with real benchmark numbers what proper data layout does to query performance.

From there you will write Python UDFs that call live APIs and return results inside a single SQL query. Then you will move into the AI Lab, where you will train a scikit-learn classifier, upload it to BucketFS, and run predictions straight from SQL. You will also load a Hugging Face zero-shot classification model into the database and classify text documents without sending a single row to an external service.

By the end of this course you will know how to turn Exasol into a full in-database AI and ML platform that runs entirely on your own infrastructure.

Who this course is for:

  • This course is for software engineers, data scientists, and data engineers who want to go beyond standard SQL and run real AI and ML workloads directly inside a high-performance database.

Report abuse