DP-800 exam prep: Microsoft SQL Server AI Developer

<div>This course covers the advanced content required for the Microsoft DP-800 "Developing AI-Enabled Database Solutions" certification exam.</div><div><br></div><div>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.</div><div><br></div><div>If you are not yet at that stage, I have now added three sections (sections 3 to 5) which go through the 6 principal clauses of the SELECT statement and data types (together with some functions).</div><div><br></div><div>What will you learn in this course?</div><div><ul><li>We'll create an Azure SQL Database with sample data, as well as a Fabric SQL Database and install SSMS and Visual Studio Code.</li><li><span style="font-size: 1rem;">We’ll then add GitHub and Microsoft Copilot, Implement data security and compliance, and Optimize database performance.</span></li><li><span style="font-size: 1rem;">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.</span></li><li><span style="font-size: 1rem;">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.</span></li></ul></div><div><span style="font-size: 1rem;">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?</span></div><div><br></div><div>I hope to see you in the course - why not have a look at what you could learn?</div>

What you'll learn:

• Design and develop database solutions
• Secure and optimize database solutions
• Deploy database solutions
• Implement AI capabilities in database solutions