DP-800 : Develop AI-Enabled Database Solutions

• Duration: 3 days

Overview

This course provides participants with the knowledge and skills required to design and develop AI-enabled database solutions across Microsoft SQL platforms, including SQL Server, Azure SQL, and SQL databases in Microsoft Fabric.

Participants will learn how modern databases can support AI-powered applications by working with structured and semi-structured data and integrating AI capabilities such as vector search, embeddings, and AI-assisted development.

The course focuses on developing scalable and modern database solutions for enterprise applications, while addressing database design, programmability, advanced T-SQL, AI-assisted development, data management, security, and performance considerations.

By the end of the course, participants will be able to develop modern SQL-based data solutions that support AI, analytics, and intelligent applications across cloud and hybrid environments.

What You’ll Learn

• Understand the fundamentals of AI-enabled database solutions and their business applications
• Explore how modern databases support AI, analytics, and intelligent applications
• Design database architecture for structured and semi-structured data
• Develop database objects for modern SQL platforms
• Implement programmable database objects such as views, stored procedures, functions, and triggers
• Apply advanced T-SQL techniques for modern database solutions
• Work with JSON, regular expressions, fuzzy matching, and graph queries
• Integrate AI capabilities into SQL-based database environments
• Use AI-assisted development tools such as GitHub Copilot and Fabric Copilot
• Design scalable database solutions for cloud and hybrid environments
• Apply database security, governance, and data management best practices
• Optimize database performance for AI-enabled applications

Who Should Attend

This course is designed for:

• Database Developers
• SQL Developers
• Data Professionals
• Database Engineers
• Data Engineers
• Application Developers
• Data Architects
• Azure Data Professionals
• Software Developers working with SQL-based applications

It is particularly suitable for professionals who develop database solutions across SQL Server, Azure SQL, and SQL databases in Microsoft Fabric, and who want to incorporate AI capabilities into modern enterprise applications.

Prerequisites

Before attending this course, participants should have:

• Experience writing T-SQL queries
• Basic understanding of database concepts
• Familiarity with tables, joins, and transactions
• Familiarity with SQL Server, Azure SQL Database, or SQL databases in Microsoft Fabric
• Basic understanding of database development concepts

Curriculum

Module 01: Design and Implement Database Objects with SQL

Learn how to design and implement database objects across modern Microsoft SQL platforms.

Topics include:

• Database object design
• Tables and data types
• Specialized table types
• Indexes
• Database constraints
• Partitioning strategies
• Database object implementation
• Database performance considerations
• Optimizing database structures

Module 02: Implement Programmability Objects with SQL

Learn how to use SQL programmability features to create maintainable, secure, and efficient database solutions.

Topics include:

• Views
• Stored procedures
• Scalar functions
• Table-valued functions
• Triggers
• Database programmability
• Reusable database logic
• Security considerations
• Maintainable database development
• Performance considerations

Module 03: Write Advanced T-SQL Code

Develop advanced T-SQL skills for building sophisticated database solutions across SQL Server, Azure SQL, and Microsoft Fabric.

Topics include:

• Common Table Expressions (CTEs)
• Window functions
• JSON data processing
• Regular expressions
• Fuzzy matching
• Graph queries
• Advanced query techniques
• Error handling
• Complex data processing
• Cross-platform T-SQL development

Module 04: Implement SQL Solutions Using AI-Assisted Tools

Learn how AI-powered development tools can enhance SQL development and improve productivity across Microsoft’s SQL platforms.

Topics include:

• AI-assisted database development
• GitHub Copilot
• Microsoft Fabric Copilot
• AI-assisted T-SQL development
• Generating and improving SQL queries
• Understanding AI-generated code
• Troubleshooting and optimizing SQL code
• Applying AI tools in database development workflows
• Responsible use of AI-assisted development tools

Course Outcome

Upon successful completion of this course, participants will be able to design, develop, and optimize modern AI-enabled database solutions across SQL Server, Azure SQL, and Microsoft Fabric.

Participants will gain practical skills in database object design, SQL programmability, advanced T-SQL development, semi-structured data processing, and AI-assisted database development, enabling them to build scalable and efficient data solutions for modern enterprise applications.