- 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.
AI, Data Science & Business Certificates from Google, IBM & Microsoft
Learn Excel & Financial Modeling the Way Finance Teams Actually Use Them
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Syllabus
- Build AI-powered solutions using SQL Server 2025
- Introduction
- Use GitHub 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