AdvancedAzure SQL AI Developer project · about 18 hours

Retrieval-augmented app on Azure SQL

Build a RAG assistant that answers from data in Azure SQL, with security and monitoring.

The real-world brief

A support team wants answers drawn from product manuals and order data stored in Azure SQL.

What you will build

  • Chunked manuals with embeddings in SQL
  • An API that retrieves and answers with sources
  • Row-level security per customer
  • Monitoring and an evaluation set

Skills you will practise

RAGData securityPromptingMonitoring

Tools

Azure SQLAzure OpenAIRow-level securityAzure FunctionsApplication Insights

Project tasks

The detailed steps, checklists and trainer review open in the SOTT student portal for enrolled students.

1Chunk and embed Steps in portal
2Answer Steps in portal
3Secure Steps in portal
4Evaluate Steps in portal
5Monitor Steps in portal

How companies use Azure SQL AI Developer

E-commerce: Checkout that stays fast at sale time. Slow queries made checkout time out during sales. Indexes, query tuning and read replicas for reports. Checkout stayed fast through the biggest sale.

Banking: No data lost in an outage. Nobody had tested restoring the core database. Automated backups, point-in-time restore and regular restore drills. A restore drill met the agreed recovery time.

Insurance: Faster answers from policy documents. Agents searched long PDFs to answer customer questions. A retrieval-augmented assistant answers with citations to the exact clause. Handling time fell and answers became consistent.

Questions

Can I add the Retrieval-augmented app on Azure SQL project to my resume?

Yes. Once your trainer approves it, list it under Projects with the tools you used, one line on the problem it solves and a link to your repository and demo video.

How long does this project take?

About 18 hours of hands-on work, and it fits best after week 12 of the Azure SQL AI Developer (DP-800) course.

Where do I get the step-by-step tasks?

Enrolled students get every task with steps, "done when" checks, the submission form and a trainer review in the SOTT student portal.