Name: DP-800T00: Develop AI-enabled database solutions
Availability: InStock
Rating: 4.6 (5878 reviews)

Duration:

32.00 hours

26.0 CPD hours

Overview:

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.

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.

Course Outline:

1 - 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
Module assessment

2 - 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

3 - 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
Module assessment

4 - 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
Module assessment

5 - 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
Module assessment

6 - 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

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

8 - 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
Module assessment

9 - 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

10 - 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

11 - 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

Available Delivery Options for DP-800T00: Develop AI-enabled database solutions

Live Instructor Led Classroom Online (Live Online)
Traditional Instructor Led Classroom training (TILT/ILT)
Delivery at your offices in United Kingdom
Private dedicated course for your staff

What certification does DP-800T00: Develop AI-enabled database solutions prepare you for?

The DP-800T00: Develop AI-enabled database solutions course helps prepare you for the Microsoft Applied Skills: Develop AI-enabled database solutions certification path.

Which exam does DP-800T00: Develop AI-enabled database solutions prepare you for?

The DP-800T00: Develop AI-enabled database solutions prepares you for the 'DP-800' official exam. You can take this exam at any exam center across United Kingdom including London, Manchester, Birmingham, Edinburgh or live online wherever you are.

How many CPD hours does DP-800T00: Develop AI-enabled database solutions provide?

The 4 day DP-800T00: Develop AI-enabled database solutions course gives you up to 26.0 CPD hours/structured learning hours.

Who is the correct audience for DP-800T00: Develop AI-enabled database solutions?

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.

Do you provide training for DP-800T00: Develop AI-enabled database solutions?

Yes, we provide corporate training, dedicated training and closed classes for DP-800T00: Develop AI-enabled database solutions. This can take place anywhere in United Kingdom including London, Manchester, Birmingham, Edinburgh or live online.

What is the duration of DP-800T00: Develop AI-enabled database solutions?

The DP-800T00: Develop AI-enabled database solutions training takes place over 4 day(s), with each day lasting approximately 32.00 hours including breaks.

What other terms do people search for?

Popular related searches include: DP-800T00: Develop AI-enabled database solutions, Microsoft, vILT, DP-800T00

Why are Nexus Human the best provider for DP-800T00: Develop AI-enabled database solutions?

Nexus Human are recognised as one of the best training companies. Our trainers have won awards including Small Firms Best Trainer, national training partner of the year for Ireland, and global top 30 instructor awards in 2012, 2019 and 2021.

Is there a discount code for DP-800T00: Develop AI-enabled database solutions?

Yes, the discount code PENPAL5 is currently available for DP-800T00: Develop AI-enabled database solutions training. Only one discount code can be used per booking.

DP-800T00: Develop AI-enabled database solutions