by Asma Aziz | Publisher: Packt Publishing | Release Date: December 2018 | ISBN: 9781788295765

Design a consistent & horizontally scalable database for efficiently loading and querying relational data About This VideoGet up to speed with the world's first and only relational database which supports high consistency and horizontal scalabilityMaximize your business' productivity by focusing on your applications, rather than worrying about your databaseReuse existing SQL skills to query data using industry-standard ANSI SQLIn DetailGoogle 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.The codes files to this course is stored on this github link: https://github.com/PacktPublishing/Google-Cloud-Spanner-EssentialsDownloading the example code for this course: You can download the example code files for all Packt video courses you have purchased from your account at http://www.PacktPub.com. If you purchased this course elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.

1. Chapter 1 : Getting started with Cloud Spanner
   • The Course Overview 00:02:00
   • An Overview of Google Cloud and Storage Options 00:07:08
   • Cloud Spanner Features 00:09:11
   • Setting up a Google Account 00:05:34
   • Accessing GCP via gcloud 00:07:45
   • Spanner Architecture 00:04:25
2. Chapter 2 : Cloud Spanner Fundamentals
   • Setting up an instance from Console 00:08:32
   • Setting up an instance from gcloud 00:04:23
   • Spanner Pricing 00:06:58
   • Setting up a Database 00:17:14
   • IAM: Identity and Access Management 00:17:14
3. Chapter 3 : Data Modelling in Spanner
   • Accessing Spanner via Client Libraries 00:10:44
   • Setting up Instance and DB using Python 00:15:07
   • Loading and Querying data with Libraries 00:07:04
   • Schema Design Best Practices : Interleaving and Primary key Selection 00:08:14
   • Schema Updates 00:06:58
4. Chapter 4 : Loading and Querying Data with Spanner
   • Reads and Transactions 00:05:20
   • DML for data loading and modification- Part 1 00:06:05
   • DML for data loading and modification-Part 2 00:13:39
   • Working with Mutations 00:02:29
   • Best Practices for Bulk Loading data 00:04:50
5. Chapter 5 : Indexes, Queries and other Operations
   • Secondary Indexes 00:14:21
   • Performing Reads and Timestamp Bounds 00:04:58
   • Executing Queries in Spanner 00:10:00
   • SQL Best Practices 00:06:45
   • Monitoring with Stackdriver 00:08:16