Introduction to Cloud and Azure

Azure Resource Management

Azure Data Lake Storage (ADLS)

Azure PostgreSQL Databases

Azure Container Apps

Deploying and Storing Results

Practice

Assignment

Gotchas & Pitfalls

Week 6 Lesson Plan (Teachers)

Azure PostgreSQL Databases

Content coming soon...

Suggested Topics

• Azure Database for PostgreSQL Flexible Server: what it is and when to use it
• Creating a database instance in the Azure portal
• Connection strings: host, port, database name, SSL settings
• User management: creating users with least-privilege access
• Firewall rules: allowing connections from your IP and Azure services
• Connecting from Python: psycopg2 and SQLAlchemy connection patterns
• Running queries and verifying data with psql or Azure Data Studio
• Security basics: avoiding admin accounts for applications, rotating passwords
• Cost management: choosing the right tier and scaling options
• Passwordless authentication: connecting to Azure PostgreSQL using Managed Identity (Entra ID) instead of username/password
• Granting the Container App's Managed Identity appropriate roles on the database

The HackYourFuture curriculum is licensed under CC BY-NC-SA 4.0

*https://hackyourfuture.net/*

Found a mistake or have a suggestion? Let us know in the feedback form.