Cloud Spanner - Defining Schemas and Understanding Query Plans with Explanation | GSP1050 | Qwiklabs
Cloud Spanner - Defining Schemas and Understanding Query Plans with Explanation | GSP1050 | Cloud Skills Boost.
Overview
"Cloud Spanner is Google's own fully managed and horizontally scalable relational database service. It is trusted by customers in a wide range of industries, including finance, gaming, and retail, to run their most demanding workloads, where consistency and availability at scale are critical.
You will examine features of Cloud Spanner related to schemas and apply them to a database focused on Banking Operations. Additionally, you will assess the procedures and principles governing how Cloud Spanner generates query plans."
In this lab, you learn how to perform the following tasks:
Load data into tables
Use pre-defined Python client library code to load data
Query data with client libraries
Make updates to the database schema
Add a Secondary Index
Examine Query plans
Welcome to Create and Manage Cloud Spanner Databases Quest. Interested in learning how to explore various techniques for loading data into Cloud Spanner databases; Discover how to back up Cloud Spanner databases; Understand schema definition and query plan optimization in Cloud Spanner; Deploy a modern web application connected to a Cloud Spanner instance.
This series is beginner friendly. If you want to Identify the purpose and value of Google Cloud products and services or just exploring GCP. Do check this out.
Lab link: https://www.cloudskillsboost.google/c...
Migrate MySQL data to Cloud SQL using Database Migration Service Playlist: • Migrate MySQL data to Cloud SQL using Data...
_______________________________________________________________________________________________
PS: I used functions, commands and statements interchangeably in this lab which are not necessarily the same in programming.
This is an example of a function (block of code within a program designed to perform a specific task) named add_numbers.
def add_numbers(a, b):
return a + b
result = add_numbers(3, 5)
return used above is a statement.
This is an example of a command (directive or instruction given to a computer or program to perform a particular action).
mkdir mustapha
mkdir used above is a command to make a new directory named mustapha.