DP-800: Develop AI-enabled database solutions

• Design and develop database solutions
• Secure, optimize, and deploy database solutions
• Implement AI capabilities in database solutions

The audience for this course is data professionals who want to learn about designing and developing AI-enabled database solutions across Microsoft’s SQL platforms, including SQL Server, Azure SQL, and SQL databases in Microsoft Fabric.
 
This role develops database solutions that include both structured and semi-structured data and integrates AI features into modern and highly scalable enterprise applications.

Module 1: Design and develop database solutions
 
Build database solutions across SQL Server, Azure SQL, and Microsoft Fabric. You learn to create well-structured database objects and indexes. You encapsulate business logic with stored procedures and functions. You write advanced T-SQL using techniques such as Common Table Expressions (CTE), window functions, and error handling. You also accelerate your development workflow with AI-assisted tools including GitHub Copilot and Fabric Copilot.
 

• Design and implement database objects with SQL
• Implement programmability objects with SQL
• Write advanced T-SQL code
• Implement SQL solutions by using AI-assisted tools

Module 2: Secure, optimize, and deploy database solutions
 
Take your database solutions from development to production. You learn to protect sensitive data with encryption, masking, and row-level security. You tune query performance using execution plans, Query Store, and dynamic management views. You automate deployments with CI/CD pipelines using SQL Database Projects. Finally, you expose your databases through REST and GraphQL APIs with Data API Builder.
 

• Implement data security and compliance with SQL
• Optimize database performance
• Implement CI/CD by using SQL Database Projects
• Integrate SQL solutions with Azure services

Module 3: Implement AI capabilities in database solutions
 
This learning path explores how to implement AI capabilities directly in Azure SQL Database. You learn to design intelligent search using full-text and vector search, integrate AI models and embeddings, and build Retrieval Augmented Generation (RAG) solutions entirely in T-SQL.
 

• Design and implement models and embeddings with SQL
• Design and implement intelligent search with SQL
• Design and implement RAG with SQL

Before starting this learning path, you should have experience writing T-SQL queries, a basic understanding of database concepts such as tables, joins, and transactions, and familiarity with SQL Server, Azure SQL Database, or SQL databases in Microsoft Fabric.

Microsoft Certified: SQL AI Developer Associate.
 
As a candidate for this certification, you should be adept at building AI‑enabled database solutions across Microsoft SQL platforms, integrating AI features, applying T‑SQL and CI/CD practices, and collaborating with cross‑functional teams to deliver secure, scalable, high‑performance data solutions.
 

• Level: Intermediate
• Product: Azure
• Role: Developer
• Subject: Data management

 
You should also have experience writing T-SQL code and developing databases in Microsoft SQL platforms. Plus, you need to be familiar with continuous integration and continuous deployment (CI/CD) practices in GitHub, AI-assisted development tools, and AI concepts, such as embeddings, vectors, and models.
 
Your responsibilities include:
 

• Designing and developing database solutions that include both structured and semi-structured data.
• Integrating AI features into modern and highly scalable enterprise applications.
• Securing, optimizing, and deploying database solutions.
• Implementing AI capabilities in database solutions.

 
You work closely with application developers; database administrators (DBAs); architects; AI engineers; development, security, operations (DevSecOps) engineers; security and compliance administrators; and other stakeholders to deliver robust, high-performance database solutions that power modern applications and AI-driven experiences.