hands-on lab

Deploy a Fully Managed and Scalable SQL Database With Google Cloud Spanner

Beginner
Up to 45m
361
5/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.

Description

If you are a data engineer or a cloud architect, you probably need to design and deploy a SQL database solution. SQL databases are the most commonly used because of the power of the data model they follow: the relational data model. By choosing an SQL database, you can perform operations matching different tables using joins, and you can perform transactions that follow the ACID (Atomicity Consistency Independency Durability) pattern.

Because of that importance, it's also important to have highly reliable and scalable SQL databases. Google Cloud offers Cloud Spanner. It is a fully managed and unlimited scale SQL database that allows you to deploy your production-ready solution within minutes. Cloud Spanner is ready to scale from very few transactions to globally executed operations. It also provides you automatic sharding for the data, so you can distribute them between different nodes and leverage them for queries and other operations in the most efficient way.

In this lab, you will create a Google Cloud Spanner instance with a single node, you will create a database and specify the schema for a table, and you will execute some SQL statements on that table.

Learning Objectives

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

  • Create a Google Cloud Spanner instance
  • Set up a database with its own schema
  • Execute SQL statements on the Cloud Spanner database

Intended Audience

  • Google Cloud Professional Data Engineer (PDE) candidates
  • Data engineers who want to release a fully managed and scalable SQL database solution
  • Individuals that want to understand how to leverage Cloud Spanner to deliver production-ready solutions

Prerequisites

Basic knowledge of SQL is appreciated but not required. You could follow the following labs:

Updates

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

Environment before

Environment after

About the author

Students
40,931
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
Creating a Google Cloud Spanner Instance
Creating a SQL Database and Its Schema
Performing Some SQL Statements in the Cloud Spanner Database