Understanding Cloud Spanner

Understanding Cloud SpannerUCSGOGoogleGO-UCS1.0<ul> <li>Build scalable, managed, relational databases using Cloud Spanner</li><li>Create and manage Cloud Spanner databases using the CLI, Terraform, Python API, and the Cloud Console</li><li>Program and run queries and transactions using the Cloud Spanner API</li><li>Integrate Cloud Spanner with applications</li></ul>Some prior Google Cloud experience at the fundamental level and experience with relational databases, the SQL language, and some programming are assumed.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.<h4>Module 1 - The Need for Spanner</h4> Topics <ul> <li>What is Spanner?</li><li>Spanner and the CAP Theorem</li><li>History of Spanner</li><li>Cloud Spanner Use Cases</li></ul> Objectives: <ul> <li>Explain the core concepts and features of Cloud Spanner.</li><li>Understand how Cloud Spanner fits in the CAP theorem.</li><li>Describe the history of Cloud Spanner.</li><li>Explain Cloud Spanner use cases.</li></ul><h4>Module 2 - Getting Started with Spanner</h4> Topics: <ul> <li>Planning Spanner Instances</li><li>Automating Instance Creating</li><li>Creating Databases in Spanner</li></ul> Objectives: <ul> <li>Architect Cloud Spanner instances based on location, capacity, availability, and cost.</li><li>Create Spanner instances by using the Google Cloud console, Google Cloud CLI, and Terraform.</li><li>Create Spanner databases by using SQL</li></ul> Activities: <ul> <li>Lab: Creating Spanner Instances and Databases (Console)</li><li>Lab: Creating Spanner Instances and Databases (CLI and Terraform)</li></ul><h4>Module 3 - Optimizing Spanner Schemas</h4> Topics: <ul> <li>Spanner Architecture</li><li>Choosing Primary Keys</li><li>Defining Database Schemas in Spanner</li><li>Understanding Interleaving and Foreign Keys</li><li>Understanding Secondary Indexes</li></ul> Objectives: <ul> <li>Optimize schemas for Spanner architecture.</li><li>Choose appropriate primary keys.</li><li>Manage relationships with primary and foreign keys and with interleaved tables</li></ul> Activities: <ul> <li>Lab: Choosing Primary Keys</li><li>Lab: Managing relationships with Foreign Keys and Interleaved Tables</li></ul><h4>Module 4 - Programming Spanner Applications, Queries, and Transactions</h4> Topics: <ul> <li>Authentication and Authorization</li><li>Using the Spanner Client Libraries</li><li>Running Queries</li><li>Managing Transactions</li></ul> Objectives: <ul> <li>Authenticate users and applications that access Spanner databases using Identity Access Management.</li><li>Program Spanner applications using Google Cloud client libraries and Python.</li><li>Optimize queries using strong reads, stale reads, and indexes.</li><li>Manage transactions in Spanner.</li></ul> Activities: <ul> <li>Lab: Programming Spanner Applications with Python</li><li>Lab: Running Queries and Transactions</li></ul><h4>Module 5 - Deploying Spanner Applications</h4> Topics: <ul> <li>Using Spanner from Applications</li><li>Building Data Pipelines into and out of Spanner</li></ul> Objectives: <ul> <li>Deploy Spanner applications to Google Cloud serverless runtimes.</li><li>Migrate data to and from Cloud Spanner by using Dataflow jobs and Apache Beam.</li></ul> Activities: <ul> <li>Lab: Deploying Spanner Applications with Cloud Functions and Cloud Run</li><li>Lab: Migrating Data to and from Spanner with Dataflow</li></ul><h4>Module 6 - Spanner Administration</h4> Topics: <ul> <li>Managing your Data in Spanner</li><li>Managing Change Operations</li></ul> Objectives: <ul> <li>Administer Cloud Spanner instances.</li><li>Backup, restore, import, and export data.</li><li>Modify database schemas with no downtime.</li><li>Monitor your Cloud Spanner databases and applications</li></ul> Activities: <ul> <li>Lab: Reconciling Account Data with Cloud Spanner Change Streams</li><li>Lab: Leverage the Autoscaler Tool for Cloud Spanner to Achieve Workload Elasticity</li></ul><h4>Module 7 - Spanner Best Practices</h4> Topics: <ul> <li>Spanner Best Practices</li><li>Challenge Lab</li></ul> Objectives: <ul> <li>Review best practices for using Cloud Spanner</li></ul> Activities: <ul> <li>Challenge Lab: Administering a Spanner Database</li></ul>- Build scalable, managed, relational databases using Cloud Spanner - Create and manage Cloud Spanner databases using the CLI, Terraform, Python API, and the Cloud Console - Program and run queries and transactions using the Cloud Spanner API - Integrate Cloud Spanner with applicationsSome prior Google Cloud experience at the fundamental level and experience with relational databases, the SQL language, and some programming are assumed.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.Module 1 - The Need for Spanner Topics - What is Spanner? - Spanner and the CAP Theorem - History of Spanner - Cloud Spanner Use Cases Objectives: - Explain the core concepts and features of Cloud Spanner. - Understand how Cloud Spanner fits in the CAP theorem. - Describe the history of Cloud Spanner. - Explain Cloud Spanner use cases. Module 2 - Getting Started with Spanner Topics: - Planning Spanner Instances - Automating Instance Creating - Creating Databases in Spanner Objectives: - Architect Cloud Spanner instances based on location, capacity, availability, and cost. - Create Spanner instances by using the Google Cloud console, Google Cloud CLI, and Terraform. - Create Spanner databases by using SQL Activities: - Lab: Creating Spanner Instances and Databases (Console) - Lab: Creating Spanner Instances and Databases (CLI and Terraform) Module 3 - Optimizing Spanner Schemas Topics: - Spanner Architecture - Choosing Primary Keys - Defining Database Schemas in Spanner - Understanding Interleaving and Foreign Keys - Understanding Secondary Indexes Objectives: - Optimize schemas for Spanner architecture. - Choose appropriate primary keys. - Manage relationships with primary and foreign keys and with interleaved tables Activities: - Lab: Choosing Primary Keys - Lab: Managing relationships with Foreign Keys and Interleaved Tables Module 4 - Programming Spanner Applications, Queries, and Transactions Topics: - Authentication and Authorization - Using the Spanner Client Libraries - Running Queries - Managing Transactions Objectives: - Authenticate users and applications that access Spanner databases using Identity Access Management. - Program Spanner applications using Google Cloud client libraries and Python. - Optimize queries using strong reads, stale reads, and indexes. - Manage transactions in Spanner. Activities: - Lab: Programming Spanner Applications with Python - Lab: Running Queries and Transactions Module 5 - Deploying Spanner Applications Topics: - Using Spanner from Applications - Building Data Pipelines into and out of Spanner Objectives: - Deploy Spanner applications to Google Cloud serverless runtimes. - Migrate data to and from Cloud Spanner by using Dataflow jobs and Apache Beam. Activities: - Lab: Deploying Spanner Applications with Cloud Functions and Cloud Run - Lab: Migrating Data to and from Spanner with Dataflow Module 6 - Spanner Administration Topics: - Managing your Data in Spanner - Managing Change Operations Objectives: - Administer Cloud Spanner instances. - Backup, restore, import, and export data. - Modify database schemas with no downtime. - Monitor your Cloud Spanner databases and applications Activities: - Lab: Reconciling Account Data with Cloud Spanner Change Streams - Lab: Leverage the Autoscaler Tool for Cloud Spanner to Achieve Workload Elasticity Module 7 - Spanner Best Practices Topics: - Spanner Best Practices - Challenge Lab Objectives: - Review best practices for using Cloud Spanner Activities: - Challenge Lab: Administering a Spanner Database3 jours1995.001950.001980.002490.001950.001950.001950.002095.002095.001950.002755.002450.00