Understanding Cloud Spanner from Pluralsight

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.

What's inside

Syllabus

Introduction

The Need for Spanner

Getting Started with Spanner

Optimizing Spanner Schemas

Programming Spanner Applications, Queries, and Transactions

Deploying Spanner Applications

Spanner Administration

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Builds a strong foundation in cloud database management, a necessary skill for mid-level data engineers and data analysts

Taught by instructors from Google Cloud, ensuring up-to-date, relevant content and a deep understanding of the material

Covers the core concepts of Cloud Spanner, providing a solid understanding for beginners and a refresher for experienced database professionals

Provides hands-on labs and interactive materials, allowing learners to apply their knowledge and gain practical experience

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:

Review Relational Database Management basics

Show steps

Ensure you have a strong foundation in relational database concepts before beginning this course.

Show steps

Review the fundamental principles of relational database management.
Go over the basics of Structured Query Language (SQL).

Review primary key constraints and nullable fields

Show steps

Priming your knowledge of primary key constraints and nullable fields will help you to fully grasp Spanner's distributed database model.

Browse courses on Database Fundamentals

Show steps

Review the definition of a primary key constraint.
Review the definition of a nullable field.
Consider how these concepts apply to data integrity.

Join a study group for Spanner

Show steps

Joining a study group for Spanner will provide you with opportunities to discuss concepts with other learners and reinforce your understanding.

Show steps

Find a study group for Spanner.
Attend regular study sessions.
Participate in discussions and ask questions.

Five other activities

Expand to see all activities and additional details

Show all eight activities

Follow along with official Cloud Spanner documentation tutorials

Show steps

The official documentation provides step-by-step instructions for various Spanner tasks.

Show steps

Go through the tutorial on creating a database.
Follow the instructions to insert and query data.

Design a database schema for a real-world application using Spanner

Show steps

Designing a database schema for a real-world application using Spanner will help you to apply your knowledge of Spanner's distributed database model and optimize your database for performance.

Browse courses on Database Design

Show steps

Identify the requirements of the application.
Choose the appropriate data types for each column.
Create a logical data model.

Create practice queries and transactions

Show steps

Hands-on practice will solidify your understanding of Spanner's capabilities.

Show steps

Draft queries to retrieve and filter data using SQL.
Write transactions to perform complex operations.

Participate in a hackathon or competition that uses Spanner

Show steps

Participating in a hackathon or competition that uses Spanner will challenge you to apply your skills and knowledge in a real-world setting.

Browse courses on Cloud Spanner

Show steps

Find a hackathon or competition that uses Spanner.
Assemble a team of developers.
Develop a solution to the problem using Spanner.

Set up a small-scale Spanner database project

Show steps

Applying your knowledge to a practical project will enhance your learning.

Show steps

Design a simple relational schema for your project.
Create and populate a Spanner database.
Implement queries and transactions to interact with your data.

Career center

Learners who complete Understanding Cloud Spanner will develop knowledge and skills that may be useful to these careers:

Database Administrator

A Database Administrator (DBA) is responsible for the day-to-day management of databases. They ensure that databases are up and running, and that data is safe and secure. The course, Understanding Cloud Spanner, may be useful for this role because it provides an introduction to Cloud Spanner, a relational database service that is designed for scale and performance. The course covers topics such as creating and managing Spanner databases, optimizing Spanner schemas, and programming Spanner applications.

See salaries and explore the career path for Database Administrator

Data Analyst

A Data Analyst analyzes data to identify trends and patterns. They use this information to help businesses make better decisions. The course, Understanding Cloud Spanner, may be useful for this role because it provides an introduction to Cloud Spanner, a relational database service that is designed for scale and performance. The course covers topics such as creating and managing Spanner databases, optimizing Spanner schemas, and programming Spanner applications.

See salaries and explore the career path for Data Analyst

Database Architect

A Database Architect designs, builds, and maintains databases. They ensure that these databases are efficient, secure, and meet the needs of the business. The course, Understanding Cloud Spanner, may be useful for this role because it provides an introduction to Cloud Spanner, a relational database service that is designed for scale and performance. The course covers topics such as creating and managing Spanner databases, optimizing Spanner schemas, and programming Spanner applications.

See salaries and explore the career path for Database Architect

Data Engineer

A Data Engineer designs, builds, and maintains data pipelines. They ensure that data is clean, consistent, and accessible to the business. The course, Understanding Cloud Spanner, may be useful for this role because it provides an introduction to Cloud Spanner, a relational database service that is designed for scale and performance. The course covers topics such as creating and managing Spanner databases, optimizing Spanner schemas, and programming Spanner applications.

See salaries and explore the career path for Data Engineer

Product Manager

