DP-800 preparation focuses on designing, securing, optimizing, deploying, and extending AI-enabled database solutions across SQL Server, Azure SQL, and SQL databases in Microsoft Fabric. The course develops practical knowledge of database objects, advanced T-SQL, GitHub CI/CD, SQL Database Projects, Data API Builder, intelligent search, embeddings, and RAG patterns aligned with the current Microsoft exam objectives.
Prerequisites
- T-SQL Programming
- Microsoft SQL Server Database Development
- Azure SQL Database Knowledge
- Microsoft Fabric SQL Database Knowledge
- GitHub CI/CD Fundamentals
- AI-Assisted Development Tools
- AI Fundamentals
- embeddings and Vector Concepts
What Will You Learn
- Design and Implement SQL Database Objects
- Build Tables, Constraints, Indexes, and Partitions
- Develop Views, Functions, Stored Procedures, and Triggers
- Write Advanced T-SQL with CTEs and Window Functions
- Work with JSON, Regular Expressions, Fuzzy Matching, and Graph Queries
- Use GitHub Copilot and Microsoft Copilot in Fabric
- Connect SQL and Fabric Solutions to MCP Servers
- Implement Encryption, Dynamic Data Masking, RLS, and Auditing
- Optimize Query Performance with Query Store, DMVs, and Execution Plans
- Build CI/CD Pipelines with SQL Database Projects
- Configure Data API Builder for REST and GraphQL
- Implement embeddings Function and Intelligent Search
- Build Vector, Semantic, and Hybrid Search
- Design Retrieval-Augmented Generation (RAG) Solutions
- Integrate SQL Data with Language Models
Who Can Join This Training
- SQL Developers
- Database Developers
- Database Administrators
- Data Engineers
- Azure SQL Professionals
- Microsoft Fabric Professionals
- Application Developers
- Data Architects
- AI Engineers Working with SQL
- DevSecOps Engineers
Is This the Right Certification for You?
This certification is a strong fit when you already work with SQL and want to add AI capabilities to database solutions. You should have experience writing T-SQL and developing databases on Microsoft SQL platforms, along with familiarity with GitHub CI/CD, AI-assisted development, embeddings, vectors, and models.
You will be a good fit if you want to:
- Build AI-enabled database solutions without moving away from SQL
- Add vector and semantic search to SQL applications
- Implement RAG patterns with SQL data
- Secure and optimize enterprise database solutions
- Use AI-assisted development tools with SQL
- Work with Azure SQL, SQL Server, and Microsoft Fabric
Tools and Technologies Covered
- Microsoft SQL Server
- Azure SQL
- Microsoft Fabric
- T-SQL
- SQL Database Projects
- GitHub
- GitHub Copilot
- Microsoft Copilot in Fabric
- Model Context Protocol (MCP)
- Data API Builder
- Azure Monitor
- Application Insights
- Log Analytics
- Azure Functions
- Azure Logic Apps
- Azure AI Foundry
- Query Store
- Dynamic Management Views (DMVs)
- Always Encrypted
- Dynamic Data Masking
- Row-Level Security (RLS)
- Vector Search
- Semantic Search
- Hybrid Search
- embeddings Function
- Retrieval-Augmented Generation (RAG)
