Microsoft · AI-200
PostgreSQL, connect, model, and index
AI-200 · Lesson 6 of 13 · 40:32
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the AI-200 exam (Microsoft Certified: Azure AI Cloud Developer Associate). In this lesson: secure connections to Azure Database for PostgreSQL with Microsoft Entra tokens and TLS, psycopg 3, parameterized queries, and connection pools, tables and data types like JSONB and TIMESTAMPTZ, foreign keys, and B-tree and GIN indexes. Includes three original practice questions.
Preview the topics
- A Python API builds its SQL with an f-string that inserts the user’s search text. A security review flags it. What should the developers do?
- Each conversation stores model settings whose fields differ from one agent to the next, and queries must filter on them efficiently. Which column type fits?
- A messages table has an index on (conversation_id, created_at). A new report filters only on created_at, and it runs slowly. Why?