Build AI-powered solutions using SQL Server 2025

  • Module
  • 8 Units
Beginner
Developer
Data Engineer
Solution Architect
SQL Server

Learn how to build intelligent AI-powered applications using SQL Server 2025's native vector support, embedding generation, semantic search, and integration with Azure OpenAI and AI frameworks.

Learning objectives

In this module, you'll:

  • Understand the AI-ready evolution of SQL Server 2025, including vector data types, embeddings, and Retrieval Augmented Generation (RAG).
  • Implement vector data types and perform semantic search using VECTOR_DISTANCE and VECTOR_SEARCH functions.
  • Integrate AI models securely with SQL Server using CREATE EXTERNAL MODEL, managed identities, and Azure OpenAI.
  • Build RAG applications using T-SQL, LangChain, and Semantic Kernel frameworks.
  • Develop intelligent applications with Change Event Streaming, conversational AI, and Microsoft Fabric integration.
  • Use Microsoft Copilot in SQL Server Management Studio for AI-assisted database development.

Prerequisites

  • Experience with SQL Server database development and T-SQL programming.
  • Basic understanding of AI concepts such as embeddings and language models.
  • Familiarity with Azure services (Azure OpenAI, Microsoft Foundry) is helpful but not required.
  • Understanding of REST APIs and JSON data formats.
Start