8781  Reviews star_rate star_rate star_rate star_rate star_half
$2,495USD
Duration 3 days
Course Code DP-800T00
Available Formats Classroom, Virtual
Next Class: Sep 9, 2026

Upcoming Course Dates

Ask a Question Request Other Date Request On-site Course

Overview

Course Description

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.

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.?  

Read Less
|
View Full Schedule

Course Details

Course Details

Outline

  • Design and implement database objects with SQL
    • Understand your SQL server-based platform choices
    • Build effective tables
    • Optimize with indexes
    • Use specialized table types
    • Enforce data integrity with constraints
    • Manage JSON columns and indexes
    • Partition tables for scale
    • Exercise - Create and maintain database objects
    • Module assessment
  • Implement programmability objects with SQL
    • Create views
    • Create stored procedures
    • Create scalar functions
    • Create table-valued functions
    • Create triggers
    • Choose when to use each option
    • Exercise: Implement programmability objects in SQL Server
    • Knowledge check
  • Write advanced T-SQL code
    • Organize queries with common table expressions
    • Apply window functions for analytics
    • Process JSON data with built-in functions
    • Match patterns with regular expressions
    • Find approximate matches with fuzzy string functions
    • Traverse relationships with graph queries
    • Compare rows with correlated subqueries
    • Handle errors with TRY...CATCH
    • Exercise - Work with JSON functions
    • Module assessment
  • Implement SQL solutions by using AI-assisted tools
    • Describe AI-assisted development tools available for Microsoft SQL platforms
    • Interpret security impact of using AI-assisted tools
    • Enable GitHub Copilot and Fabric Copilot
    • Configure model and model context protocol (MCP) tool options in a GitHub Copilot or Fabric Copilot chat session
    • Create and configure GitHub Copilot instruction files
    • Connect to MCP server endpoints, including Microsoft SQL Server and Fabric lakehouse
    • Exercise - Configure AI-assisted tools for database development
    • Module assessment
  • Implement data security and compliance with SQL
    • Protect data with encryption
    • Configure dynamic data masking
    • Implement row-level security
    • Manage permissions and secure access
    • Implement auditing
    • Configure secure access to AI services
    • Secure data API endpoints
    • Exercise: Implement security features
    • Module assessment
  • Optimize database performance
    • Recommend database configurations
    • Preserve data integrity with transaction isolation levels and concurrency controls
    • Evaluate query performance with execution plans and DMVs
    • Monitor and tune queries with query store and query performance insight
    • Identify and resolve blocking and deadlocks
    • Exercise: Optimize query performance
    • Knowledge check
  • Implement CI/CD by using SQL database projects
    • Create, build, and validate SQL database projects
    • Configure source control and manage reference data
    • Manage branching, pull requests, and conflict resolution
    • Detect and resolve schema drift
    • Implement CI/CD pipelines
    • Design and implement a testing strategy
    • Exercise: implement CI/CD by using SQL database projects
    • Knowledge check
  • Integrate SQL solutions with Azure services
    • Create configuration files for data API builder
    • Define entities for REST and GraphQL
    • Expose database objects, stored procedures, and views
    • Explore deployment options for data API builder
    • Recommend Azure monitor configurations
    • Handle changes with event-driven patterns
    • Exercise - Configure data API builder for a product catalog
    • Module assessment
  • Design and implement models and embeddings with SQL
    • Understand and evaluate models for SQL database workloads
    • Create and manage external models in SQL
    • Design embeddings for SQL database workloads
    • Generate and maintain embeddings for SQL database workloads
    • Exercise - Generate and update embeddings in Azure SQL Database
    • Knowledge check
  • Design and implement intelligent search with SQL
    • Choose an intelligent search approach
    • Implement full-text search
    • Prepare SQL for vector search
    • Implement vector search query patterns
    • Implement hybrid search and ranking
    • Exercise - Implement intelligent search with full-text, vector, and hybrid queries
    • Knowledge check
  • Design and implement RAG with SQL
    • Identify RAG use cases and architecture
    • Prepare retrieval context for augmentation
    • Augment prompts with database context
    • Generate and process RAG responses
    • Exercise: Implement a RAG solution
    • Knowledge check

Schedule

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

Reviews

I think the platform is very good and look forward to taking my next course in early October.

ExitCertified provided us with a great opportunity to learn more about React and in easy to follow way.

Simply great training provider that I can go for updating/acquiring my skill sets.

You get detailed labs to guide you through the technical material giving you a hands on method of learning otherwise difficult material.

The training was good but needed the basic skills of maximo before getting deep in the configuration of it.