-
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
-
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.
-
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
-
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.
