Program Outline
Develop AI-enabled database solutions
This 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.
Delivery
Virtual, On-site, or Hybrid
Duration
3 days
Product
Sql Server
Role
Data Analyst
Microsoft
Data ManagementSQL AI Developer Associate (beta)
Azure
Best Fit
Audience Profile
Who This Program Is For
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.
Overview
Program Summary
As a candidate for this Microsoft Certification, you should have subject matter expertise in designing and developing AI-enabled database solutions across Microsoft SQL platforms, including Microsoft SQL Server, Azure SQL, and SQL databases in Microsoft Fabric.
Course Outline
Complete Module Sequence
Review the full module sequence for this program, including the primary topic coverage in each module where available.
1Module 1
Design and develop database solutions
+
Module 1
Design and develop database solutions
Learn to design and implement database objects, programmability objects, advanced T-SQL code, and AI-assisted tools for SQL Server, Azure SQL, and Microsoft Fabric.
- 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
2Module 2
Secure, optimize, and deploy database solutions
+
Module 2
Secure, optimize, and deploy database solutions
Learn to protect data with encryption and access controls, tune query performance, implement CI/CD pipelines for database projects, and integrate SQL solutions with Azure services.
- Implement data security and compliance with SQL
- Optimize database performance
- Implement CI/CD by using SQL Database Projects
- Integrate SQL solutions with Azure services
3Module 3
Implement AI capabilities in database solutions
+
Module 3
Implement AI capabilities in database solutions
Learn to design intelligent search, work with models and embeddings, and build Retrieval Augmented Generation (RAG) patterns in T-SQL.
- Design and implement models and embeddings with SQL
- Design and implement intelligent search with SQL
- Design and implement RAG with SQL
Coverage Areas
Topic Coverage
Coverage Item 1
Design and develop database solutions
Coverage Item 2
Secure, optimize, and deploy database solutions
Coverage Item 3
Implement AI capabilities in SQL solutions
Customization
Adapt This Program for Your Team
We can adapt this program around your team structure, platform priorities, delivery goals, and the scenarios your people need to work through in practice.
- •Align labs to your Microsoft tenant and workload scenarios
- •Add readiness checks and exam preparation reviews
- •Extend delivery with role-specific implementation workshops
