Design and implement models and embeddings with SQL
Intermediate
Developer
Data Engineer
Azure
Azure SQL Database
Integrate AI models with Azure SQL Database using external models and built-in AI functions. Design effective embedding strategies and implement maintenance patterns to keep embeddings aligned with source data.
Learning objectives
By the end of this module, you'll be able to:
- Evaluate AI models for SQL database workloads based on capabilities and performance requirements.
- Create and manage external models to reference AI endpoints from Transact-SQL.
- Design embeddings with appropriate chunking strategies.
- Generate and store embeddings using built-in SQL AI functions.
- Choose maintenance approaches to keep embeddings aligned with source data.
Prerequisites
- Basic understanding of SQL and Transact-SQL.
- Familiarity with Azure SQL Database or Fabric SQL database.
- Azure subscription with access to Azure OpenAI.
Get started with Azure
Choose the Azure account that's right for you. Pay as you go or try Azure free for up to 30 days. Sign up.