Cloud Academy

Run SQL Queries and Analyze the DB with Google Cloud SQL

Lab Steps

Signing In to Google Cloud Console
Starting a Google Cloud Shell
Connecting to the Cloud SQL Database
Performing Operations on the Cloud SQL Database
Monitoring the Cloud SQL Instance
Confirming That Atomicity Property of ACID Properties Is Respected
Creating a Snapshot of the Cloud SQL Database

The hands-on lab is part of this learning path

Ready for the real environment experience?

Time Limit45m
star star star star star


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, backup, 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


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

Environment before
Environment after

About the Author

Stefano studies Computer Science and is passionate about technology. He loves working with Cloud services and learning all the best practices for them. Amazon Web Services is the provider he prefers and Node.js the programming language he always uses to code. When he's not involved in studying or working, Stefano loves riding his motorbike and exploring new places.