Understanding Cloud Spanner
Contact us to book this course
Application Modernization
On-Site, Virtual
3 days
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. The lab culminates with a challenge lab where you demonstrate your knowledge of administering Spanner databases and managing data.
Course objectives
- Build scalable, managed, relational databases using Google Cloud Spanner
- Create and manage Spanner databases using the CLI, Terraform, Python API, and the Cloud Console
- Optimize relational database schemas for Spanner’s distributed database model
- Leverage Google Cloud tools for administering Spanner databases and managing data
- Program and run queries and transactions using the Spanner API
- Integrate Spanner with your applications
Audience
Intermediate-level training for database administrators, engineers/developers, and cloud architects.
Prerequisites
Some prior Google Cloud experience at the fundamental level is assumed. Experience with relational databases, the SQL language, and some programming is also assumed.
Course outline
- What Is Spanner?
- Spanner and the CAP Theorem
- History of Spanner
- Cloud Spanner Use Cases
- Planning Spanner Instances
- Automating Instance Creating
- Creating Databases in Spanner
- Spanner Architecture
- Choosing Primary Keys
- Defining Database Schemas in Spanner
- Understanding Interleaving and Foreign Keys
- Understanding Secondary Indexes
- Authentication and Authorization
- Using the Spanner Client Libraries
- Running Queries
- Managing Transactions
- Using Spanner from Applications
- Building Data Pipelines Into and Out of Spanner
- Managing Your Data in Spanner
- Managing Change
- Operations
- Spanner Best Practices
- Capstone Project
