Explore SQL Server 2025 capabilities

Overview

Learn about SQL Server 2025's new capabilities including AI integration, analytics improvements, developer features, and performance enhancements.By the end of this module, you're able to:

Implement AI capabilities and vector search in SQL Server 2025. Configure Microsoft Fabric mirroring and analytics features.

Use new developer tools including JSON, REST APIs, and RegEx. Optimize performance with intelligent query processing.

Apply security enhancements and scalability features. Build AI-powered solutions using SQL Server 2025In 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. This module helps users understand the hybrid data platform capabilities of SQL Server 2025.In this module, you'll be able to:

Discover best practices for disaster recovery and extended capabilities Describe how Azure Arc-enabled SQL Server works for centralized management Understand how to implement near real-time analytics with mirroring in Microsoft Fabric Explain enhanced security features including Microsoft Entra authentication and managed identity support 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.

Explore the new T-SQL enhancements in SQL Server 2025, including AI integration, pattern matching, JSON aggregation, and more.This module covers:

Vector and AI integration Pattern matching and text extraction JSON and string aggregation Encoding and similarity functions Date and numeric enhancements

Syllabus

• Get started with SQL Server 2025IntroductionDeployment options, licensing, and feature differencesExplore AI-powered capabilities for modern data solutionsUnlock advanced analytics capabilities for your organizationElevate developer productivity with tools and integrated servicesMaximize performance to drive speed and efficiencySecure and scale modern applicationsKnowledge checkSummary
• Build AI-powered solutions using SQL Server 2025IntroductionUse Copilot in SQL Server Management StudioImplement vector data types and vector searchIntegrate AI models and external services securelyBuild retrieval augmented generation applicationsDevelop intelligent applications with AI frameworksModule assessmentSummary
• Understand hybrid data platform on SQL Server 2025IntroductionEnsure business continuity with Azure SQL Managed InstanceSimplify management with Azure Arc-enabled SQL ServerUnderstand mirroring in Microsoft FabricSecure with Microsoft Entra authenticationKnowledge checkSummary
• Introduction to SQL Server 2025 data virtualizationIntroductionIntroduction to PolyBasePolyBase credentials and data sourcesExercise - Use PolyBase to query a Parquet fileExercise - Create an external table from a database in Azure SQL DatabaseCREATE EXTERNAL TABLE AS SELECT (CETAS)Exercise - CREATE EXTERNAL TABLE AS SELECTModule assessmentSummary
• Transform development workflows with T-SQL in SQL Server 2025IntroductionAI and vector integrationPattern matching and text extractionJSON and string aggregationEncoding and similarity functionsDate and numeric enhancementsModule assessmentSummary

---

Subjects

Artificial Intelligence