TrainingData & analytics / Data & AIDP-800
DP-800Microsoft · authorised trainingLeads to an exam
Develop AI-enabled database solutions
This course shows how to design and build AI-enabled database solutions across Microsoft SQL platforms, including SQL Server, Azure SQL, and SQL databases in Microsoft Fabric. Participants learn both classic T-SQL and database programmability topics, as well as newer vector-based, semantic search and RAG patterns. The course also covers security, performance optimization, and deployment and integration of SQL solutions with Azure services.
- Duration
- 3 days
- Level
- Intermediate
- Provider
- Microsoft
- Topic
- Data & analytics / Data & AI
Course outline
- Learning path: Design and develop database solutions
- Design and implement database objects with SQL
- Implement programmability objects with SQL (views, stored procedures, functions, triggers)
- Write advanced T-SQL code (CTEs, window functions, JSON, regular expressions, fuzzy string matching, graph queries, error handling)
- Implement SQL solutions by using AI-assisted tools (GitHub Copilot, Fabric Copilot)
- Learning path: Secure, optimize, and deploy database solutions
- Implement data security and compliance with SQL (encryption, masking, Row-Level Security, auditing)
- Optimize database performance (isolation levels, execution plans, DMVs, Query Store, blocking and deadlocks)
- Implement CI/CD by using SQL database projects (source control, branching, schema drift detection, GitHub Actions, Azure DevOps)
- Integrate SQL solutions with Azure services (Data API Builder, REST, GraphQL, monitoring, event-driven patterns)
- Learning path: Implement AI capabilities in database solutions
- Design and implement models and embeddings with SQL
- Design and implement intelligent search with SQL (full-text, vector, and hybrid search)
- Design and implement RAG with SQL
Skills you will gain
- Designing and implementing database objects and programmability objects with SQL
- Writing advanced T-SQL code, including JSON functions, graph queries, and error handling
- Using AI-assisted tools (GitHub Copilot, Fabric Copilot) for SQL database development
- Implementing data security and compliance in SQL Server, Azure SQL, and Microsoft Fabric
- Optimizing database performance and implementing CI/CD for SQL database projects
- Integrating SQL solutions with Azure services, including building REST and GraphQL APIs
- Designing and implementing AI models and embeddings with SQL
- Implementing intelligent search and Retrieval Augmented Generation (RAG) patterns with SQL
Who should attend
- 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
- Professionals who develop database solutions that include structured and semi-structured data and integrate AI features into scalable enterprise applications
Certification
Exam
DP-800 - Microsoft Certified: SQL AI Developer Associate
This course prepares you for this exam.
3200 PLN
Ask about dates