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
What you'll learn
Design and develop database solutions
Secure and optimize database solutions
Deploy database solutions
Implement AI capabilities in database solutions
Requirements
Before you begin this course, you should have a computer with access to the internet.
This course is intended for users who are able to query a SQL Server database, and create tables, views, functions, stored procedures, triggers, common-table expressions and so on.
Description
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?
Who this course is for
This course is for you if you want to design and develop database solutions using SQL Server.
By the end of this course, you could enter (and hopefully pass) Microsoft's official DP-800 exam.
Wouldn't the "SQL AI Developer Associate" certification look good on your CV or resume?