Design and implement intelligent search with SQL

  • Module
  • 9 Units
Intermediate
Developer
Data Engineer
Azure
Azure SQL Database
SQL Server

Implement intelligent search capabilities in SQL Server and Azure SQL by combining traditional full-text search with semantic vector search. Establish a mental model for different search approaches, prepare SQL for vector-based search, and implement vector, hybrid, and ranking-based search patterns with performance considerations.

Learning objectives

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

  • Choose between full-text, semantic vector, and hybrid search approaches.
  • Implement full-text search for keyword-based queries.
  • Design for vector data including vector data type, indexes, and size.
  • Evaluate vector index types and metrics, and choose between ANN and ENN.
  • Implement vector search using vector-related functions.
  • Implement hybrid search and Reciprocal Rank Fusion (RRF).
  • Evaluate performance of vector and hybrid search.

Prerequisites

  • Basic understanding of SQL and Transact-SQL.
  • Familiarity with Azure SQL Database or SQL Server.
  • Understanding of embeddings and vector concepts.

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.

Start