GOOGLE CLOUD
Understanding Cloud Spanner
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.
What you will learn
1.
Build scalable, managed, relational databases using Google Cloud Spanner
2.
Create and manage Spanner databases using the CLI, Terraform, Python API, and the Cloud Console
3.
Optimize relational database schemas for Spanner's distributed database model
4.
Leverage Google Cloud tools for administering Spanner databases and managing data
5.
Program and run queries and transactions using the Spanner API
6.
Integrate Spanner with your applications
Level
Intermediate
Duration
3 x 8 hour sessions
Language
Delivered in English
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.
Who this course is for
Database administrators, engineers/developers, and cloud architects who want to learn how to create, optimize, and manage Spanner databases and migrate existing databases into Spanner.
Course TOPICS
1: The Need for Spanner
🔸What is Spanner?
🔸Spanner and the CAP Theorem
🔸History of Spanner
🔸Cloud Spanner Use Cases
2: Getting Started with Spanner
🔸Planning Spanner Instances
🔸Automating Instance Creating
🔸Creating Databases in Spanner
3: Optimizing Spanner Schemas
🔸Spanner Architecture
🔸Choosing Primary Keys
🔸Defining Database Schemas in Spanner
🔸Understanding Interleaving and Foreign Keys
🔸Understanding Secondary Indexes
4: Programming Spanner Applications, Queries, and Transactions
🔸Authentication and Authorization
🔸Using the Spanner Client Libraries
🔸Running Queries
🔸Managing Transactions
5: Deploying Spanner Applications
🔸Using Spanner from Applications
🔸Building Data Pipelines into and out of Spanner
6: Spanner Administration
🔸Managing your Data in Spanner
🔸Managing Change
🔸Operations
7: Capstone Project
🔸Spanner Best Practices
🔸Capstone Project
Course Dates
Not currently scheduled.
Sign up to be notified when next dates are scheduled.
Ref: T-GCPFCI-B-02
Have questions?
No worries. Send us a quick message and we'll be happy to answer any questions you have.
© Copyright 2023. Axalon. All rights reserved.
