DP-800T00: Develop AI-enabled database solutions

Price
$2,495.00 USD

Duration
4 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

Request More Information
Download Course Details
Course Details Only
Course Details & Schedule
Skip to Class Dates

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

Who Should Attend?

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.  
  • Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
  • Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
  • Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
  • Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
  • Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
  • Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

Learning Credits: Learning Credits can be purchased well in advance of your training date to avoid having to commit to specific courses or dates. Learning Credits allow you to secure your training budget for an entire year while eliminating the administrative headache of paying for individual classes. They can also be redeemed for a full year from the date of purchase. If you have previously purchased a Learning Credit agreement with New Horizons, you may use a portion of your agreement to pay for this class.

If you have questions about Learning Credits, please contact your Account Manager.

Corporate Tech Pass: Our Corporate Tech Pass includes unlimited attendance for a single person, in the following Virtual Instructor Led course types: Microsoft Office, Microsoft Technical, CompTIA, Project Management, SharePoint, ITIL, Certified Ethical Hacker, Certified Hacking Forensics Investigator, Java, Professional Development Courses and more. The full list of eligible course titles can be found at https://www.newhorizons.com/eligible.

If you have questions about our Corporate Tech Pass, please contact your Account Manager.

Agenda

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
 

Get in touch to schedule training for your team
We can enroll multiple students in an upcoming class or schedule a dedicated private training event designed to meet your organization’s needs.

CourseID: 3606836E
 



Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
Contact Us about Starting Your Business Training Strategy with New Horizons