What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Key benefits

Familiarize yourself with business and technical considerations involved in modeling the right database

Take your data to applications, analytics, and AI with real-world examples

Learn how to code, build, and deploy end-to-end solutions with expert advice

Purchase of the print or Kindle book includes a free PDF eBook

Description

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.

Who is this book for?

This book is for database developers, data engineers, and architects looking to design, model, and build database applications on the cloud with an extended focus on operational consideration and taking their data to AI. Data scientists, as well ML and AI engineers who want to use Google Cloud services in the data to AI journey will also find plenty of useful information in this book. It will also be useful to data analysts and BI developers who want to use SQL impactfully to generate ML and generative AI insights from their data.

What you will learn

Understand different use cases and real-world applications of data in the cloud

Work with document and indexed NoSQL databases

Get to grips with modeling considerations for analytics, AI, and ML

Use real-world examples to learn about ETL services

Design structured, semi-structured, and unstructured data for your applications and analytics

Improve observability, performance, security, scalability, latency SLAs, SLIs, and SLOs

What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Frequently bought together

Data Exploration and Preparation with BigQuery

R$206.99

Database Design and Modeling with Google Cloud

R$194.99

Data Engineering with Google Cloud Platform

R$389.99

Total R$ 791.97

Dieter Jan 22, 2024

"Database Design & Modeling with Google Cloud" by Abirami Sukumaran is a comprehensive guide for data professionals in cloud database design and modeling. This book begins with foundational concepts of databases and design, then delves into structured, semi-structured, and unstructured data, covering aspects like data modeling, technical considerations, and choosing the right database.The book is well-structured, offering insights into cloud computing benefits, database types like relational and NoSQL, and practical applications in cloud services like Cloud SQL and BigQuery. It uniquely integrates database design with advanced topics like AI and ML, providing a holistic view of data management in the cloud era.The author, with her extensive experience, offers a practical approach, making it an excellent resource for database developers, data engineers, architects, and analysts looking to harness Google Cloud services. The book's strength lies in its practical examples, real-world use cases, and hands-on design considerations, making it valuable for both novices and seasoned professionals in the field of database design and cloud computing.

Amazon Verified review

Puneet Srivastava Mar 21, 2024

Recently, I’ve been quite busy, but I finally managed to dive into the book “Database Design and Modeling with Google Cloud”. It has been an enjoyable read, serving as both a refresher and an exploration of various topics related to Google Cloud. Let me share my thoughts on this insightful book.Introduction and Focus:The book doesn’t attempt to be an exhaustive encyclopedia; instead, it focuses on introducing essential concepts to beginners on the GCP platform. Specifically, it delves into database setup and configuration within the Google Cloud ecosystem. The author’s intention is clear: provide practical guidance rather than overwhelming readers with generic information.Step-by-Step Guidance:The book offers a step-by-step guide for setting up and configuring different variations of database deployment capabilities on Google Cloud Platform (GCP). These include Google Cloud SQL, BigQuery, and Firestore.Additionally, it provides a quick overview of storage concepts and Continuous Integration/Continuous Deployment (CI/CD) capabilities on GCP.AI & LLMs:The book walks through ingesting data and demonstrates how to use Google Colab to create a notebook for running a sample model. This practical approach helps readers implement their first solutions effectively.Furthermore, the book includes a guided walkthrough on leveraging LLM (Looker, Language, and Machine Learning) using Vertex AI and BigQuery. This combination bridges theory and real-world application.Kudos to the author, for keeping the book grounded in practicality. It’s refreshing to have a resource that focuses on actionable steps rather than abstract theory.While the book is commendable, clearer screenshots could enhance the reader’s experience. Perhaps future editions can address this.In summary, “Database Design and Modeling with Google Cloud” is an excellent companion for anyone beginning their journey on the Google Cloud’s data offerings. Whether you’re a beginner or need a refresher, this book provides valuable insights and practical guidance.

Amazon Verified review

Richard L. Seroter Mar 25, 2024

Disclosure: I work with Abi at Google CloudIf you’re building a modern data strategy or working with Google Cloud, this is a required book for your bookshelf. The author clearly explains now just the “how” but the “why” you’d make a given choice. I enjoyed the author's writing style which was clear and often went the extra-mile to explain a concept.The book looks at topics around choosing the correct database for a given use case, how to set up and configure a variety of Cloud databases, how to think about automated deployments, what a database migration might look like, and how to think about data and LLM apps. These aren't trivial things to understand in a cloud environment, and I thought the author did a very good job providing each topic with the correct amount of depth.If you’re looking for a tutorial on generic data warehousing or database design, this isn’t that book. You won’t find instructions on creating a star schema or choosing between stored procedures or user-defined functions. But this is a book that will give you the right context and the right confidence to successfully use Google Cloud data services in your architecture.

Amazon Verified review

Amazon Customer Jan 03, 2024

As one of the technical reviewers of this newly published book, I really feel fortunate to be a part of this project. Here's few things I want to highlight about the book:1. First things first, Congratulations to the author Abirami Sukumaran! I gave her some hard time with my reviews and she has been gracious to accept the feedback to re-write some of the content! Kudos to her!2. Industry leaders like Priyanka Vergadia & Bagirathi Narayanan have been kind enough to give their forewords for this book. Cant get better than this!3. IMHO, the book has a good mix of depth & breadth of the topics covered. As the title suggests, this is into over databases design and not much data engineering though.4. Google Cloud services have been explained in simple terms with relevant examples so the reader can easily follow it and apply at workplace.5. BEST PART, all proceeds from the sale of this book goes to charity. So go and grab your copy in Amazon!Thank you to the Packt team for giving me this opportunity to enrich myself and make good use of my free time!

Amazon Verified review

Aisswarya Dec 31, 2023

Database Design and Modeling with Google Cloud, I got this wonderful book and began to read it immediately. Now, I really want to share my thoughts on this amazing book.The book gives a complete guide on using cloud computing and databases. It provides a detailed introduction and series of informative questions and answers. It further gives us steps on how to configure the product as well as practice with GCP products. This also makes it a good resource for beginners and professionals who want to gain a better understanding of Google cloud products and knowledge about the database design and modeling .Throughout the book, the author, Abirami Sukumran guides the reader through a systematic approach to database design and modeling using Google Cloud. The book explains the fundamental concepts of data and illustrates how to transform it into artificial intelligence(AI). The book offers a detailed explanation of each step involved in database design and modeling, making it an excellent resource for beginners as well as experienced professionals. Overall, this book provides a comprehensive understanding of database design and modeling with Google Cloud.In the end, this book is all you need if you want to begin learning cloud computing and database from nothing.

Amazon Verified review

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

What do you get with eBook?