DP-800: SQL AI Developer Associate

Associate Data Beta
Beta (since 2026-03) — typically offered at 80% discount.
Browse certifications
28 modules
·
~6h 5m study time
·
0 completed

Interactive Study Guide

Each module covers one exam topic with plain-English explanations, real-world scenarios, and built-in practice. Everything you need to understand and retain the material — no tab-switching required.

📖 ELI5 explanations
🔄 Flashcards
✅ Knowledge checks
📊 Compare tables
💡 Exam tips
📍 Progress tracking
Domain 1: Design and Develop Database Solutions
Advanced T-SQL: CTEs, Windows, and Correlated Queries 15m
Loading module…
AI-Assisted SQL with GitHub Copilot 12m
Loading module…
Constraints: Protecting Your Data 12m
Loading module…
Fuzzy String Matching: Finding Similar Text 10m
Loading module…
JSON in SQL: Store, Query, and Index 13m
Loading module…
MCP: Connecting AI to Your Database 11m
Loading module…
Programmability: Views, Functions, Procedures, and Triggers 14m
Loading module…
Pattern Power: Regular Expressions in T-SQL 13m
Loading module…
Specialised Tables and Graph Queries 15m
Loading module…
Table Design: Columns, Types, and Indexes 14m
Loading module…
Domain 2: Secure, Optimize, and Deploy Database Solutions
Azure Integration and Monitoring 13m
Loading module…
Change Detection: CES, CDC, and Change Tracking 14m
Loading module…
CI/CD Pipelines for SQL Databases 14m
Loading module…
Data API Builder: REST and GraphQL from SQL 15m
Loading module…
Encryption: Always Encrypted and Column-Level 13m
Loading module…
Transaction Isolation and Concurrency 13m
Loading module…
Dynamic Data Masking and Row-Level Security 12m
Loading module…
Permissions, Auditing, and Passwordless Access 12m
Loading module…
Query Performance: Plans, DMVs, and Query Store 14m
Loading module…
Securing AI and API Endpoints 13m
Loading module…
SQL Database Projects: Build and Validate 13m
Loading module…
Domain 3: Implement AI Capabilities in Database Solutions
Embeddings: Design, Chunk, and Generate 14m
Loading module…
External AI Models: Choose, Create, Manage 12m
Loading module…
Hybrid Search and Reciprocal Rank Fusion 12m
Loading module…
RAG with SQL: Prompt, Process, Respond 14m
Loading module…
Choose Your Search Strategy 12m
Loading module…
Vector Data: Types, Indexes, and Storage 13m
Loading module…
Vector Search: Distance, ANN, and ENN 13m
Loading module…

Exam Resources

Official learning paths, exam details, skills measured, and community resources to supplement your study.

This exam is currently in beta since 2026-03. Beta exams are typically offered at 80% discount.

Exam Quick Facts

DetailValue
Exam CodeDP-800
TitleSQL AI Developer Associate
LevelAssociate
Pass Score700 / 1000
Duration100 minutes
Questions~40-60
Cost$165 USD (varies by region)
SchedulingPearson VUE

Study Resources

ResourceLink
Official Exam PageMicrosoft Learn — DP-800
Exam SandboxTry the exam interface

Who is this exam for?

This Microsoft Data certification covers data concepts and Azure data services. It tests your ability to work with relational and non-relational databases, analytics workloads, and data platforms on Azure. This is an associate-level exam that expects hands-on experience. You should have practical knowledge of the technologies covered.


Skills Measured

Skills measured have not been published yet for this beta exam. Check the official exam page for updates.


What to Study Next

Based on this exam, here are related certifications to consider:


20 Free Questions Practice Exam $9 →