hands-on lab

Interact With PostgreSQL Flexible Server Using a Python-Based Web App

Difficulty: Intermediate
Duration: Up to 1 hour
Students: 38
This lab is currently under maintenance. You can start the lab, but some instructions and screenshots may be inaccurate. We are actively working to resolve this issue and we apologize for any inconvenience.
Get guided in a real environmentPractice with a step-by-step scenario in a real, provisioned environment.
Learn and validateUse validations to check your solutions every step of the way.
See resultsTrack your knowledge and monitor your progress.

Description

Azure PostgreSQL is a fully-managed relational database service offered by Microsoft Azure. It is a powerful, scalable, and highly available database service that provides enterprise-level features and security. It comes with a simple and intuitive web-based interface that makes it easy to create and manage databases. Additionally, it offers built-in security features, such as firewall rules and SSL support, to ensure that your data is safe and secure.

Using PostgreSQL with Python Django app is also quite beneficial. Django is a high-level Python web framework that makes it easy to build web applications quickly. By using PostgreSQL with Django, you get access to the full range of PostgreSQL's features, such as advanced indexing, data types, and query optimizations. This allows you to build robust and scalable applications that can handle large amounts of data and high levels of traffic.

In this hands-on lab, you will interact with PostgreSQL resource using an Azure Web App running a Python-Django application.

Learning objectives

Upon completion of this intermediate-level lab, you will be able to:

  • Understand PostgreSQL resource
  • Understand Azure CLI commands to upload zip packages to web app
  • Add application settings to the web app

Intended audience

  • Candidates for Azure Administrator Exam (AZ-104)
  • Cloud Architects
  • Data Engineers
  • DevOps Engineers
  • Software Engineers

Prerequisites

Familiarity with the following will be beneficial but is not required:

  • Azure App Service
  • Azure CLI
  • Python

The following content can be used to fulfill the prerequisites:

Updates

November 02, 2023: Updated UI and instructions to match the new changes in the Portal

Environment before

Environment after

Covered topics

Lab steps

Logging in to the Microsoft Azure Portal
Creating PostgreSQL Flexible Server using Azure Portal
Logging into Azure using Azure CLI
Uploading Django App on Azure Web App