DP-800: Developing AI-Enabled Database Solutions

About this course

About the Exam: DP-800 – Developing AI-Enabled Database SolutionsThe DP-800 exam measures your ability to design, build, and implement AI-enabled database solutions using SQL and Azure technologies. This exam focuses on key areas such as database design, performance optimization, AI integration, intelligent search, and deployment practices, all within real-world data scenarios.The certification covers how developers combine traditional SQL capabilities with modern AI features such as embeddings, vector search, and retrieval-augmented generation (RAG). Candidates are expected to understand how structured data and AI models work together to support intelligent applications, automation, and advanced data retrieval.The exam includes topics related to designing and developing database solutions, where candidates write advanced T-SQL, implement security controls, and optimize performance using tools such as execution plans, Query Store, and dynamic management views. This involves building solutions that are scalable, efficient, and aligned with application requirements.Another major area focuses on integrating SQL solutions with Azure services and external APIs. Candidates should understand how to expose data through REST and GraphQL endpoints, configure Data API builder, and connect to external services using stored procedures such as sp_invoke_external_rest_endpoint. These integrations enable modern application architectures and real-time data access.The exam also evaluates how candidates implement AI capabilities within database solutions. This includes creating embeddings, designing chunking strategies, implementing vector and hybrid search, and applying ranking techniques such as reciprocal rank fusion. Candidates must understand how to evaluate search performance and choose appropriate approaches for different scenarios.A key focus area is retrieval-augmented g

Course objectives

• to understand how to combine SQL and AI technologies
• to learn performance optimization techniques
• to develop skills for integrating AI capabilities into databases