Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Google

Manage PostgreSQL Databases on Cloud SQL

Google via Qwiklabs

Overview

Earn a skill badge by completing the Manage PostgreSQL Databases on Cloud SQL quest, where you will learn how to migrate, configure and optimize running a PostgreSQL database on Cloud SQL for PostgreSQL. A skill badge is an exclusive digital badge issued by Google Cloud in recognition of your proficiency with Google Cloud products and services and tests your ability to apply your knowledge in an interactive hands-on environment. Complete this skill badge quest, and the final assessment challenge lab, to receive a skill badge that you can share with your network.

Syllabus

  • Migrate to Cloud SQL for PostgreSQL using Database Migration Service
    • In this lab you migrate a stand-alone PostgreSQL database (running on a virtual machine) to Cloud SQL for PostgreSQL using a continuous Database Migration Service job and VPC peering for conectivity
  • Connect an App to a Cloud SQL for PostgreSQL Instance
    • In this lab you will create a Kubernetes cluster and deploy a simple application to that cluster. Then, connect the application to the supplied Cloud SQL for PostgreSQL database instance and confirm that it is able to write to and read from it.
  • Securing a Cloud SQL for PostgreSQL Instance
    • In this lab you will deploy a new Cloud SQL instance using a customer-managed encryption key (CMEK). You will configure pgAudit to selectively record and track SQL operations performed against that instance, then you will configure and test Cloud SQL IAM database authentication.
  • Configure Replication and Enable Point-in-Time-Recovery for Cloud SQL for PostgreSQL
    • In this lab you will configure and test point-in-time recovery for a Cloud SQL for PostgreSQL instance.
  • Manage PostgreSQL Databases on Cloud SQL: Challenge Lab
    • In this challenge lab you will demonstrate your knowledge of Cloud SQL for PostgreSQL that you learned from the Manage PostgreSQL Databases on Cloud SQL quest.

Reviews

Start your review of Manage PostgreSQL Databases on Cloud SQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.