Google Cloud Logo

Understanding Cloud Spanner

Google Cloud Logo

This course provides a thorough introduction to Cloud Spanner, Google Cloud's fully managed, horizontally scalable, and highly available relational database. You will learn how Spanner differs from other database solutions and in which scenarios it particularly excels.

We will show you how to create and manage Spanner databases using various tools in Google Cloud, optimize relational schemas for Spanner's distributed database model, and efficiently access your data using the Spanner APIs. You will also learn how to seamlessly integrate Spanner into your applications and how other Google Cloud tools can help you with administration and data management.

The course concludes with an exercise in which you apply and deepen your acquired knowledge of managing Spanner databases and data structures.

Course Contents

  • The need for Spanner
  • Getting started with Spanner
  • Optimizing Spanner schemas
  • Programming Spanner applications, queries, and transactions
  • Deploying Spanner applications
  • Spanner administration
  • Final project
Request in-house training now

Target Group

  • Database administrators who want to create, optimize and manage Spanner databases
  • Developers/engineers who want to integrate Spanner into applications and use it with high performance
  • Cloud architects who are planning scalable database solutions and want to migrate existing systems to Spanner

Knowledge Prerequisites

  • Basic experience with Google Cloud
  • Knowledge of relational databases
  • Experience with SQL
  • Basic programming knowledge

Course Objective

  • Create scalable, managed relational databases with Google Cloud Spanner
  • Create and manage Spanner databases using CLI, Terraform, Python API, and the Cloud Console
  • Optimize relational database schemas for Spanner's distributed database model
  • Use Google Cloud tools to manage Spanner databases and data
  • Program and execute queries and transactions using the Spanner API
  • Integrate Spanner into your applications
Der Bedarf an Spanner
Zielsetzungen:
Was ist Spanner?
Spanner und das CAP-Theorem
Geschichte von Spanner
Cloud Spanner Anwendungsfälle
Erste Schritte mit Spanner
Zielsetzungen:
Planung von Spanner-Instanzen
Automatisieren der Instanzerstellung
Erstellen von Datenbanken in Spanner
Optimierung von Spanner-Schemata
Zielsetzungen:
Spanner-Architektur
Auswahl von Primärschlüsseln
Definieren von Datenbankschemata in Spanner
Verstehen von Verschachtelung und Fremdschlüsseln
Verstehen von Sekundärindizes
Programmierung von Spanner-Anwendungen, -Abfragen und -Transaktionen
Zielsetzungen:
Authentifizierung und Autorisierung
Verwendung der Spanner Client-Bibliotheken
Laufende Abfragen
Verwaltung von Vorgängen
Bereitstellung von Spanner-Anwendungen
Zielsetzungen:
Spanner aus Anwendungen verwenden
Aufbau von Datenpipelines in und aus Spanner
Spanner-Verwaltung
Zielsetzungen:
Verwaltung Ihrer Daten in Spanner
Bewältigung des Wandels
Betrieb
Abschlussprojekt
Zielsetzungen:
Bewährte Praktiken für Schraubenschlüssel
Schlussstein-Projekt

Classroom training

Do you prefer the classic training method? A course in one of our Training Centers, with a competent trainer and the direct exchange between all course participants? Then you should book one of our classroom training dates!

Online training

You wish to attend a course in online mode? We offer you online course dates for this course topic. To attend these seminars, you need to have a PC with Internet access (minimum data rate 1Mbps), a headset when working via VoIP and optionally a camera. For further information and technical recommendations, please refer to.

Tailor-made courses

You need a special course for your team? In addition to our standard offer, we will also support you in creating your customized courses, which precisely meet your individual demands. We will be glad to consult you and create an individual offer for you.
Request in-house training now
PDF SymbolYou can find the complete description of this course with dates and prices ready for download at as PDF.

This course provides a thorough introduction to Cloud Spanner, Google Cloud's fully managed, horizontally scalable, and highly available relational database. You will learn how Spanner differs from other database solutions and in which scenarios it particularly excels.

We will show you how to create and manage Spanner databases using various tools in Google Cloud, optimize relational schemas for Spanner's distributed database model, and efficiently access your data using the Spanner APIs. You will also learn how to seamlessly integrate Spanner into your applications and how other Google Cloud tools can help you with administration and data management.

The course concludes with an exercise in which you apply and deepen your acquired knowledge of managing Spanner databases and data structures.

Course Contents

  • The need for Spanner
  • Getting started with Spanner
  • Optimizing Spanner schemas
  • Programming Spanner applications, queries, and transactions
  • Deploying Spanner applications
  • Spanner administration
  • Final project
Request in-house training now

Target Group

  • Database administrators who want to create, optimize and manage Spanner databases
  • Developers/engineers who want to integrate Spanner into applications and use it with high performance
  • Cloud architects who are planning scalable database solutions and want to migrate existing systems to Spanner

Knowledge Prerequisites

  • Basic experience with Google Cloud
  • Knowledge of relational databases
  • Experience with SQL
  • Basic programming knowledge

Course Objective

  • Create scalable, managed relational databases with Google Cloud Spanner
  • Create and manage Spanner databases using CLI, Terraform, Python API, and the Cloud Console
  • Optimize relational database schemas for Spanner's distributed database model
  • Use Google Cloud tools to manage Spanner databases and data
  • Program and execute queries and transactions using the Spanner API
  • Integrate Spanner into your applications

Der Bedarf an Spanner
Zielsetzungen:
Was ist Spanner?
Spanner und das CAP-Theorem
Geschichte von Spanner
Cloud Spanner Anwendungsfälle
Erste Schritte mit Spanner
Zielsetzungen:
Planung von Spanner-Instanzen
Automatisieren der Instanzerstellung
Erstellen von Datenbanken in Spanner
Optimierung von Spanner-Schemata
Zielsetzungen:
Spanner-Architektur
Auswahl von Primärschlüsseln
Definieren von Datenbankschemata in Spanner
Verstehen von Verschachtelung und Fremdschlüsseln
Verstehen von Sekundärindizes
Programmierung von Spanner-Anwendungen, -Abfragen und -Transaktionen
Zielsetzungen:
Authentifizierung und Autorisierung
Verwendung der Spanner Client-Bibliotheken
Laufende Abfragen
Verwaltung von Vorgängen
Bereitstellung von Spanner-Anwendungen
Zielsetzungen:
Spanner aus Anwendungen verwenden
Aufbau von Datenpipelines in und aus Spanner
Spanner-Verwaltung
Zielsetzungen:
Verwaltung Ihrer Daten in Spanner
Bewältigung des Wandels
Betrieb
Abschlussprojekt
Zielsetzungen:
Bewährte Praktiken für Schraubenschlüssel
Schlussstein-Projekt

Classroom training

Do you prefer the classic training method? A course in one of our Training Centers, with a competent trainer and the direct exchange between all course participants? Then you should book one of our classroom training dates!

Online training

You wish to attend a course in online mode? We offer you online course dates for this course topic. To attend these seminars, you need to have a PC with Internet access (minimum data rate 1Mbps), a headset when working via VoIP and optionally a camera. For further information and technical recommendations, please refer to.

Tailor-made courses

You need a special course for your team? In addition to our standard offer, we will also support you in creating your customized courses, which precisely meet your individual demands. We will be glad to consult you and create an individual offer for you.
Request in-house training now

PDF SymbolYou can find the complete description of this course with dates and prices ready for download at as PDF.