{"course":{"productid":30980,"modality":1,"active":true,"language":"fr","title":"Understanding Cloud Spanner","productcode":"UCS","vendorcode":"GO","vendorname":"Google","fullproductcode":"GO-UCS","courseware":{"has_ekit":false,"has_printkit":true,"language":""},"url":"https:\/\/portal.flane.ch\/course\/google-ucs","objective":"<ul>\n<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>","essentials":"<p>Some prior Google Cloud experience at the fundamental level and experience with relational databases, the SQL language, and some programming are assumed.<\/p>","audience":"<p>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.<\/p>","outline":"<h4>Module 1 - The Need for Spanner<\/h4><p>\n<strong>Topics<\/strong><\/p>\n<ul>\n<li>What is Spanner?<\/li><li>Spanner and the CAP Theorem<\/li><li>History of Spanner<\/li><li>Cloud Spanner Use Cases<\/li><\/ul><p>\n<strong>Objectives:<\/strong>\n<\/p>\n<ul>\n<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><p>\n<strong>Topics:<\/strong>\n<\/p>\n<ul>\n<li>Planning Spanner Instances<\/li><li>Automating Instance Creating<\/li><li>Creating Databases in Spanner<\/li><\/ul><p>\n<strong>Objectives:<\/strong>\n<\/p>\n<ul>\n<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><p>\n<strong>Activities:<\/strong>\n<\/p>\n<ul>\n<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><p>\n<strong>Topics:<\/strong>\n<\/p>\n<ul>\n<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><p>\n<strong>Objectives:<\/strong>\n<\/p>\n<ul>\n<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><p>\n<strong>Activities:<\/strong>\n<\/p>\n<ul>\n<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><p>\n<strong>Topics:<\/strong>\n<\/p>\n<ul>\n<li>Authentication and Authorization<\/li><li>Using the Spanner Client Libraries<\/li><li>Running Queries<\/li><li>Managing Transactions<\/li><\/ul><p>\n<strong>Objectives:<\/strong>\n<\/p>\n<ul>\n<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><p>\n<strong>Activities:<\/strong>\n<\/p>\n<ul>\n<li>Lab: Programming Spanner Applications with Python<\/li><li>Lab: Running Queries and Transactions<\/li><\/ul><h4>Module 5 - Deploying Spanner Applications<\/h4><p>\n<strong>Topics:<\/strong>\n<\/p>\n<ul>\n<li>Using Spanner from Applications<\/li><li>Building Data Pipelines into and out of Spanner<\/li><\/ul><p>\n<strong>Objectives:<\/strong>\n<\/p>\n<ul>\n<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><p>\n<strong>Activities:<\/strong>\n<\/p>\n<ul>\n<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><p>\n<strong>Topics:<\/strong>\n<\/p>\n<ul>\n<li>Managing your Data in Spanner<\/li><li>Managing Change Operations<\/li><\/ul><p>\n<strong>Objectives:<\/strong>\n<\/p>\n<ul>\n<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><p>\n<strong>Activities:<\/strong>\n<\/p>\n<ul>\n<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><p>\n<strong>Topics:<\/strong>\n<\/p>\n<ul>\n<li>Spanner Best Practices<\/li><li>Challenge Lab<\/li><\/ul><p>\n<strong>Objectives:<\/strong>\n<\/p>\n<ul>\n<li>Review best practices for using Cloud Spanner<\/li><\/ul><p>\n<strong>Activities:<\/strong>\n<\/p>\n<ul>\n<li>Challenge Lab: Administering a Spanner Database<\/li><\/ul>","summary":"<p>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.<\/p>","objective_plain":"- Build scalable, managed, relational databases using Cloud Spanner\n- Create and manage Cloud Spanner databases using the CLI, Terraform, Python API, and the Cloud Console\n- Program and run queries and transactions using the Cloud Spanner API\n- Integrate Cloud Spanner with applications","essentials_plain":"Some prior Google Cloud experience at the fundamental level and experience with relational databases, the SQL language, and some programming are assumed.","audience_plain":"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.","outline_plain":"Module 1 - The Need for Spanner\n\n\nTopics\n\n\n- What is Spanner?\n- Spanner and the CAP Theorem\n- History of Spanner\n- Cloud Spanner Use Cases\n\nObjectives:\n\n\n\n- Explain the core concepts and features of Cloud Spanner.\n- Understand how Cloud Spanner fits in the CAP theorem.\n- Describe the history of Cloud Spanner.\n- Explain Cloud Spanner use cases.\nModule 2 - Getting Started with Spanner\n\n\nTopics:\n\n\n\n- Planning Spanner Instances\n- Automating Instance Creating\n- Creating Databases in Spanner\n\nObjectives:\n\n\n\n- Architect Cloud Spanner instances based on location, capacity, availability, and cost.\n- Create Spanner instances by using the Google Cloud console, Google Cloud CLI, and Terraform.\n- Create Spanner databases by using SQL\n\nActivities:\n\n\n\n- Lab: Creating Spanner Instances and Databases (Console)\n- Lab: Creating Spanner Instances and Databases (CLI and Terraform)\nModule 3 - Optimizing Spanner Schemas\n\n\nTopics:\n\n\n\n- Spanner Architecture\n- Choosing Primary Keys\n- Defining Database Schemas in Spanner\n- Understanding Interleaving and Foreign Keys\n- Understanding Secondary Indexes\n\nObjectives:\n\n\n\n- Optimize schemas for Spanner architecture.\n- Choose appropriate primary keys.\n- Manage relationships with primary and foreign keys and with interleaved tables\n\nActivities:\n\n\n\n- Lab: Choosing Primary Keys\n- Lab: Managing relationships with Foreign Keys and Interleaved Tables\nModule 4 - Programming Spanner Applications, Queries, and Transactions\n\n\nTopics:\n\n\n\n- Authentication and Authorization\n- Using the Spanner Client Libraries\n- Running Queries\n- Managing Transactions\n\nObjectives:\n\n\n\n- Authenticate users and applications that access Spanner databases using Identity Access Management.\n- Program Spanner applications using Google Cloud client libraries and Python.\n- Optimize queries using strong reads, stale reads, and indexes.\n- Manage transactions in Spanner.\n\nActivities:\n\n\n\n- Lab: Programming Spanner Applications with Python\n- Lab: Running Queries and Transactions\nModule 5 - Deploying Spanner Applications\n\n\nTopics:\n\n\n\n- Using Spanner from Applications\n- Building Data Pipelines into and out of Spanner\n\nObjectives:\n\n\n\n- Deploy Spanner applications to Google Cloud serverless runtimes.\n- Migrate data to and from Cloud Spanner by using Dataflow jobs and Apache Beam.\n\nActivities:\n\n\n\n- Lab: Deploying Spanner Applications with Cloud Functions and Cloud Run\n- Lab: Migrating Data to and from Spanner with Dataflow\nModule 6 - Spanner Administration\n\n\nTopics:\n\n\n\n- Managing your Data in Spanner\n- Managing Change Operations\n\nObjectives:\n\n\n\n- Administer Cloud Spanner instances.\n- Backup, restore, import, and export data.\n- Modify database schemas with no downtime.\n- Monitor your Cloud Spanner databases and applications\n\nActivities:\n\n\n\n- Lab: Reconciling Account Data with Cloud Spanner Change Streams\n- Lab: Leverage the Autoscaler Tool for Cloud Spanner to Achieve Workload Elasticity\nModule 7 - Spanner Best Practices\n\n\nTopics:\n\n\n\n- Spanner Best Practices\n- Challenge Lab\n\nObjectives:\n\n\n\n- Review best practices for using Cloud Spanner\n\nActivities:\n\n\n\n- Challenge Lab: Administering a Spanner Database","summary_plain":"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.","skill_level":"Intermediate","version":"1.0","duration":{"unit":"d","value":3,"formatted":"3 jours"},"pricelist":{"List Price":{"US":{"country":"US","currency":"USD","taxrate":null,"price":1995},"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":1950},"GB":{"country":"GB","currency":"GBP","taxrate":20,"price":1980},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":2490},"AT":{"country":"AT","currency":"EUR","taxrate":20,"price":1950},"SE":{"country":"SE","currency":"EUR","taxrate":25,"price":1950},"IT":{"country":"IT","currency":"EUR","taxrate":20,"price":1950},"NL":{"country":"NL","currency":"EUR","taxrate":21,"price":2095},"BE":{"country":"BE","currency":"EUR","taxrate":21,"price":2095},"SI":{"country":"SI","currency":"EUR","taxrate":20,"price":1950},"CA":{"country":"CA","currency":"CAD","taxrate":null,"price":2755},"FR":{"country":"FR","currency":"EUR","taxrate":19.6,"price":2450}}},"lastchanged":"2025-09-30T15:29:28+02:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-course-schedule\/30980","source_lang":"fr","source":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-course\/google-ucs"}}