DP-800: Develop AI-enabled database solutions
Overview
This course teaches students how to design and develop AI-enabled database solutions using Microsoft SQL technologies, including SQL Server, Azure SQL, and SQL databases in Microsoft Fabric. Students will learn how to build modern data solutions that work with both structured and semi-structured data, and how to add AI capabilities such as vector search, embeddings, and intelligent data retrieval to business applications.
Who should attend
The course is ideal for database professionals, data engineers, and application developers who want to create scalable, AI-powered solutions using SQL-based data services.
Prerequisites
To get the most out of this course, you should have:
- Basic knowledge of SQL (queries, tables, joins)
- Understanding of databases
- Basic familiarity with cloud concepts (Azure preferred)
- Interest in Artificial Intelligence (no prior experience required)
What you'll learn
By the end of this course, you will be able to:
- Design AI-enabled database solutions
- Work with Azure SQL, SQL Server, and Microsoft Fabric
- Implement vector search, embeddings, and semantic queries
- Build intelligent, AI-powered backend applications
- Create and manage data pipelines for AI workloads
- Optimize performance and ensure secure data solutions
- Apply real-world scenarios aligned with the DP-800 exam
Course content
Design and develop database solutions
- 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
Secure, optimise, and deploy database solutions
- Implement data security and compliance with SQL
- Optimise database performance
- Implement CI/CD by using SQL Database Projects
- Integrate SQL solutions with Azure services
Implement AI capabilities in database solutions
- Design and implement models and embeddings with SQL
- Design and implement intelligent search with SQL
- Design and implement RAG with SQL
Common questions
When does DP-800: Develop AI-enabled database solutions next run?
The next date is Mon, 16 Nov 2026, and there is 1 further date scheduled. Delivered live online, ACE Training Wellington. Every date and its format is listed on this page.
How much does DP-800: Develop AI-enabled database solutions cost?
From $2,995 + GST per person. Pricing can differ by date and location, so check the option you want before booking.
Do I need any prior experience?
To get the most out of this course, you should have: Basic knowledge of SQL (queries, tables, joins) Understanding of databases Basic familiarity with cloud concepts (Azure preferred) Interest in Artificial Intelligence (no prior experience required)
Can I attend online, or does it have to be in a classroom?
Both. Some dates run live online and others in-class — each date on this page shows its format, so pick whichever suits.
Can you run this course for my team?
Yes. Any ACE course can be delivered in-house at your workplace and tailored to your team's tools and goals — quote course code DP800 when you enquire.