Google Cloud SQL is an easy-to-use fully managed service that allows you to configure and maintain SQL, MySQL, and PostgreSQL databases. You simply create the database cluster you want before moving on to creating tables and making queries. Updates, patches, backups, and replication are all taken care of automatically. Furthermore, you won’t need to worry about data encryption; Google Cloud SQL does it for you. For more information about what Cloud SQL provides, follow this link.

In this lab, you will create two tables in a provided Cloud SQL PostgreSQL database. You will also perform operations on it, monitor the resources usage and test that the atomicity property is respected by the database.

Learning Objectives

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

• Establish a connection to a Cloud SQL database
• Perform operations on the database
• Monitor the resource usage of the Cloud SQL database

Intended Audience

This lab is intended for:

• Google Cloud Associate Cloud Engineer (ACE) certification candidates
• Individuals that are familiar with SQL and databases who want to know more about big data solutions

Prerequisites

Basic knowledge of SQL is required. If you don't have too much experience with SQL, you can follow this lab first: Run your first SQL Queries

Updates

June 28th, 2023 - Resolved deployment issue

March 10th, 2023 - Updated the instructions and screenshots to reflect the latest UI

April 5th, 2022 - Updated the instructions and screenshots to reflect the latest UI

March 21st, 2022 - Updated instructions and screenshots

Feb 28th, 2022 - Increase allotted time to account for database provisioning and provide additional documentation references

Nov 4th, 2021 - Updated instructions to address formatting issue with the SQL code