Develop AI-enabled database solutions (DP-800T00)
Contact us to book this course
On-Site, Virtual
3 days
Learning Objectives
-
Design and implement scalable database solutions across SQL platforms
-
Develop advanced T-SQL queries using CTEs, window functions, and JSON
-
Integrate AI capabilities such as embeddings and vector search into databases
-
Implement database security, compliance, and performance optimization techniques
-
Build and deploy database solutions using CI/CD pipelines and DevOps practices
-
Develop AI-powered applications using RAG and AI-assisted tools like GitHub Copilot
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.
Prerequisites
- Experience writing T-SQL queries.
- Familiarity with SQL Server or Azure SQL Database.
- Basic understanding of security concepts like authentication and authorization.
- Experience with Git version control and CI/CD concepts.
Course outline
Design and implement database objects with SQL
Exercise - Create and maintain database objects
Implement programmability objects with SQL
Exercise: Implement programmability objects in SQL Server
Write advanced T-SQL code
Exercise - Work with JSON functions
Implement SQL solutions using AI-assisted tools
Exercise - Configure AI-assisted tools for database development
Implement data security and compliance with SQL
Exercise: Implement security features
Optimize database performance
Exercise: Optimize query performance
Implement CI/CD by using SQL Database Projects
Exercise: Implement CI/CD by using SQL Database Projects
Integrate SQL solutions with Azure services
Exercise - Configure Data API Builder for a product catalog
Design and implement models and embeddings with SQL
Exercise - Generate and update embeddings in Azure SQL Database
Design and implement intelligent search with SQL
Exercise - Implement intelligent search with full-text, vector, and hybrid queries
Design and implement RAG with SQL
Exercise: Implement a RAG solution
