Microsoft SQL Edition · DP-800 aligned
AI-Enabled Database Developer — Microsoft SQL
Build production database solutions with AI built in — and earn the Microsoft DP-800 credential. Design, secure, deploy, and AI-enable modern database solutions on SQL Server 2025, Azure SQL, and Microsoft Fabric.
What you’ll be able to do
- Design schemas that scale — temporal tables, JSON columns, graph relationships.
- Write T-SQL like a pro — window functions, CTEs, error handling, the senior patterns.
- Secure & deploy — Always Encrypted, Managed Identity, RLS, CI/CD.
- Build AI-native features — vector search, embeddings, hybrid retrieval, RAG — in the database.
- Ship & certify — a real portfolio app, plus structured DP-800 prep.
Built for
Data analysts moving into engineering · developers modernizing toward AI · application engineers wanting data fluency · career changers targeting a credential · teams on Microsoft SQL, Azure SQL, and Fabric.
How you’ll learn
Self-paced 20–45 minute lessons · live flipped-classroom sessions on Zoom · Docker-first labs (Azure only where DP-800 requires it) · one project — FieldNote — across all five sub-courses.
Curriculum
The five sub-courses
AIDD-MS-0
SQL Foundations
Relational thinking, SELECT, JOINs, and aggregation — the fundamentals the program assumes. A fully taught foundation, not a gate.
▸ Get ready to build
- SELECT
- JOIN logic
- GROUP BY
- Subqueries
- Set operators
AIDD-MS-1
Database Development
Stop writing SQL like a beginner. Schema design with temporal, JSON, and graph; the advanced T-SQL toolkit; programmability; and AI-assisted development with Copilot and MCP.
▸ Builds FieldNote v1 — schema, queries, programmability
- Temporal
- JSON
- Graph
- Window functions
- Copilot
- MCP
AIDD-MS-2
Security & Deployment
Close the gap between “works in dev” and “runs safely in production” — layered security, performance diagnosis, source-controlled CI/CD, and Azure integration.
▸ Hardens FieldNote for production
- Always Encrypted
- RLS
- Query Store
- DACPACs
- GitHub Actions
- DAB
AIDD-MS-3 AI
AI Capabilities
The differentiating sub-course: external models from T-SQL, embeddings, full-text and DiskANN vector search, hybrid retrieval with RRF, and end-to-end RAG in stored procedures.
▸ Makes FieldNote AI-native — semantic search + RAG
- Embeddings
- VECTOR_SEARCH
- DiskANN
- Hybrid RRF
- RAG
AIDD-MS-4
Capstone & DP-800 Exam Readiness
Polish FieldNote into a portfolio piece, prepare evidence-based for the exam (75% internal threshold), defend it to peers, then sit DP-800 — and leave with a 12-month plan.
▸ Defends FieldNote, earns the credential
- Capstone defense
- Practice Assessment
- Timed mock
- 12-month plan
How it maps to DP-800
Three skill domains, each mapped directly to a sub-course. Passing score 700/1000; exam fee paid directly to Microsoft.
- Domain 1 · Design & develop — 35–40% — AIDD-MS-1
- Domain 2 · Secure, optimize, deploy — 35–40% — AIDD-MS-2
- Domain 3 · Implement AI capabilities — 25–30% — AIDD-MS-3
Schema, queries, programmability.
Security, performance, CI/CD.
Semantic search + working RAG.
Close gaps, document, sit the exam.
Cut sheets
Download the detail
The full program brochure and a one- or two-page cut sheet for every sub-course.
Real skills. A respected credential. In that order.
If you want durable, job-ready database and AI skills — and the certification that proves them — start with a free placement assessment.