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.
- Microsoft Azure Account
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