DP-800 exam prep: Microsoft SQL Server AI Developer

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.

DP-800 exam prep: Microsoft SQL Server AI Developer

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?

Get Tutorial