Google Cloud Spanner Essentials

Google Cloud Spanner Essentials

English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 3h 35m | 631 MB

Design a consistent & horizontally scalable database for efficiently loading and querying relational data

Google Cloud Spanner is another solution for developers and organizations who have hit the limits of traditional relational databases like MySQL, PostgreSQL, Oracle and others. If you’re a developer who would like to have accurate, consistent and real time global data for making decisions, avoid inconsistencies that lead to monetary loss, then this course is for you.

Do you want to resolve consistency and scalability issues and get accurate real-time global data for making decisions? Cloud Spanner makes this possible by creating a global, consistent and a single-source-of-truth data store for your business.

This course will cover the fundamentals of Cloud Spanner and setting it up step by step for operational database workloads by efficiently loading and querying relational data. It also covers modeling tables, indexes and tools with security permissions for best performance in Cloud Spanner.

By the end of this course, users will have a hands-on exposure to use spanner to setup and use their operational databases to utilize the efficiency of cloud.

A step by step practical guide for efficient modeling of your databases using the power of Spanner’s features

This course introduces the concepts of Cloud Spanner and an introduction to solutions development with a step by step hands-on practice. This approach is intended to make the student aware of the significant concepts of Cloud Spanner and provide enough experience in implementing these concepts so he/she may complete this course and feel comfortable enough with the tools and technologies to begin using them immediately in real-world practice.

What You Will Learn

  • Set up Spanner using different tools in GCP
  • Implement global consistency and scalability for distributed DBs
  • Perform operational task with Google Cloud Spanner with efficient queries
  • Explore different Cloud Spanner use cases of Cloud spanner and comparison compare them with other DBs
  • Database The database consistency/scalability paradox and how Cloud Spanner breaks it
  • Implementing data on the fly schema dynamics
  • Increase performance and efficiency- tuning on a Cloud Spanner instance
  • Data modeling and indexes for best performance in Cloud Spanner
  • In-depth working with data loading, SQL queries, and functions used in Spanner
Table of Contents

Getting started with Cloud Spanner
1 The Course Overview
2 An Overview of Google Cloud and Storage Options
3 Cloud Spanner Features
4 Setting up a Google Account
5 Accessing GCP via gcloud
6 Spanner Architecture

Cloud Spanner Fundamentals
7 Setting up an instance from Console
8 Setting up an instance from gcloud
9 Spanner Pricing
10 Setting up a Database
11 IAM Identity and Access Management

Data Modelling in Spanner
12 Accessing Spanner via Client Libraries
13 Setting up Instance and DB using Python
14 Loading and Querying data with Libraries
15 Schema Design Best Practices Interleaving and Primary key Selection
16 Schema Updates

Loading and Querying Data with Spanner
17 Reads and Transactions
18 DML for data loading and modification- Part 1
19 DML for data loading and modification-Part 2
20 Working with Mutations
21 Best Practices for Bulk Loading data

Indexes, Queries and other Operations
22 Secondary Indexes
23 Performing Reads and Timestamp Bounds
24 Executing Queries in Spanner
25 SQL Best Practices
26 Monitoring with Stackdriver