DP-800: Develop AI-enabled Database Solutions
MOC: DP-800T00
MS Subscription
Interface Gold
This intensive 3-day course provides students with the knowledge and skills to design and develop AI enabled database solutions across Microsoft SQL platforms, including SQL Server, Azure SQL, and SQL databases in Microsoft Fabric. It is intended for professionals who build modern data solutions that integrate structured and semi structured data and incorporate AI features into scalable enterprise applications. It will also be valuable for individuals who develop applications that rely on SQL based data services enhanced with vector search, embeddings, and other AI driven capabilities.
What you will learn
- With a focus on practical applications, the course covers:
- Students learn advanced T-SQL techniques
- Modern data patterns for working with structured and semi-structured data
- How to integrate AI capabilities, such as embeddings
- How to integrate AI capabilities, such as vectors
- How to integrate AI capabilities, such as semantic search
- Retrieval-augmented generation (RAG), directly within SQL based applications
- Covers best practices for performance optimization, security, and enterprise deployment
What products and services will you use and learn about in this course
- Azure SQL Database
- Microsoft SQL Server
- Microsoft Fabric SQL
- Azure OpenAI Service
- Vector Search/Index
- Retrieval-Augmented Generation (RAG
- Embeddings Generation
- GitHub Copilot & Microsoft Copilot in Fabric
- SQL Database Projects
- Data API builder (DAB
- SQL Server Management Studio (SSMS)
- Advanced T-SQL
- Data Security
- Performance Optimization
- Azure Monitor
Prepare for the Microsoft Certified: Azure Virtual Desktop Specialty Certification
This course is designed to help students confidently prepare for the DP-800: Microsoft Certified: SQL AI Developer Associate (beta) exam. The study areas for the certification exam related to this course are based on the Job Task Analysis (JTA) that was conducted in December 2025.
Note: To pass the certification test, studying outside the course may be required to ensure all the concepts are fully understood.
- $2,095
- 3 Days, Labs, Live Q&A
- Replay™ Class Recordings Included
- Included in “all-you-can-eat” Microsoft Live Training Subscription
Course Outline
Learning Path: Design and develop database solutions
Build database solutions across SQL Server, Azure SQL, and Microsoft Fabric. You learn to create well-structured database objects and indexes. You encapsulate business logic with stored procedures and functions. You write advanced T-SQL using techniques such as Common Table Expressions (CTE), window functions, and error handling. You also accelerate your development workflow with AI-assisted tools including GitHub Copilot and Fabric Copilot.
Lessons:
- Design and implement database objects with SQL
- Implement programmability objects with SQL
- Write advanced T-SQL code
- Implement SQL solutions by using AI-assisted tools
Exercises:
- Create and maintain database objects
- Implement programmability objects in SQL Server
- Work with JSON functions
- Configure AI-assisted tools for database development
Learning Path: Secure, optimize, and deploy database solutions
Take your database solutions from development to production. You learn to protect sensitive data with encryption, masking, and row-level security. You tune query performance using execution plans, Query Store, and dynamic management views. You automate deployments with CI/CD pipelines using SQL Database Projects. Finally, you expose your databases through REST and GraphQL APIs with Data API Builder.
Lessons:
- Implement data security and compliance with SQL
- Optimize database performance
- Implement CI/CD by using SQL Database Projects
- Integrate SQL solutions with Azure services
Exercises:
- Implement security features
- Optimize query performance
- Implement CI/CD by using SQL Database Projects
- Configure Data API Builder for a product catalog
Learning Path: Implement AI capabilities in database solutions
This learning path explores how to implement AI capabilities directly in Azure SQL Database. You learn to design intelligent search using full-text and vector search, integrate AI models and embeddings, and build Retrieval Augmented Generation (RAG) solutions entirely in T-SQL.
Lessons:
- Design and implement models and embeddings with SQL
- Design and implement intelligent search with SQL
- Design and implement RAG with SQL
Exercises:
- Generate and update embeddings in Azure SQL Database
- Implement intelligent search with full-text, vector, and hybrid queries
- Implement a RAG solution
Audience
The audience for this course is data professionals who want to learn about designing and developing AI-enabled database solutions across Microsoft’s SQL platforms, including SQL Server, Azure SQL, and SQL databases in Microsoft Fabric. This role develops database solutions that include both structured and semi-structured data and integrates AI features into modern and highly scalable enterprise applications.
Prerequisites
Before attending this course, students must have:
- Experience writing T-SQL code and developing databases in Microsoft SQL platforms.
- Plus, you need to be familiar with continuous integration and continuous deployment (CI/CD) practices in GitHub, AI-assisted development tools, and AI concepts, such as embeddings, vectors, and models