Design and implement RAG with SQL

Module
8 Units

Intermediate

Database Administrator

Developer

Data Engineer

Azure SQL Database

SQL Server

This module teaches you how to implement Retrieval Augmented Generation (RAG) using Azure SQL Database. You learn to identify appropriate RAG scenarios, prepare SQL results as LLM context, construct augmented prompts, and process model responses.

Learning objectives

By the end of this module, you're able to:

Identify use cases for RAG in SQL-based applications
Convert structured database data to JSON for LLM processing
Create prompts that combine instructions with retrieved database context
Send retrieval results to an LLM and extract responses

Prerequisites

Experience with SQL Server or Azure SQL Database
Understanding of basic T-SQL queries
Familiarity with JSON data format
Completion of the "Design and implement intelligent search with SQL" module

Introduction min
Identify RAG use cases and architecture min
Prepare retrieval context for augmentation min
Augment prompts with database context min
Generate and process RAG responses min
Exercise: Implement a RAG solution min
Knowledge check min
Summary min

Start