SQL AI Developer Associate DP-800 Course Overview

Course syllabus

Who it’s for

What’s included

FAQs

SQL AI Developer Associate DP-800 Course Outline

Module 1: Design and Implement Database Objects with SQL

  • Introduction
  • Understand Your SQL Server-Based Platform Choices
  • Build Effective Tables
  • Optimise with Indexes
  • Use Specialised Table Types
  • Enforce Data Integrity with Constraints
  • Manage JSON Columns and Indexes
  • Partition Tables for Scale
  • Exercise - Create and Maintain Database Objects

Module 2: Implement Programmability Objects with SQL

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

Module 3: Write Advanced T-SQL Code

  • Introduction
  • Organise 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 4: Implement SQL Solutions by Using AI-Assisted Tools

  • Introduction
  • 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 5: Implement Data Security and Compliance with SQL

  • Introduction
  • 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 6: Optimise Database Performance

  • Introduction
  • 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 - Optimise Query Performance

Module 7: Implement CI/CD by Using SQL Database Projects

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

Module 8: Integrate SQL Solutions with Azure Services

  • Introduction
  • 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 9: Design and Implement Models and Embeddings with SQL

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

Module 10: Design and Implement Intelligent Search with SQL

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

Module 11: Design and Implement RAG with SQL

  • Introduction
  • 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
Show more blue-arrow
Show more blue-arrow

Who Should Attend This SQL AI Developer Associate DP-800 Course?

This course is designed for professionals who want to build intelligent database solutions by combining SQL and AI capabilities. It is suitable for individuals looking to enhance their database development skills and work with modern AI-driven applications. This course is particularly beneficial for:

  • SQL Developers
  • Database Administrators
  • Data Engineers
  • Backend Developers
  • Cloud and Azure Professionals
  • AI and Data Enthusiasts

Prerequisites of the SQL AI Developer Associate DP-800 Course

There are no strict prerequisites. However, experience with SQL, T-SQL, database development, and familiarity with cloud platforms or AI concepts such as embeddings and models is recommended.

SQL AI Developer Associate DP-800 Course Overview

The SQL AI Developer Associate DP-800 Course provides a practical understanding of how artificial intelligence can be integrated into database systems. It introduces modern techniques used to build intelligent applications that leverage structured data and AI models.

The training focuses on combining SQL development with AI capabilities such as vector search, embeddings, and semantic queries. Organisations can use these techniques to improve data processing, enhance application intelligence, and automate decision-making processes.

This 3-Day course offered by The Knowledge Academy equips delegates with the knowledge and hands-on skills required to design, develop, and optimise AI-enabled database solutions using Microsoft technologies.

SQL AI Developer Associate DP-800 Objectives

  • To understand AI integration within SQL-based database systems 
  • To design and develop scalable and secure database solutions
  • To implement embeddings, vector search, and intelligent queries
  • To optimise database performance and query execution
  • To integrate SQL solutions with APIs and AI services
  • To apply AI techniques in real-world database applications

Upon completing this course, delegates will be able to build intelligent, AI-powered database solutions and enhance application performance using modern SQL technologies.

Show more blue-arrow

What’s Included in this SQL AI Developer Associate DP-800 Course?

  • World-Class Training Sessions from Experienced Instructors
  • Digital Delegate Pack
  • SQL AI Developer Associate DP-800 Certificate
  • Interactive Learning with 24×7 Support
     
Hands-On Labs: Included as part of our online instructor-led delivery, these labs provide real-world exercises in a simulated environment guided by expert instructors to enhance your practical skills.
Show more blue-arrow

Train Your Workforce

Looking for SQL AI Developer Associate DP-800 Course in-house or onsite training New Delhi. We specialise in corporate group training and bulk bookings for organisations of all sizes. Our trainers deliver tailored sessions at your premises, online, or hybrid, with best price guarantee, group discounts and flexible scheduling.

Approved supplier to 53,723 organisations

The Knowledge Academy is an approved training supplier to 53,723 organisations across the UK, Europe, North America and Australia, so most buyers can book through their existing purchasing process with no new supplier setup.

Our New Delhi venue

Includes..

Free Wi-Fi

To make sure you’re always connected we offer completely free and easy to access wi-fi.

Air conditioned

To keep you comfortable during your course we offer a fully air conditioned environment.

Full IT support

IT support is on hand to sort out any unforseen issues that may arise.

Video equipment

This location has full video conferencing equipment.

