We may earn an affiliate commission when you visit our partners.
Google Cloud Training
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/k958a6/understanding
What's inside
Syllabus
Introduction
A brief introduction to the course structure, and it's contents.
The Need for Spanner
This module discusses the core concepts and aspects of Cloud Spanner. You learn about the history of Cloud Spanner, understand how Cloud Spanner relates to the CAP theorem, and explain a variety of Cloud Spanner use cases.
Read more
Syllabus
Introduction
A brief introduction to the course structure, and it's contents.
The Need for Spanner
This module discusses the core concepts and aspects of Cloud Spanner. You learn about the history of Cloud Spanner, understand how Cloud Spanner relates to the CAP theorem, and explain a variety of Cloud Spanner use cases.
Read more
Getting Started with Spanner
This module discusses the options for architecting Spanner instances based on location, capacity, availability, and cost. You will learn how to create Spanner instances by using the Google Cloud console, Google Cloud CLI, Terraform, and Cloud Spanner databases by using SQL.
Optimizing Spanner Schemas
This module discusses the options for optimizing database schemas to perform optimally in Spanner. You learn how to choose the appropriate primary key for your data. You learn how to manage relationships with primary and foreign keys and with interleaved tables.
Programming Spanner Applications, Queries, and Transactions
This module introduces the methods for authenticating users and applications that connect to Spanner databases. You will learn how to create applications that connect to Cloud Spanner by using Google Cloud client libraries and Python. You optimize queries by using indexes, strong reads, and stale reads. You also learn how to manage transactions in Cloud Spanner.
Deploying Spanner Applications
This module introduces the steps for deploying Cloud Spanner applications to Google Cloud serverless runtimes. You also learn how to migrate data to and from Cloud Spanner by using Dataflow jobs and Apache Beam.
Spanner Administration
This module introduces administering Cloud Spanner instances. You learn how to backup, restore, import, and export data. You learn how to modify database schemas with no downtime. You also learn how to monitor your Cloud Spanner databases and applications.
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Provides a comprehensive overview of Cloud Spanner, its use cases, and how it compares to other database products
In-depth coverage of Spanner's distributed database model, schema optimization, and data management
Hands-on guidance on authenticating applications, querying data, and managing transactions in Spanner
Practical instructions on deploying Spanner applications and migrating data using Google Cloud serverless runtimes and Apache Beam
Covers essential Spanner administration tasks such as backups, restores, importing/exporting data, and schema modifications
Taught by Google Cloud Training, ensuring up-to-date and industry-relevant knowledge
Save this course
Save Understanding Cloud Spanner to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Understanding Cloud Spanner with these
activities:
Join a study group or discussion forum
Show steps
Connects you with other students who are also learning about Cloud Spanner, which will provide opportunities for collaboration, discussion, and support.
Show steps
-
Find a study group or discussion forum dedicated to Cloud Spanner.
-
Introduce yourself and share your goals.
-
Participate in discussions and ask questions.
Review the course materials
Show steps
Reviewing the course materials will refresh your memory and reinforce the concepts learned, improving your retention and understanding.
Browse courses on
Cloud Spanner
Show steps
-
Re-read the course notes
-
Review the video lectures
-
Complete the practice exercises
Review relational databases
Show steps
Refreshes your understanding of relational databases, which will help you better understand the concepts of Cloud Spanner.
Browse courses on
Relational Databases
Show steps
-
Read articles and blog posts about relational databases.
-
Review your notes from previous courses or textbooks on relational databases.
-
Take practice quizzes or tests on relational databases.
14 other activities
Expand to see all activities and additional details
Show all 17 activities
Review relational database concepts
Show steps
Reviewing and practicing relational database concepts will enhance your understanding of the fundamentals needed for Cloud Spanner, which is built upon these concepts.
Show steps
-
Review textbooks or online materials on relational databases
-
Complete practice exercises on SQL queries
Google Cloud Platform - Spanner Beginners Tutorial
Show steps
Following tutorials on Spanner basics will ease the learning curve, improve retention, and help you get started on Spanner.
Browse courses on
Cloud Spanner
Show steps
-
Visit the Google Cloud Platform Skills Boost website
-
Select the Cloud Spanner Beginners Tutorial
-
Complete the tutorial
Cloud Spanner SQL Practice Problems
Show steps
Practice writing Spanner SQL queries will help you become proficient in the language and reinforce your understanding of Spanner's capabilities.
Browse courses on
SQL
Show steps
-
Find a collection of Spanner SQL practice problems online
-
Attempt to solve the problems on your own
-
Check your answers against the provided solutions
-
Review the concepts you struggled with
Follow along with Cloud Spanner tutorials
Show steps
Completing guided tutorials provides a practical understanding of how to use Cloud Spanner, reinforcing the concepts learned in the course.
Show steps
-
Visit the Cloud Spanner documentation
-
Follow the step-by-step instructions in the tutorials
Create a Spanner instance
Show steps
Provides hands-on experience in creating a Spanner instance, which will help you understand the process and the options available.
Browse courses on
Google Cloud Platform
Show steps
-
Log in to the Google Cloud Platform console.
-
Create a new Spanner instance.
-
Configure the instance settings, such as location, capacity, and availability.
Practice writing SQL queries for Cloud Spanner
Show steps
Practicing writing SQL queries specifically for Cloud Spanner will enhance your ability to interact with and manipulate data effectively.
Show steps
-
Use the Cloud Spanner Query Editor
-
Write queries to create and modify tables
-
Write queries to insert, update, and delete data
Spanner Database Design Diagram
Show steps
Creating your own Spanner database diagram will help you retain information about schema design, column families, and interleaving.
Browse courses on
Database Design
Show steps
-
Design a simple database schema with Spanner in mind
-
Use a tool like Draw.io to create a visual representation of your schema
-
Include tables, columns, data types, and relationships
-
Consider how you would optimize your schema for performance
Build a simple application using Cloud Spanner
Show steps
Helps you apply your knowledge of Cloud Spanner by building a simple application, which will reinforce your understanding and identify areas where you need more practice.
Browse courses on
Python
Show steps
-
Find a tutorial on building a simple application using Cloud Spanner.
-
Follow the steps in the tutorial to build the application.
-
Test the application to make sure it works as expected.
Participate in online forums or discussion groups for Cloud Spanner
Show steps
Engaging with other learners in online forums or discussion groups provides an opportunity to clarify concepts, exchange ideas, and reinforce your understanding.
Show steps
-
Join a Cloud Spanner community forum
-
Participate in discussions and answer questions from other learners
Design a database schema for a specific use case
Show steps
Challenges you to apply your understanding of Spanner schemas by designing a schema for a specific use case, which will help you develop your critical thinking and problem-solving skills.
Browse courses on
Database Schema
Show steps
-
Identify a specific use case for Cloud Spanner.
-
Design a database schema that meets the requirements of the use case.
-
Create a document or presentation that describes your schema design.
Develop a Cloud Spanner data model for a real-world scenario
Show steps
Creating a data model for a real-world scenario allows you to apply the concepts learned in the course to a practical problem, solidifying your understanding.
Show steps
-
Identify a real-world use case for Cloud Spanner
-
Design a data model that meets the requirements of the use case
-
Implement the data model in Cloud Spanner
Answer questions about Cloud Spanner on forums or discussion groups
Show steps
Helps you solidify your understanding of Cloud Spanner by explaining it to others, which will also help you identify areas where you need more practice.
Browse courses on
Cloud Spanner
Show steps
-
Find a forum or discussion group where people are asking questions about Cloud Spanner.
-
Answer questions to the best of your ability.
-
Be patient and respectful, even if you don't know the answer.
Build a simple web application using Cloud Spanner
Show steps
Building a web application using Cloud Spanner allows you to integrate the concepts learned in the course into a complete project, enhancing your practical skills.
Show steps
-
Choose a programming language and framework
-
Create a new Cloud Spanner instance
-
Implement the application logic to interact with Cloud Spanner
-
Deploy the application to a hosting platform
Create a collection of resources on Cloud Spanner
Show steps
Compiling resources on Cloud Spanner will provide you with a single, organized source of information for future reference and reinforcement of concepts.
Show steps
-
Gather articles, tutorials, and documentation on Cloud Spanner
-
Organize the resources by topic or category
-
Create a resource guide or website to share your compilation
Join a study group or discussion forum
Show steps
Connects you with other students who are also learning about Cloud Spanner, which will provide opportunities for collaboration, discussion, and support.
Show steps
Show steps
Show steps
- Find a study group or discussion forum dedicated to Cloud Spanner.
- Introduce yourself and share your goals.
- Participate in discussions and ask questions.
Review the course materials
Show steps
Reviewing the course materials will refresh your memory and reinforce the concepts learned, improving your retention and understanding.
Browse courses on
Cloud Spanner
Show steps
Show steps
Show steps
- Re-read the course notes
- Review the video lectures
- Complete the practice exercises
Review relational databases
Show steps
Refreshes your understanding of relational databases, which will help you better understand the concepts of Cloud Spanner.
Browse courses on
Relational Databases
Show steps
Show steps
Show steps
- Read articles and blog posts about relational databases.
- Review your notes from previous courses or textbooks on relational databases.
- Take practice quizzes or tests on relational databases.
14 other activities
Expand to see all activities and additional details
Show all 17 activities
Review relational database concepts
Show steps
Reviewing and practicing relational database concepts will enhance your understanding of the fundamentals needed for Cloud Spanner, which is built upon these concepts.
Show steps
Show steps
Show steps
- Review textbooks or online materials on relational databases
- Complete practice exercises on SQL queries
Google Cloud Platform - Spanner Beginners Tutorial
Show steps
Following tutorials on Spanner basics will ease the learning curve, improve retention, and help you get started on Spanner.
Browse courses on
Cloud Spanner
Show steps
Show steps
Show steps
- Visit the Google Cloud Platform Skills Boost website
- Select the Cloud Spanner Beginners Tutorial
- Complete the tutorial
Cloud Spanner SQL Practice Problems
Show steps
Practice writing Spanner SQL queries will help you become proficient in the language and reinforce your understanding of Spanner's capabilities.
Browse courses on
SQL
Show steps
Show steps
Show steps
- Find a collection of Spanner SQL practice problems online
- Attempt to solve the problems on your own
- Check your answers against the provided solutions
- Review the concepts you struggled with
Follow along with Cloud Spanner tutorials
Show steps
Completing guided tutorials provides a practical understanding of how to use Cloud Spanner, reinforcing the concepts learned in the course.
Show steps
Show steps
Show steps
- Visit the Cloud Spanner documentation
- Follow the step-by-step instructions in the tutorials
Create a Spanner instance
Show steps
Provides hands-on experience in creating a Spanner instance, which will help you understand the process and the options available.
Browse courses on
Google Cloud Platform
Show steps
Show steps
Show steps
- Log in to the Google Cloud Platform console.
- Create a new Spanner instance.
- Configure the instance settings, such as location, capacity, and availability.
Practice writing SQL queries for Cloud Spanner
Show steps
Practicing writing SQL queries specifically for Cloud Spanner will enhance your ability to interact with and manipulate data effectively.
Show steps
Show steps
Show steps
- Use the Cloud Spanner Query Editor
- Write queries to create and modify tables
- Write queries to insert, update, and delete data
Spanner Database Design Diagram
Show steps
Creating your own Spanner database diagram will help you retain information about schema design, column families, and interleaving.
Browse courses on
Database Design
Show steps
Show steps
Show steps
- Design a simple database schema with Spanner in mind
- Use a tool like Draw.io to create a visual representation of your schema
- Include tables, columns, data types, and relationships
- Consider how you would optimize your schema for performance
Build a simple application using Cloud Spanner
Show steps
Helps you apply your knowledge of Cloud Spanner by building a simple application, which will reinforce your understanding and identify areas where you need more practice.
Browse courses on
Python
Show steps
Show steps
Show steps
- Find a tutorial on building a simple application using Cloud Spanner.
- Follow the steps in the tutorial to build the application.
- Test the application to make sure it works as expected.
Participate in online forums or discussion groups for Cloud Spanner
Show steps
Engaging with other learners in online forums or discussion groups provides an opportunity to clarify concepts, exchange ideas, and reinforce your understanding.
Show steps
Show steps
Show steps
- Join a Cloud Spanner community forum
- Participate in discussions and answer questions from other learners
Design a database schema for a specific use case
Show steps
Challenges you to apply your understanding of Spanner schemas by designing a schema for a specific use case, which will help you develop your critical thinking and problem-solving skills.
Browse courses on
Database Schema
Show steps
Show steps
Show steps
- Identify a specific use case for Cloud Spanner.
- Design a database schema that meets the requirements of the use case.
- Create a document or presentation that describes your schema design.
Develop a Cloud Spanner data model for a real-world scenario
Show steps
Creating a data model for a real-world scenario allows you to apply the concepts learned in the course to a practical problem, solidifying your understanding.
Show steps
Show steps
Show steps
- Identify a real-world use case for Cloud Spanner
- Design a data model that meets the requirements of the use case
- Implement the data model in Cloud Spanner
Answer questions about Cloud Spanner on forums or discussion groups
Show steps
Helps you solidify your understanding of Cloud Spanner by explaining it to others, which will also help you identify areas where you need more practice.
Browse courses on
Cloud Spanner
Show steps
Show steps
Show steps
- Find a forum or discussion group where people are asking questions about Cloud Spanner.
- Answer questions to the best of your ability.
- Be patient and respectful, even if you don't know the answer.
Build a simple web application using Cloud Spanner
Show steps
Building a web application using Cloud Spanner allows you to integrate the concepts learned in the course into a complete project, enhancing your practical skills.
Show steps
Show steps
Show steps
- Choose a programming language and framework
- Create a new Cloud Spanner instance
- Implement the application logic to interact with Cloud Spanner
- Deploy the application to a hosting platform
Create a collection of resources on Cloud Spanner
Show steps
Compiling resources on Cloud Spanner will provide you with a single, organized source of information for future reference and reinforcement of concepts.
Show steps
Show steps
Show steps
- Gather articles, tutorials, and documentation on Cloud Spanner
- Organize the resources by topic or category
- Create a resource guide or website to share your compilation
Career center
Learners who complete Understanding Cloud Spanner will develop knowledge and skills
that may be useful to these careers:
Database Administrator
Database Administrator
Database Administrators implement, manage, and upgrade databases using software and system tools within the company's computer systems. This course provides an in-depth explanation of how to create and manage Spanner Databases using SQL, and how to integrate with other Google Cloud Tools for database administration.
Database Manager
Database Manager
Database Managers are responsible for the planning, implementation, and maintenance of database systems in an organization. This course provides an in-depth explanation of how to create and manage Spanner databases using various tools on Google Cloud, as well as how to optimize relational schemas with Spanner's distributed database model in mind.
Data Architect
Data Architect
Data Architects work with various stakeholders to understand business requirements, translate these requirements into structured data models and schemas, and create or update databases and underlying data structures.
Data Engineer
Data Engineer
Data Engineers design, build, and maintain data architectures and systems to support data-driven decision-making.
Data Management Analyst
Data Management Analyst
Data Management Analysts analyze, interpret, and present data to assist businesses in making informed decisions.
Cloud Engineer
Cloud Engineer
Cloud Engineers are responsible for the overall design, architecture, and implementation of cloud-based applications and infrastructure.
DevOps Engineer
DevOps Engineer
DevOps Engineers work to bridge the gap between development and operations teams to improve the quality and efficiency of software development and delivery.
IT Manager
IT Manager
IT Managers plan, implement, and manage information technology (IT) systems within an organization.
IT Specialist
IT Specialist
IT Specialists provide technical support and advice to users of computer systems and applications.
Business Analyst
Business Analyst
Business Analysts work with various stakeholders to understand business requirements, translate these requirements into structured data models and schemas, and create or update databases and underlying data structures.
Data Scientist
Data Scientist
Data Scientists combine skills in mathematics, statistics, computer science, and business to analyze and interpret data.
Cloud Architect
Cloud Architect
Cloud Architects design, build, and maintain cloud-based applications and infrastructure. This course may be useful for learning about how to architect Spanner instances based on location, capacity, availability, and cost.
Data Analyst
Data Analyst
Data Analysts gather, clean, analyze, interpret, and present data to assist businesses in making informed decisions. This course may be useful for learning how to interact with Spanner databases using the Spanner API, integrating it with applications, and optimizing relational schemas with Spanner's distributed database model in mind.
Systems Administrator
Systems Administrator
Systems Administrators maintain and administer computer systems, including hardware, software, and networks. This course may be useful for learning about how to deploy Spanner applications to Google Cloud serverless runtimes, as well as how to migrate data to and from Cloud Spanner using Dataflow jobs and Apache Beam.
Software Engineer
Software Engineer
Software Engineers develop, maintain, and improve computer software. This course may be useful for learning about programming Spanner applications, queries, and transactions, as well as optimizing queries by using indexes, strong reads, and stale reads.
For more career information including salaries, visit:
OpenCourser.com/course/k958a6/understanding
Reading list
We've selected seven books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Understanding Cloud Spanner.
Save
Provides a deep dive into the internals of distributed database systems, including storage engines, transaction processing, and concurrency control. It offers a comprehensive view of the underlying mechanisms and challenges involved in building scalable and reliable database systems like Cloud Spanner.
Save
Delves into the principles and patterns for designing data-intensive applications. It provides a solid foundation for understanding the challenges and considerations involved in building scalable and performant data systems, complementing the course's focus on Cloud Spanner.
This classic book provides a thorough understanding of SQL and relational theory. It covers topics such as data types, constraints, and query optimization, which are essential for writing efficient and effective SQL queries in Cloud Spanner.
Introduces the concepts and best practices of microservices architecture. It provides guidance on designing and building modular, scalable, and resilient microservices, which is valuable for understanding the integration of Cloud Spanner with other microservices in a distributed system.
Provides a comprehensive overview of distributed SQL databases, including their architectures, consistency models, and performance considerations. It offers a broader perspective on the challenges and solutions in distributed database systems, which can enhance the understanding gained from the course.
Provides a clear and concise introduction to relational database design principles. It covers data modeling, normalization, and query optimization, serving as a useful reference for understanding the fundamentals of relational database design, which are applicable to Cloud Spanner as well.
While this book focuses on MySQL, it provides valuable insights into relational database performance optimization techniques that can be applied to Cloud Spanner as well. It offers a deeper understanding of database internals and optimization strategies.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/k958a6/understanding
Share
Similar courses
Here are nine courses similar to
Understanding Cloud Spanner.
Understanding Cloud Spanner
OpenCourser.com/course/arkdri/understanding
Understanding Cloud Spanner
Most relevant
Creating and Administering Google Cloud Spanner Instances
OpenCourser.com/course/yajy5j/creating
Creating and Administering Google Cloud Spanner Instances
Most relevant
Building Scalable Java Microservices with Spring Boot and Spring Cloud
OpenCourser.com/course/ydony7/building
Building Scalable Java Microservices with Spring Boot and...
Most relevant
Database, Big Data, and DevOps Services in GCP
OpenCourser.com/course/6oc59g/database
Database, Big Data, and DevOps Services in GCP
Most relevant
Cloud Spanner: Qwik Start
OpenCourser.com/course/dhhh19/cloud
Cloud Spanner: Qwik Start
Most relevant
Amazon Aurora: Best Practices
OpenCourser.com/course/t5wogt/amazon
Amazon Aurora: Best Practices
Most relevant
Importing Data from Relational Databases in R 3
OpenCourser.com/course/fpokjx/importing
Importing Data from Relational Databases in R 3
Most relevant
Online Data Migration to Cloud Spanner using Striim
OpenCourser.com/course/z9b0jm/online
Online Data Migration to Cloud Spanner using Striim
Most relevant
Relational Database Basics
OpenCourser.com/course/r7wyip/relational
Relational Database Basics
Most relevant
Level
Intermediate
Via
Coursera
Institution
Google Cloud
Instructor
Google Cloud Training
Language
English
Good to know
Provides a comprehensive overview of Cloud Spanner, its use cases, and how it compares to other database products
In-depth coverage of Spanner's distributed database model, schema optimization, and data management
Hands-on guidance on authenticating applications, querying data, and managing transactions in Spanner
Practical instructions on deploying Spanner applications and migrating data using Google Cloud serverless runtimes and Apache Beam
Covers essential Spanner administration tasks such as backups, restores, importing/exporting data, and schema modifications
Taught by Google Cloud Training, ensuring up-to-date and industry-relevant knowledge
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser