This is an example of a simple banner

Training: Develop AI-enabled database solutions (DP-800)

Ref. DP-800T00
Duration:
3
 days
Exam:
Optional
Level:
Intermediate

Develop AI-enabled database solutions Training (DP-800)

This AI-enabled database training is built for developers working with SQL Server, Azure SQL or SQL databases in Microsoft Fabric. Your users expect search that understands what they mean, assistants that answer from company data and features shipped faster, with no compromise on security. The good news: all of this can now be built inside the database itself, in T-SQL, without bolting on extra components.

Three days to make your SQL database the foundation of your AI applications

The official Microsoft DP-800 course follows a clear path. You start by strengthening the foundations: tables, indexes, JSON, programmability objects and advanced T-SQL, including regular expressions and graph queries. You then learn to develop with GitHub Copilot and MCP servers, secure and tune your databases, and deploy them with SQL Database Projects and Data API builder. The final part turns to AI: external models, embeddings, vector and hybrid search, and retrieval-augmented generation (RAG) right inside SQL. You leave able to deliver smart data solutions that are secure and easy to maintain.

Participant Profiles

  • SQL Server and Azure SQL database developers
  • Application developers adding AI features on top of their data
  • Database administrators moving into development
  • Data engineers working with SQL databases in Microsoft Fabric
  • AI engineers designing RAG solutions on company data
  • DevOps engineers in charge of database deployments

Objectives

  • Design tables, indexes and programmability objects for SQL Server, Azure SQL and Microsoft Fabric
  • Write advanced T-SQL: CTEs, window functions, JSON, regular expressions and graph queries
  • Develop faster with GitHub Copilot and MCP servers while keeping their security impact under control
  • Secure data and tune performance with encryption, row-level security and Query Store
  • Automate deployment with SQL Database Projects and expose data over REST and GraphQL with Data API builder
  • Generate embeddings, implement vector and hybrid search and build a RAG solution in SQL

Prerequisites

  • Hands-on experience writing T-SQL queries (the DP-080 course is good preparation)
  • Basic knowledge of database development on SQL Server or Azure SQL
  • Some familiarity with GitHub and AI concepts such as embeddings and vectors

Course Content

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

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

Module 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

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

Module 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

Module 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

Documentation

  • Access to Microsoft Learn, Microsoft’s online learning platform, offering interactive resources and educational content to deepen your knowledge and develop your technical skills.

Lab / Exercises

  • This course provides you with exclusive access to the official Microsoft lab, enabling you to practice your skills in a professional environment.

Exam

  • This course prepares you to the DP-800: Developing AI-Enabled Database Solutions exam.

Complementary Courses

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

Additional Information

AI-enabled database training: when AI moves into SQL

For years, adding AI to an application meant copying data to another service: a vector database on one side, the relational database on the other, and scripts to keep them in sync. Every copy added risk, delay and maintenance work.

Microsoft SQL platforms have changed that. SQL Server, Azure SQL and SQL databases in Microsoft Fabric can now store vectors, call external models and combine semantic search with regular filters in a single query. The Develop AI-enabled database solutions (DP-800) course starts from there: the SQL developer becomes a key player in AI projects. For organizations in French-speaking Switzerland that keep sensitive data in SQL Server, it is also a way to bring AI to the data rather than the other way round.

Vector search, hybrid search and RAG inside the database

At the heart of this AI-enabled database training is intelligent search. You learn to choose between full-text search, semantic vector search and hybrid search depending on the question being asked. You also prepare the data: which columns belong in an embedding, how to split long text into chunks, and how to keep embeddings current when rows change.

Then come the design decisions that matter in production: the vector data type, vector indexes, exact (ENN) or approximate (ANN) search, and merging rankings with Reciprocal Rank Fusion. Retrieval-augmented generation (RAG) closes the loop: the database supplies the context, the language model writes the answer, and you stay in control of what gets sent to it.

Developing in SQL with GitHub Copilot and MCP servers

AI does not only serve end users, it also changes how code gets written. The course shows you how to enable GitHub Copilot and Copilot in Fabric, write instruction files that enforce your conventions, and connect the assistant to MCP servers that reach SQL Server or a Fabric lakehouse.

That productivity boost has a flip side: an assistant wired to a database can see more than it should. The curriculum therefore covers the security impact of these tools, so you keep control over the data they expose.

Securing, tuning and shipping like a software team

A database that feeds an AI application is still a critical database. The course covers encryption with Always Encrypted, dynamic data masking, row-level security, auditing and passwordless access to models through managed identities. On the performance side, you read execution plans, work with Query Store and resolve blocking and deadlocks.

Deployment follows software engineering practice: SQL Database Projects in source control, pull requests, schema drift detection and CI/CD pipelines. Data API builder then exposes your tables, views and stored procedures over REST and GraphQL, with no hand-written API layer.

Microsoft Certified: SQL AI Developer Associate certification

The course prepares you for the DP-800 exam (Developing AI-Enabled Database Solutions), which leads to the Microsoft Certified: SQL AI Developer Associate certification. The exam lasts 120 minutes, requires a score of 700 and covers three areas:

  • designing and developing database solutions (35 to 40%)
  • securing, optimizing and deploying those solutions (35 to 40%)
  • implementing AI capabilities in database solutions (25 to 30%)

