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
- 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 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.
- 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
