Understanding Cloud Spanner (UCS) - Lab Topology

Creating Spanner Instances and Databases (Console)

• Compare Spanner configuration options.
• Create Spanner databases using the Console.
• Create Spanner databases using the PostgreSQL dialect.

Creating Spanner Instances and Databases (CLI and Terraform)

• Create instances and databases using the gcloud CLI.
• Automate Spanner infrastructure using Terraform.

Choosing Primary Keys

• Generate Spanner primary keys as UUIDs.
• Convert counters and timestamps into values appropriate for Spanner primary keys.

Managing Relationships with Foreign Keys and Interleaved Tables

• Create a relational database with proper primary keys and relationships optimized for Spanner
• Leverage indexes to improve read performance in Spanner

Programming Spanner Applications with Python

• Use Python to create and delete Spanner instances and databases.
• Program Spanner databases that use the PostgreSQL dialect.

Running Queries and Transactions

• Run parameterized queries using indexes against a Spanner database using the Python Client library.
• Execute transactions against a Spanner database.

Deploying Spanner Applications with Cloud Functions and Cloud Run

• Deploy Cloud Functions that read and write to Spanner databases.
• Set up and use the Spanner emulator for development.
• Build a REST API that allows you to read and write Spanner data.
• Deploy a REST API to Google Cloud Run.

Migrating Data to and from Spanner with Dataflow

• Write ETL pipelines using Apache Beam.
• Run Apache Beam pipelines using Google Cloud Dataflow.

Leverage the Autoscaler Tool for Cloud Spanner to Achieve Workload Elasticity

• Configure the Autoscaler and environment
• Deploy the Autoscaler
• Observe the autoscaling

Challenge Lab: Administering a Spanner Database

• Create a Spanner database and import existing data.
• Backup and restore the database.
• Export Spanner data and import it into BigQuery.
• Deploy a data access API that allows access to your Spanner database.
• Use the Operations monitoring tools for dashboards, uptime checks, and alerts.