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

Lab Steps

lock
Signing In to the Google Cloud Console
lock
Creating a Google Cloud Spanner Instance
lock
Creating a SQL Database and Its Schema
lock
Performing Some SQL Statements in the Cloud Spanner Database

The hands-on lab is part of these learning paths

Ready for the real environment experience?

DifficultyBeginner
Time Limit45m
Students165
Ratings
5/5
starstarstarstarstar

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
PREVIEW
arrow_forward
Environment after
PREVIEW
About the Author
Students32332
Labs106
Courses2
Learning paths8

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.