A Product Manager is responsible for the development and launch of new products. They work with engineers, designers, and marketers to ensure that products meet the needs of the market. The course, Understanding Cloud Spanner, may be useful for this role because it provides an introduction to Cloud Spanner, a relational database service that is designed for scale and performance. The course covers topics such as creating and managing Spanner databases, optimizing Spanner schemas, and programming Spanner applications.

See salaries and explore the career path for Product Manager

Cloud Engineer

A Cloud Engineer designs, builds, and maintains cloud computing solutions. They ensure that cloud solutions are efficient, reliable, and meet the needs of the business. The course, Understanding Cloud Spanner, may be useful for this role because it provides an introduction to Cloud Spanner, a relational database service that is designed for scale and performance. The course covers topics such as creating and managing Spanner databases, optimizing Spanner schemas, and programming Spanner applications.

See salaries and explore the career path for Cloud Engineer

Technical Writer

A Technical Writer creates and maintains documentation for software and hardware products. They work with engineers and product managers to ensure that documentation is accurate, clear, and helpful. The course, Understanding Cloud Spanner, may be useful for this role because it provides an introduction to Cloud Spanner, a relational database service that is designed for scale and performance. The course covers topics such as creating and managing Spanner databases, optimizing Spanner schemas, and programming Spanner applications.

See salaries and explore the career path for Technical Writer

Customer Success Manager

A Customer Success Manager works with customers to ensure that they are successful with a product or service. They help customers to achieve their goals and get the most value from their investment. The course, Understanding Cloud Spanner, may be useful for this role because it provides an introduction to Cloud Spanner, a relational database service that is designed for scale and performance. The course covers topics such as creating and managing Spanner databases, optimizing Spanner schemas, and programming Spanner applications.

See salaries and explore the career path for Customer Success Manager

Systems Analyst

A Systems Analyst analyzes business processes and identifies opportunities for improvement. They work with stakeholders to design and implement new systems and processes. The course, Understanding Cloud Spanner, may be useful for this role because it provides an introduction to Cloud Spanner, a relational database service that is designed for scale and performance. The course covers topics such as creating and managing Spanner databases, optimizing Spanner schemas, and programming Spanner applications.

See salaries and explore the career path for Systems Analyst

Sales Engineer

A Sales Engineer works with customers to identify and solve technical problems. They help customers to understand and use products and services. The course, Understanding Cloud Spanner, may be useful for this role because it provides an introduction to Cloud Spanner, a relational database service that is designed for scale and performance. The course covers topics such as creating and managing Spanner databases, optimizing Spanner schemas, and programming Spanner applications.

See salaries and explore the career path for Sales Engineer

Project Manager

A Project Manager plans, executes, and closes projects. They work with stakeholders to ensure that projects are completed on time, within budget, and to the required quality. The course, Understanding Cloud Spanner, may be useful for this role because it provides an introduction to Cloud Spanner, a relational database service that is designed for scale and performance. The course covers topics such as creating and managing Spanner databases, optimizing Spanner schemas, and programming Spanner applications.

See salaries and explore the career path for Project Manager

Support Engineer

A Support Engineer provides technical support to customers. They help customers to troubleshoot problems and resolve issues. The course, Understanding Cloud Spanner, may be useful for this role because it provides an introduction to Cloud Spanner, a relational database service that is designed for scale and performance. The course covers topics such as creating and managing Spanner databases, optimizing Spanner schemas, and programming Spanner applications.

See salaries and explore the career path for Support Engineer

Data Scientist

A Data Scientist uses data to build models and make predictions. They use this information to help businesses make better decisions. The course, Understanding Cloud Spanner, may be useful for this role because it provides an introduction to Cloud Spanner, a relational database service that is designed for scale and performance. The course covers topics such as creating and managing Spanner databases, optimizing Spanner schemas, and programming Spanner applications.

See salaries and explore the career path for Data Scientist

Business Analyst

A Business Analyst analyzes business processes and identifies opportunities for improvement. They use this information to help businesses make better decisions. The course, Understanding Cloud Spanner, may be useful for this role because it provides an introduction to Cloud Spanner, a relational database service that is designed for scale and performance. The course covers topics such as creating and managing Spanner databases, optimizing Spanner schemas, and programming Spanner applications.

See salaries and explore the career path for Business Analyst

Software Engineer

A Software Engineer designs, develops, and maintains software applications. They ensure that software is efficient, reliable, and meets the needs of the business. The course, Understanding Cloud Spanner, may be useful for this role because it provides an introduction to Cloud Spanner, a relational database service that is designed for scale and performance. The course covers topics such as creating and managing Spanner databases, optimizing Spanner schemas, and programming Spanner applications.

See salaries and explore the career path for Software Engineer