- Build AI-powered solutions using SQL Server 2025
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.
- Learn about data virtualization, how to use Polybase to access and query external data, and enhanced Polybase features in SQL Server 2025.
After you complete this module you:
- Understand the benefits and principles of data virtualization.
- Know what PolyBase is and how to use its capabilities.
- Are familiar with object storage solutions and SQL Server 2025 support for S3-compatible object storage.
- Know how to install and configure PolyBase on SQL Server 2025.
- Know how to access and query external data by using PolyBase in SQL Server 2025.
Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Syllabus
- Build AI-powered solutions using SQL Server 2025
- Introduction
- Use Copilot in SQL Server Management Studio
- Implement vector data types and vector search
- Integrate AI models and external services securely
- Build retrieval augmented generation applications
- Develop intelligent applications with AI frameworks
- Module assessment
- Summary
- Introduction to SQL Server 2025 data virtualization
- Introduction
- Introduction to PolyBase
- PolyBase credentials and data sources
- Exercise - Use PolyBase to query a Parquet file
- Exercise - Create an external table from a database in Azure SQL Database
- CREATE EXTERNAL TABLE AS SELECT (CETAS)
- Exercise - CREATE EXTERNAL TABLE AS SELECT
- Summary