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

Project Description

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.

Requirements

  • Microsoft Azure Account

    Solution Architecture

    Tools & Technology

    • Resource Group
    • Azure Database for PostgreSQL
    • Schema App

    Project Implementation Phases

    1 – Create a Azure Database for PostgreSQL

    2 – Download pgAdmin utility to connect to the database created in Azure

    3 – Create a new database, a new schema and a new table; test data entry