Run SQL Queries and Analyze the DB with Google Cloud SQL

The hands-on lab is part of this learning path

Lab Steps

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

Ready for the real environment experience?

DifficultyIntermediate
Max Duration45m
Students12
Ratings
5/5
star star star star star

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

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

Environment before
PREVIEW
arrow_forward
Environment after
PREVIEW

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.