The exam is booked with Microsoft and remains optional. ITTA, a Microsoft Learning Partner, delivers this AI-enabled database training with MCT-certified trainers, in Geneva and Lausanne or in a virtual classroom, using official Microsoft courseware.

FAQ

What is the difference between the DP-800 and DP-300 courses?

DP-300 is for administrators: high availability, backups and monitoring of Azure SQL databases. DP-800 is for people who build: data modeling, advanced T-SQL, CI/CD and AI features. The two courses complement each other well within a data team.

DP-800 or DP-420: which course should I choose for an AI application?

It depends on your database. DP-420 builds AI applications on Azure Cosmos DB, a NoSQL database. DP-800 is rooted in SQL Server, Azure SQL and Fabric. If your business data already lives in SQL, DP-800 saves you a migration.

Do I need to know Python to follow the course?

No. AI features are handled from the database, in T-SQL: calling external models, generating embeddings, vector search and RAG. Some background on embeddings and vectors helps but is not essential.

What level of T-SQL do I need before starting?

You should be comfortable writing queries with joins and aggregations. The course then moves quickly to CTEs, window functions, JSON and regular expressions. If you are new to T-SQL, the DP-080 course is good preparation.

Why build RAG in SQL rather than with a separate vector database?

Keeping vectors next to the source data makes synchronization simpler, applies the same security rules and lets you combine relational filters with semantic search in one query. The course gives you the criteria to pick the right approach for your context.

Does the course apply to on-premises SQL Server as well as the cloud?

Yes. The curriculum covers SQL Server, Azure SQL and SQL databases in Microsoft Fabric. From the first module, you learn to choose the right platform and then apply the same techniques on each one.

Prix de l'inscription
CHF 2'350.-
Inclus dans ce cours
  • Training provided by a certified trainer
  • 180 days of access to Official Microsoft Labs
  • Official documentation in digital format
  • Official Microsoft achievement badge
Mois actuel

lun18Jan(Jan 18)09:00mer20(Jan 20)17:00VirtuelVirtual Etiquettes de sessionDP-800T00

lun18Jan(Jan 18)09:00mer20(Jan 20)17:00Genève, Route des Jeunes 35, 1227 Genève Etiquettes de sessionDP-800T00

lun22Fév(Fév 22)09:00mer24(Fév 24)17:00VirtuelVirtual Etiquettes de sessionDP-800T00

lun22Fév(Fév 22)09:00mer24(Fév 24)17:00Lausanne, Av. Mon-Repos 24, 1005 Lausanne Etiquettes de sessionDP-800T00

lun05Avr(Avr 5)09:00mer07(Avr 7)17:00VirtuelVirtual Etiquettes de sessionDP-800T00

lun05Avr(Avr 5)09:00mer07(Avr 7)17:00Genève, Route des Jeunes 35, 1227 Genève Etiquettes de sessionDP-800T00

lun10Mai(Mai 10)09:00mer12(Mai 12)17:00VirtuelVirtual Etiquettes de sessionDP-800T00

lun10Mai(Mai 10)09:00mer12(Mai 12)17:00Lausanne, Av. Mon-Repos 24, 1005 Lausanne Etiquettes de sessionDP-800T00

lun14Juin(Juin 14)09:00mer16(Juin 16)17:00VirtuelVirtual Etiquettes de sessionDP-800T00

lun14Juin(Juin 14)09:00mer16(Juin 16)17:00Genève, Route des Jeunes 35, 1227 Genève Etiquettes de sessionDP-800T00

lun19juil(juil 19)09:00mer21(juil 21)17:00VirtuelVirtual Etiquettes de sessionDP-800T00

lun19juil(juil 19)09:00mer21(juil 21)17:00Lausanne, Av. Mon-Repos 24, 1005 Lausanne Etiquettes de sessionDP-800T00

lun23Aoû(Aoû 23)09:00mer25(Aoû 25)17:00VirtuelVirtual Etiquettes de sessionDP-800T00

lun23Aoû(Aoû 23)09:00mer25(Aoû 25)17:00Genève, Route des Jeunes 35, 1227 Genève Etiquettes de sessionDP-800T00

lun27Sep(Sep 27)09:00mer29(Sep 29)17:00VirtuelVirtual Etiquettes de sessionDP-800T00

lun27Sep(Sep 27)09:00mer29(Sep 29)17:00Lausanne, Av. Mon-Repos 24, 1005 Lausanne Etiquettes de sessionDP-800T00

lun01Nov09:00mer03(Nov 3)17:00VirtuelVirtual Etiquettes de sessionDP-800T00

lun01Nov09:00mer03(Nov 3)17:00Genève, Route des Jeunes 35, 1227 Genève Etiquettes de sessionDP-800T00

lun06Déc(Déc 6)09:00mer08(Déc 8)17:00VirtuelVirtual Etiquettes de sessionDP-800T00

lun06Déc(Déc 6)09:00mer08(Déc 8)17:00Lausanne, Av. Mon-Repos 24, 1005 Lausanne Etiquettes de sessionDP-800T00

Opening hours

Monday to Friday
8:30 AM to 6:00 PM
Tel. 058 307 73 00

Contact-us

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Make a request

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request