Deploy a Fully Managed and Scalable SQL Database With Google Cloud Spanner
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.
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
- 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
Basic knowledge of SQL is appreciated but not required. You could follow the following labs:
April 6th, 2022 - Updated the instructions and screenshots to reflect the latest UI
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.