hands-on lab

Run SQL Queries and Analyze Data with Google Cloud SQL

Intermediate
1h 15m
2,173
4.2/5
Get guided in a real environmentPractice with a step-by-step scenario in a real, provisioned environment.
Learn and validateUse validations to check your solutions every step of the way.
See resultsTrack your knowledge and monitor your progress.
Lab description

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

Environment before
Environment after
About the author
Avatar
Stefano Cascavilla
Junior Data Engineer
Students
39,897
Labs
106
Courses
2
Learning paths
10

Stefano studies Computer Science and is passionate about technology. He loves working with Cloud services and learning all the best practices for them. Google Cloud Platform and Amazon Web Services are the cloud providers he prefers. He is a Google Cloud Certified Associate Cloud Engineer. Node.js is 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.

Covered topics
Lab steps
Signing In to the Google Cloud Console
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