What you'll learn:
- Design and develop database solutions
- Secure and optimize database solutions
- Deploy database solutions
- Implement AI capabilities in database solutions
This course covers the advanced content required for the Microsoft DP-800 "Developing AI-Enabled Database Solutions" certification exam, updated with minor changes as of 19 October 2026.
What will you learn in this course?
We'll create an Azure SQL Database with sample data, as well as a Fabric SQL Database and install SSMS and Visual Studio Code.
We'll create T-SQL statements, including database objects, programmability objects, and basic and advanced T-SQL code.
We’ll then add GitHub and Microsoft Copilot, Implement data security and compliance, and Optimize database performance.
We’ll then create SQL Database Projects to implement schema changes, and add source control using GitHub. We’ll also integrate SQL solutions with Azure services.
Finally, we'll look at how to implement AI capabilities in database solutions. We’ll design and implement models, embeddings and intelligent search using vectors and full-text indexing, and design and implement retrieval-augmented generation.
Once you have completed the course, you will have a good knowledge of developing AI-enabled Database Solutions using Azure SQL Database. And with some practice and knowledge of some additional topics, you could even go for the official Microsoft certification DP-800 - wouldn't the "Microsoft Certified: SQL AI Developer Associate" certification look good on your CV or resume?
I hope to see you in the course - why not have a look at what you could learn?
