🔒 Guided

Pre-launch preview. Authorised access only.

Incorrect code

Guided by A Guide to Cloud
Explore AB-900 AI-901
DP-800

SQL AI Developer
Associate (Beta)

The brand-new certification for SQL developers integrating AI into database solutions. Vector search, embeddings, RAG in T-SQL, GitHub Copilot, MCP, Data API Builder — the future of SQL, explained clearly.

📖

Study Guide

28 interactive modules

First 3 Domain 1 modules (Table Design, Constraints, Specialised Tables) + AI-Assisted SQL with Copilot + 10 practice questions. No account needed.

Start Free →
✍️

Practice Exam

200 exam-style questions

Study mode with explanations + timed exam simulation. 10 free questions.

Try Free Questions →

28

Modules

200

Questions

3

Domains

Free

Domain 1 included

📝 Sample Question

A developer needs to find products semantically similar to a user query. The database has 5 million products with 1536-dimension embeddings. Sub-100ms latency is required. Which approach should they use?

A. VECTOR_DISTANCE with ORDER BY (exact nearest neighbour scan)
B. VECTOR_SEARCH with a DiskANN index (approximate nearest neighbour) ✓
C. Full-text search with FREETEXT for natural language matching

📊 What you'll cover

Design and Develop Database Solutions (Free) 10 modules
Secure, Optimize, and Deploy Database Solutions 11 modules
Implement AI Capabilities in Database Solutions 7 modules

What you'll learn

🧠

Vector Search & Embeddings

Store vectors natively in SQL, build DiskANN indexes, and implement ANN/ENN search with VECTOR_DISTANCE and VECTOR_SEARCH.

🤖

RAG in T-SQL

Build retrieval-augmented generation pipelines entirely in SQL — search, prompt, call AI models, and extract responses with sp_invoke_external_rest_endpoint.

🔗

MCP & GitHub Copilot

Connect AI tools to your database with Model Context Protocol. Configure Copilot instruction files for team-wide SQL standards.

🚀

Data API Builder & CI/CD

Expose SQL as REST/GraphQL APIs with DAB. Automate deployments with SQL Database Projects, schema drift detection, and pipeline controls.

Full Curriculum

28 interactive modules across 3 exam domains

1

Design and Develop Database Solutions

10 modules

Free

The foundation — table design, constraints, specialised tables, JSON, programmability objects, advanced T-SQL, regular expressions, fuzzy matching, AI-assisted tools with GitHub Copilot, and MCP connectivity.

  1. 1Table Design: Columns, Types, and Indexes
  2. 2Constraints: Protecting Your Data
  3. 3Specialised Tables and Graph Queries
  4. 4JSON in SQL: Store, Query, and Index
  5. 5Programmability: Views, Functions, Procedures, and Triggers
  6. 6Advanced T-SQL: CTEs, Windows, and Correlated Queries
  7. 7Pattern Power: Regular Expressions in T-SQL
  8. 8Fuzzy String Matching: Finding Similar Text
  9. 9AI-Assisted SQL with GitHub Copilot
  10. 10MCP: Connecting AI to Your Database
Start Free →
2

Secure, Optimize, and Deploy Database Solutions

11 modules

Premium

The professional toolkit — encryption (Always Encrypted), masking, RLS, permissions, passwordless access, transaction isolation, query performance tuning, SQL Database Projects, CI/CD pipelines, Data API Builder, change detection, and Azure monitoring.

  1. 1Encryption: Always Encrypted and Column-Level
  2. 2Dynamic Data Masking and Row-Level Security
  3. 3Permissions, Auditing, and Passwordless Access
  4. 4Transaction Isolation and Concurrency
  5. 5Query Performance: Plans, DMVs, and Query Store
  6. 6SQL Database Projects: Build and Validate
  7. 7CI/CD Pipelines for SQL Databases
  8. 8Data API Builder: REST and GraphQL from SQL
  9. 9Securing AI and API Endpoints
  10. 10Change Detection: CES, CDC, and Change Tracking
  11. 11Azure Integration and Monitoring
Preview Domain
3

Implement AI Capabilities in Database Solutions

7 modules

Premium

The cutting edge — external AI models, embeddings, full-text vs vector vs hybrid search, vector data types and indexes, ANN vs ENN, reciprocal rank fusion, and building RAG pipelines entirely in T-SQL.

  1. 1External AI Models: Choose, Create, Manage
  2. 2Embeddings: Design, Chunk, and Generate
  3. 3Choose Your Search Strategy
  4. 4Vector Data: Types, Indexes, and Storage
  5. 5Vector Search: Distance, ANN, and ENN
  6. 6Hybrid Search and Reciprocal Rank Fusion
  7. 7RAG with SQL: Prompt, Process, Respond
