Understanding Cloud Spanner
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.
- Duration: 3 days
- Languages: English, German
- Level: Intermediate
- Group size: Up to 16
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.
Prerequisites
- Some prior Google Cloud experience at the fundamental level.
- Experience with relational databases and the SQL language.
- Some prior programming experience is assumed.
Course outline
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
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
- Backup, restore, import, and export data
- Modifying database schemas with no downtime
- Monitoring Cloud Spanner databases and applications
Spanner Best Practices
- Spanner Best Practices
- Challenge Lab: Administering a Spanner Database
Related courses
AlloyDB Essentials
This course explores the benefits of AlloyDB, especially compared to PostgreSQL on Cloud SQL. It will walk you through AlloyDB’s unique architecture, and explain how to configure deployments on Google Cloud.The course is divided into two parts: AlloyDB Administration Essentials (architecture and configuration) and AlloyDB Optimization Essentials (performance tuning).
BigQuery for Data Analysts
This course is designed for data analysts who want to learn about using BigQuery for their data analysis needs. Through a combination of videos, labs, and demos, we cover various topics that discuss how to ingest, transform, and query your data in BigQuery to derive insights that can help in business decision-making.
Data Engineering on Google Cloud
Get hands-on experience with designing and building data processing systems on Google Cloud. This course uses lectures, demos, and hands-on labs to show you how to design data processing systems, build end-to-end data pipelines, analyze data, and implement machine learning. This course covers structured, unstructured, and streaming data.
Not sure which course fits?
Book a 30-minute call. We'll look at where your team is, what they need to be able to do, and put together either a specific course date or a tailored learning plan.