PostgreSQL database deployment with knowledge transfer to on-premises DBAs team using Microsoft Azure Database for PostgreSQL Servers.

In another project based on a real-world scenario, I acted as a Cloud Specialist to show a team of on-premises DBAs how to provision a PostgreSQL database on Microsoft Azure.

I supported the deployment and showed the step-by-step to create the database service in Microsoft Azure. I shared how the connection to the database service in Azure worked, what were the steps of creating a new database, a new schema, and a new table. Also, I instructed them how to insert new records and query data in the table.

Provisioned PostgreSQL database on Microsoft Azure.

Installed Pg Admin 4 v6 on my personal laptop

Created a database db01 and a table name Employees with two columns Employee_ID and Employee_Name in the schema app01.

Inserted record into the table

All these tasks took less than 10 minutes. Wonderful! We can see the power of Microsoft Azure!!!