In this course you will learn about Cloud Spanner. You will get an introduction to Cloud Spanner, contrasting it with other Database products to understand when and how to use Spanner to solve your relational database needs at scale. You will learn how to create and manage Spanner databases using various tools on Google Cloud, learn to optimize relational schemas with Spanner’s distributed database model in mind, interact with your Spanner databases using the Spanner APIs, integrate Spanner with your applications, and learn how to use other Google tools for administering Spanner databases and managing your data.
Overview
Syllabus
- Introduction
- Introduction
- The Need for Spanner
- What is Spanner?
- History
- Use Cases
- Quiz
- Getting Started with Spanner
- Planning Spanner Instances
- Automating Instance Creation
- Creating Databases
- Pluralsight: Getting Started with GCP and Qwiklabs
- Creating Spanner Instances and Databases (Console)
- Creating Spanner Instances and Databases (CLI and Terraform)
- Quiz
- Optimizing Spanner Schemas
- Spanner Architecture
- Choosing Primary Keys
- Choosing Primary Keys
- Defining Database Schemas
- Managing Relationships with Foreign Keys and Interleaved Tables
- Quiz
- Programming Spanner Applications, Queries, and Transactions
- Authentication and Authorization
- Using the Language APIs
- Programming Spanner Applications with Python
- Running Queries
- Managing Transactions
- Running Queries and Transactions
- Quiz
- Deploying Spanner Applications
- Using Spanner from Applications
- Deploying Spanner Applications with Cloud Run Functions and Cloud Run
- Building Data Pipelines
- Migrating Data to and from Spanner with Dataflow
- Quiz
- Spanner Administration
- Administering Spanner Instances
- Managing Data
- Managing Change
- Reconciling Account Data with Cloud Spanner Change Streams
- Operations
- Leverage the Autoscaler Tool for Cloud Spanner to Achieve Workload Elasticity
- Quiz
- Your Next Steps
- Course Badge