Preview Domain

Practice Exam Lab

200 original questions — two study modes

📖

Study Mode

Learn as you go

  • ✓ See explanation after each question
  • ✓ "Why wrong" for every option
  • ✓ Real-world context & exam tips
  • ✓ Microsoft Learn links
⏱️

Exam Mode

Simulate the real thing

  • ✓ 120 minutes timed session
  • ✓ Randomised question order
  • ✓ Score breakdown by domain
  • ✓ Pass/fail against 700 / 1000
1

Design and Develop Database Solutions

75 questions · Exam weight: 35-40%

10 Free

20

Easy

35

Medium

20

Hard

Every question includes a scenario, detailed explanation, and a link to Microsoft Learn.

Try Free Questions →
2

Secure, Optimize, and Deploy Database Solutions

75 questions · Exam weight: 35-40%

0 Free

18

Easy

38

Medium

19

Hard

Every question includes a scenario, detailed explanation, and a link to Microsoft Learn.

Preview Questions
3

Implement AI Capabilities in Database Solutions

50 questions · Exam weight: 25-30%

0 Free

12

Easy

25

Medium

13

Hard

Every question includes a scenario, detailed explanation, and a link to Microsoft Learn.

Preview Questions

🎁 Free tier: 10 questions. No account needed.

Choose your path

Start free. Upgrade when you're ready.

Practice Exam

$14

one-time purchase

  • ✓ 200 exam-style questions
  • ✓ Study mode + Exam mode
  • ✓ Detailed explanations

Study Guide

$19

one-time purchase

  • ✓ 28 interactive modules
  • ✓ Flashcards & ELI5
  • ✓ Progress tracking
Recommended

Complete Bundle

$29

save $4

  • ✓ Everything in both
  • ★ Best value

🎁 Free tier: First 3 Domain 1 modules (Table Design, Constraints, Specialised Tables) + AI-Assisted SQL with Copilot + 10 practice questions. No account needed. No account needed.

About the DP-800 Exam

Exam code
DP-800
Duration
120 minutes
Passing score
700 / 1000
Question types
MCQ, multi-select, case studies
Cost
$165 USD

Exam Domains & Weights

D1: Design and Develop Database Solutions (35-40%)
D2: Secure, Optimize, and Deploy Database Solutions (35-40%)
D3: Implement AI Capabilities in Database Solutions (25-30%)
View on Microsoft Learn →

Frequently Asked Questions

What is DP-800?
DP-800 is the Microsoft Certified: SQL AI Developer Associate exam — a brand-new beta certification for developers who build AI-enabled database solutions across SQL Server, Azure SQL, and SQL databases in Microsoft Fabric.
Do I need AI/ML experience?
No deep ML knowledge needed. The exam tests SQL developers who integrate AI features — vector search, embeddings, RAG, and AI-assisted tools. You need strong T-SQL skills but can learn the AI concepts here.
Which domain is most important?
Domains 1 and 2 are equally weighted at 35-40% each. Domain 3 (AI capabilities) is 25-30% but contains the most novel content — vector search, embeddings, and RAG. All three domains are essential.
What's in the free tier?
Three Domain 1 modules (Table Design, Constraints, Specialised Tables), the AI-Assisted SQL with Copilot module, and 10 practice questions. No account needed.
Is this a one-time purchase?
Yes. Pay once, access forever. No subscription or recurring fees.
What SQL features are new on this exam?
VECTOR data type, vector indexes (DiskANN), REGEXP functions, fuzzy matching (EDIT_DISTANCE, JARO_WINKLER), AI_GENERATE_EMBEDDINGS, AI_GENERATE_CHUNKS, MCP server connectivity, and Data API Builder — all new in SQL Server 2025.

Ready to start?

Try the free tier. Upgrade when you're ready to pass.

Start Free → Try Practice Quiz

Guided

I learn, I simplify, I share.

A Guide to Cloud YouTube Feedback

© 2026 Sutheesh. All rights reserved.

Guided is an independent study resource and is not affiliated with, endorsed by, or officially connected to Microsoft. Microsoft, Azure, and related trademarks are property of Microsoft Corporation. Always verify information against Microsoft Learn.