DP-800 study planner

Your session schedule

1. 1
   WEEK 1 · 45 MINUTESDatabase design & T-SQL

   Build a small schema with constraints and indexes

2. 2
   WEEK 1 · 45 MINUTESSecurity, performance & deployment

   Compare masking, encryption, and row-level security

3. 3
   WEEK 1 · 45 MINUTESDatabase design & T-SQL

   Write a JSON-to-rows query and test invalid input

4. 4
   WEEK 1 · 45 MINUTESSecurity, performance & deployment

   Inspect a slow query plan and Query Store evidence

5. 5
   WEEK 1 · 45 MINUTESAI, embeddings & search

   Explain exact versus approximate vector search

6. 6
   WEEK 2 · 45 MINUTESDatabase design & T-SQL

   Practice a stored procedure with error handling

7. 7
   WEEK 2 · 45 MINUTESSecurity, performance & deployment

   Review a SQL project deployment and schema drift

8. 8
   WEEK 2 · 45 MINUTESDatabase design & T-SQL

   Review a query using window functions

9. 9
   WEEK 2 · 45 MINUTESSecurity, performance & deployment

   Trace a database API request and its permissions

10. 10
    WEEK 2 · 45 MINUTESAI, embeddings & search

    Design an embedding refresh process