Build and query with Azure Database for PostgreSQL

  • Module
  • 9 Units
Intermediate
Developer
Azure Database for PostgreSQL

Learn how to use Azure Database for PostgreSQL to build data foundations for AI applications. Design schemas, write efficient queries, and integrate with Python applications using secure authentication.

Learning objectives

After completing this module, you'll be able to:

  • Explain the architecture and key features of Azure Database for PostgreSQL
  • Establish secure connections to PostgreSQL using Microsoft Entra authentication and TLS
  • Create and manage database schemas including tables, indexes, and constraints
  • Write efficient SQL queries for common data operations
  • Integrate Azure Database for PostgreSQL into applications using Python

Prerequisites

Before beginning this module, you should have:

  • Programming experience with Python.
  • Basic understanding of Azure services and cloud computing concepts.
  • Familiarity with relational databases and SQL fundamentals.
Start