In this course, you learn about Cloud Spanner. You will get an introduction to Cloud Spanner and understand how it differs from other database products. You also learn when and how to use Cloud Spanner to solve your relational database needs at scale.

What you'll learn

• Build scalable, managed, relational databases by using Cloud Spanner.
• Create and manage Cloud Spanner databases by using the CLI, Terraform, Python API, and the Google Cloud console.
• Program and run queries and transactions by using the Cloud Spanner API
• Integrate Cloud Spanner with applications.

Who this course is for

Customers

Products

• Cloud Spanner
• Cloud Functions
• Cloud Run
• Dataflow

Prerequisite

Some prior Google Cloud experience at the fundamental level and experience with relational databases, the SQL language, and some programming are assumed.

Course Modules

The Need for Spanner

• What is Spanner?
• Spanner and the CAP Theorem
• History of Spanner
• Cloud Spanner Use Cases

Getting Started with Spanner

• Planning Spanner Instances
• Automating Instance Creating
• Creating Databases in Spanner

Optimizing Spanner Schemas

• Spanner Architecture
• Choosing Primary Keys
• Defining Database Schemas in Spanner
• Understanding Interleaving and Foreign Keys
• Understanding Secondary Indexes

Programming Spanner Applications, Queries, and Transactions

• Authentication and Authorization
• Using the Spanner Client Libraries
• Running Queries
• Managing Transactions

Deploying Spanner Applications

• Using Spanner from Applications
• Building Data Pipelines into and out of Spanner

Spanner Administration

• Managing your Data in Spanner
• Managing Change Operations

Spanner Best Practices

• Spanner Best Practices
• Challenge Lab