New Delhi is one of the districts within Delhi, as well as it being the capital city of India, it is also the home to the Government of the National Capital Territory of Delhi and some of the branches of the Government of India, these being the judiciary, executive and legislative branches and is also home to around 249,998 people. The capital of India - New Delhi was initiated within 1931 by Viceroy Lord Irwin however formed during 1911 by George V, who was the King of the United Kingdom as well as the Emperor of India and his British architects Sir Herbert Baker and Sir Edwin Lutyens formed the foundation stone and announced the capital city of India would be changed. The primary schools and secondary schools within New Delhi are either run privately or by the government and as of 2004 to 2005 there was around 1.5 million students going through the educational system within 2416 primary schools, 822,00 students in 715 middle schools and 669,000 students in 1576 secondary schools and around 500,000 students within 165 universities and colleges. All universities are either state, deemed or central universities, The top universities within New Delhi are the Jamia Millia Islamia, the University of Delhi, Indian Statistical Institute, National Law University, Jawaharlal Nehru University, Guru Gobind Singh Indraprastha University, Ambedkar University Delhi, Jamia Hamdard, Delhi Technological University – which is the first Engineering college within Delhi and one of the oldest in India, the Indira Gandhi National Open University is the largest national university in the world with over 4 million students, New Delhi is also home to the Indian Agricultural Research Institute, Pusa, New Delhi, Premier institute for agricultural research and education in India. The university courses and programs can offer different types of degrees such an undergraduate and post graduate courses, Bachelor courses and Scholarships, New Delhi prides itself on its premier institutions as the teaching and researching they do means that within 2011 the census recorded the literacy rate for females as 80.9% and for males it was slightly higher at 91.0% with an overall literacy rate of 86.3%. Subjects within the different universities can include, social sciences, engineering, humanities, technology, sports, law, social work, arts, management, education, computer information technology, foreign languages, mathematical science, dentistry and medical. 

Show moredown

Ways to take SQL AI Developer Associate DP-800 Course in New Delhi

Live Online

The same live course from home, with a live instructor and other delegates. Mirrors the classroom schedule.

Best for: starting soon, without travel.

3 days · next Mon 8 Feb 2027

See live online dates

Online Self-Paced

Study 24/7 on your own schedule through our learning platform, with progress tracking.

Best for: fitting study around work.

90 days of access

See self-paced options

Onsite

We bring the course to your team, at your premises, online or hybrid, on dates that suit you.

Best for: groups and bulk bookings.

Tailored to your team

Get a team quote

Loading ....

Package deals for SQL AI Developer Associate DP-800 Course in New Delhi

Our training experts have compiled a range of course packages on a variety of categories in SQL AI Developer Associate DP-800 Course, to boost your career. The packages consist of the best possible qualifications with SQL AI Developer Associate DP-800 Course, and allows you to purchase multiple courses at a discounted rate.

SQL AI Developer Associate DP-800 Course in New Delhi FAQs

What time shall I arrive at the venue?

Please arrive at the venue at 8:45am.

What are the pre-requisites?

Who should attend this course?

Do you offer support for the course?

We are able to provide support via phone & email prior to attending, during and after the course.

What is included in the course?

Delegate pack consisting of course notes and exercises, Manual, Experienced Instructor, and Refreshments

What is the duration of this course?

This course is [ ] day(s)

How long until I receive the course confirmation details?

Once your booking has been placed and confirmed, you will receive an email which contains your course location, course overview, pre-course reading material (if required), course agenda and payment receipts

What is the cost/training fees for SQL AI Developer Associate DP-800 Course in New Delhi?

The training fees for SQL AI Developer Associate DP-800 Course in New Delhi starts from INR369995

Which is the best training institute/provider of SQL AI Developer Associate DP-800 Course in New Delhi?

The Knowledge Academy is one of the Leading global training provider for SQL AI Developer Associate DP-800 Course.

What are the best Microsoft SQL Server Training courses in New Delhi?

Please see our Microsoft SQL Server Training courses available in New Delhi

Show more blue-arrow

Customers Reviews

Request For Pricing

WHO WILL FUNDING THE COURSE?
+44

Corporate Training

Unlock tailored pricing and customised training solutions for your team’s needs.

Request your quote today!

Why choose The Knowledge Academy

price

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

trusted

Trusted & Approved

Recognised by leading certification bodies, we deliver training you can trust.

learning

Many delivery methods

Flexible delivery methods are available depending on your learning style.

resources

High quality resources

Resources are included for a comprehensive learning experience.

Our Clients

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water
santander barclays bmw google thames-water deloitte bupa tesla
cross

Exclusive Deals For Future Leaders!

friday-sale UP TO 60% OFF!

* WHO WILL BE FUNDING THE COURSE?

close

close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.