Create SQL Database Projects, use Data API Builder, create Vector Embeddings and use AI models in Azure SQL Database
This course covers the advanced content required for the Microsoft DP-800 “Developing AI-Enabled Database Solutions” certification exam.
What you’ll learn
- Design and develop database solutions.
- Secure and optimize database solutions.
- Deploy database solutions.
- Implement AI capabilities in database solutions.
Course Content
- Introduction –> 6 lectures • 15min.
- Signing up to Azure SQL Database and installing SSMS –> 4 lectures • 27min.
- Creating a Fabric SQL Database and installing Visual Studio Code –> 5 lectures • 38min.
- Design and implement SQL solutions by using AI-assisted tools –> 7 lectures • 38min.
- Implement data security and compliance –> 10 lectures • 1hr 14min.
- Optimize database performance –> 6 lectures • 43min.
- Creating SQL Database Projects –> 6 lectures • 42min.
- Implement CI/CD by using SQL Database Projects, and implement a testing strategy –> 9 lectures • 43min.
- Integrate SQL solutions with Azure services –> 7 lectures • 49min.
- Congratulations –> 1 lecture • 1min.

Requirements
This course covers the advanced content required for the Microsoft DP-800 “Developing AI-Enabled Database Solutions” certification exam.
Before starting this course, you should be able to create T-SQL statements, together with creating database objects such as tables, constraints, views, functions and stored procedures.
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 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?