GCP Databases: Firestore, Datastore, and Cloud SQL

Overview

Master GCP's core database services through focused, hands-on exercises. Learn when to use NoSQL vs SQL databases, understand the differences between document, key-value, and relational databases.

Syllabus

Unit 1: Getting Started with Firestore

Create a Firestore Products Collection with Custom Document IDs
Batch Adding Products to a Firestore Collection
Modeling Related and Ordered Data with Firestore Collections
Inspecting Firestore Collection Details

Unit 2: Firestore CRUD and Queries

Retrieve a Firestore Document by ID
Debugging Firestore CRUD Operations
Querying Firestore for All Orders by Customer
Adding Optional Status Filters to Firestore Queries
Comparing Targeted Queries and Collection Scans in Firestore

Unit 3: Datastore Data Modeling

Transforming Firestore Data into Datastore Data
Writing Datastore Query Filters for Nested and Array Data
Updating Entities in Datastore: Increment, ArrayUnion, and Dot Notation
Choosing Between Key-Value Store and Firestore for Different Application Scenarios

Unit 4: Relational Data Modeling

Add a Foreign Key Constraint to Enforce Product-Review Relationships in Cloud SQL
Reordering SQL Inserts to Satisfy Foreign Key Constraints in Cloud SQL
Writing a LEFT JOIN Query to Show All Products and Their Sales Quantities
Implementing ACID Transactions in Cloud SQL with Parameterized Queries