DP-800T00: Develop AI-Enabled Database Solutions

To view the class schedule you need to become an Affiliate

• Largest “Guaranteed To Run” public technical training schedules available
• Easy to become an Affiliate – no charge or fee

Become an EPIC Affiliate

already an Affiliate?  Login

About this Course

This intensive 3-day course provides students with the knowledge and skills to design and develop AI enabled database solutions across Microsoft SQL platforms, including SQL Server, Azure SQL, and SQL databases in Microsoft Fabric. It is intended for professionals who build modern data solutions that integrate structured and semi structured data and incorporate AI features into scalable enterprise applications. It will also be valuable for individuals who develop applications that rely on SQL based data services enhanced with vector search, embeddings, and other AI driven capabilities.

Audience Profile

The audience for this course is data professionals who want to learn about designing and developing AI-enabled database solutions across Microsoft’s SQL platforms, including SQL Server, Azure SQL, and SQL databases in Microsoft Fabric. This role develops database solutions that include both structured and semi-structured data and integrates AI features into modern and highly scalable enterprise applications.

At Course Completion

Outline

Learning Path: Design and develop database solutions

Build database solutions across SQL Server, Azure SQL, and Microsoft Fabric. You learn to create well-structured database objects and indexes. You encapsulate business logic with stored procedures and functions. You write advanced T-SQL using techniques such as Common Table Expressions (CTE), window functions, and error handling. You also accelerate your development workflow with AI-assisted tools including GitHub Copilot and Fabric Copilot.

Lessons:

• Design and implement database objects with SQL
• Implement programmability objects with SQL
• Write advanced T-SQL code
• Implement SQL solutions by using AI-assisted tools

Exercises:

• Create and maintain database objects
• Implement programmability objects in SQL Server
• Work with JSON functions
• Configure AI-assisted tools for database development

Learning Path: Secure, optimize, and deploy database solutions

Take your database solutions from development to production. You learn to protect sensitive data with encryption, masking, and row-level security. You tune query performance using execution plans, Query Store, and dynamic management views. You automate deployments with CI/CD pipelines using SQL Database Projects. Finally, you expose your databases through REST and GraphQL APIs with Data API Builder.

Lessons:

• Implement data security and compliance with SQL
• Optimize database performance
• Implement CI/CD by using SQL Database Projects
• Integrate SQL solutions with Azure services

Exercises:

• Implement security features
• Optimize query performance
• Implement CI/CD by using SQL Database Projects
• Configure Data API Builder for a product catalog

Learning Path: Implement AI capabilities in database solutions

This learning path explores how to implement AI capabilities directly in Azure SQL Database. You learn to design intelligent search using full-text and vector search, integrate AI models and embeddings, and build Retrieval Augmented Generation (RAG) solutions entirely in T-SQL.

Lessons:

• Design and implement models and embeddings with SQL
• Design and implement intelligent search with SQL
• Design and implement RAG with SQL

Exercises:

• Generate and update embeddings in Azure SQL Database
• Implement intelligent search with full-text, vector, and hybrid queries
• Implement a RAG solution

Prerequisites

Before attending this course, students must have:
• Experience writing T-SQL code and developing databases in Microsoft SQL platforms.
• Plus, you need to be familiar with continuous integration and continuous deployment (CI/CD) practices in GitHub, AI-assisted development tools, and AI concepts, such as embeddings, vectors, and models