The Microsoft DP-800: Developing AI-Enabled Database Solutions exam validates your ability to design, develop, secure, optimize, and deploy modern SQL database solutions integrated with Artificial Intelligence (AI).

Passing the DP-800 exam earns you the Microsoft Certified: SQL AI Developer Associate certification, demonstrating your expertise in SQL Server, Azure SQL, Microsoft Fabric SQL databases, AI-assisted development, and AI-enabled database applications.

DP-800 is a Microsoft associate-level certification exam designed for SQL developers, database professionals, and application developers who want to build intelligent database solutions using Microsoft SQL technologies.

The certification focuses on advanced T-SQL programming, database design, security, performance optimization, GitHub Copilot, AI models, vector search, and Retrieval-Augmented Generation (RAG).

DP-800 helps professionals demonstrate their ability to combine traditional SQL development with modern AI-powered database technologies.

1. Design and Develop Database Solutions (35–40%)

• Design tables, indexes, constraints, and specialized database objects.
• Develop stored procedures, functions, views, triggers, and advanced T-SQL queries.
• Implement SQL solutions using GitHub Copilot and AI-assisted development tools.

2. Secure, Optimize, and Deploy Database Solutions (35–40%)

• Implement database security, encryption, permissions, and Row-Level Security (RLS).
• Optimize SQL query performance using execution plans, Query Store, and indexing.
• Implement CI/CD using SQL Database Projects, GitHub, and deployment pipelines.
• Integrate database applications with Azure services, REST APIs, and GraphQL.

3. Implement AI Capabilities in Database Solutions (25–30%)

• Design and implement AI models and vector embeddings.
• Implement semantic search, vector search, and hybrid search.
• Develop Retrieval-Augmented Generation (RAG) solutions using SQL databases.
• Integrate language models with database applications.

• SQL Developers looking to upgrade their skills with AI and Generative AI technologies.
• T-SQL Developers working with advanced SQL programming and database applications.
• Azure SQL Developers building cloud-based database solutions.
• Database Engineers interested in AI-powered database development.
• Application Developers integrating AI models with SQL databases.
• Data Professionals planning to transition into SQL and AI development roles.

• SQL Database Development: Advanced T-SQL, stored procedures, functions, triggers, indexing, and database objects.
• SQL Server and Azure SQL: Database design and development across SQL Server, Azure SQL, and Microsoft Fabric.
• AI-Assisted SQL Development: GitHub Copilot, Copilot in Fabric, and AI-assisted SQL development.
• Database Security: Encryption, access control, Row-Level Security, auditing, and secure connections.
• Performance Optimization: Query Store, execution plans, indexing, blocking, deadlocks, and query tuning.
• Database DevOps: SQL Database Projects, GitHub integration, source control, and CI/CD pipelines.
• Azure Integration: REST APIs, GraphQL, Data API builder, Azure Functions, and Logic Apps.
• AI Models and Vector Search: Embeddings, semantic search, vector similarity, and hybrid search.
• Retrieval-Augmented Generation (RAG): Integrating SQL database information with large language models to create intelligent applications.

• Microsoft-Recognized Certification: Validate your expertise in developing AI-enabled SQL database solutions.
• AI and SQL Expertise: Strengthen your skills by combining traditional SQL development with modern Artificial Intelligence technologies.
• Career Opportunities: Build relevant skills for SQL Developer, Azure SQL Developer, Database Engineer, and AI-enabled Application Developer roles.
• Professional Credibility: Enhance your resume with an industry-recognized Microsoft certification.
• Future-Ready Skills: Gain practical knowledge of vector databases, Generative AI, RAG, and AI-assisted development.
• Career Advancement: Support your transition from traditional SQL development to AI-enabled database engineering.
• Competitive Advantage: Demonstrate modern database development skills relevant to AI-driven enterprise applications.

A. Query Store
B. Vector Data Type
C. SQL Server Agent
D. Temporal Tables

A. SQL Server Profiler
B. Azure Monitor
C. GitHub Copilot
D. SQL Server Agent

A. Change Data Capture (CDC)
B. Retrieval-Augmented Generation (RAG)
C. Database Replication
D. Transaction Log Backup

A. Query Store
B. SQL Server Browser
C. Database Mail
D. SQL Server Agent

A. Transparent Data Encryption
B. Dynamic Data Masking
C. Row-Level Security
D. Always Encrypted

A. SQL Database Projects
B. SQL Server Profiler
C. Database Mail
D. SQL Server Agent

A. Full Database Backup
B. Hybrid Search
C. Table Partitioning
D. Transaction Replication