SQL AI Developer Associate DP-800 Course in Kitchener

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

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.

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