Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Explore SQL Server 2025 capabilities

Microsoft via Microsoft Learn

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
  • 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.

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

Reviews

Start your review of Explore SQL Server 2025 capabilities

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.