Course Overview
DP-800 is Microsoft's certification for developers building intelligent, AI-enabled applications on the SQL platform. This hands-on course covers modern database development across SQL Server, Azure SQL, and SQL database in Microsoft Fabric — then layers on AI: vector data types, embeddings, semantic and hybrid search, and retrieval-augmented generation (RAG) with Azure OpenAI. You leave able to design, secure, and optimise production-grade AI data solutions on SQL.
What You Will Learn
- Develop and optimise T-SQL queries, procedures, and functions
- Design performant schemas, indexes, and JSON data structures
- Store and query vector data with the SQL vector data type
- Generate and manage embeddings for structured and unstructured data
- Implement semantic, keyword, and hybrid search patterns
- Build RAG solutions integrating Azure OpenAI with SQL data
- Secure AI data solutions with Entra ID, RLS, and data masking
- Monitor, tune, and troubleshoot AI-enabled database workloads
Certification & Exam
Exam DP-800: Develop AI Solutions with Microsoft SQL. Certification: Microsoft Certified: SQL AI Developer Associate. Live labs cover vector search, embedding generation, RAG implementation, and securing AI data solutions.