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.