Database Design and Modeling with Google Cloud: Learn database design and development to take your data to applications, analytics, and AI

by Abirami Sukumaran, Priyanka Vergadia (Foreword by), Bagirathi Narayanan (Foreword by)

Overview

In the age of lightning-speed delivery, customers want everything developed, built, and delivered at high speed and at scale. Knowledge, design, and choice of database is critical in that journey, but there is no one-size-fits-all solution. This book serves as a comprehensive and practical guide for data professionals who want to design and model their databases efficiently.
The book begins by taking you through business, technical, and design considerations for databases. Next, it takes you on an immersive structured database deep dive for both transactional and analytical real-world use cases using Cloud SQL, Spanner, and BigQuery. As you progress, you’ll explore semi-structured and unstructured database considerations with practical applications using Firestore, cloud storage, and more. You’ll also find insights into operational considerations for databases and the database design journey for taking your data to AI with Vertex AI APIs and generative AI examples.
By the end of this book, you will be well-versed in designing and modeling data and databases for your applications using Google Cloud.

Product Details

ISBN-13:	9781804617861
Publisher:	Packt Publishing
Publication date:	12/29/2023
Sold by:	Barnes & Noble
Format:	eBook
Pages:	234
File size:	10 MB

About the Author

Abirami Sukumaran is a lead developer advocate at Google, focusing on databases and data to AI journey with Google Cloud. She has over 17 years of experience in data management, data governance, and analytics across several industries in various roles from engineering to leadership, and has 3 patents filed in the data area. She believes in driving social and business impact with technology. She is also an international keynote, tech panel, and motivational speaker, including key events like Google I/O, Cloud NEXT, MLDS, GDS, Huddle Global, India Startup Festival, Women Developers Academy, and so on. She founded Code Vipassana, an award-winning, non-profit, tech-enablement program powered by Google and she runs with the support of Google Developer Communities GDG Cloud Kochi, Chennai, Mumbai, and a few developer leads. She is pursuing her doctoral research in business administration with artificial intelligence, is a certified Yoga instructor, practitioner, and an Indian above everything else.

Table of Contents

Table of Contents

1. Data, Databases, and Design
2. Handling Data on the Cloud
3. Database Modeling for Structured Data
4. Setting Up a Fully Managed RDBMS
5. Designing an Analytical Data Warehouse
6. Designing for Semi-structured Data
7. Unstructured Data Management
8. DevOps and Databases
9. Data to AI – Modeling Your Databases for Analytics and ML
10. Looking Ahead – Designing for LLM Applications