What do you get with Print?

Instant access to your digital copy whilst your Print order is Shipped

Paperback book shipped to your preferred address

Redeem a companion digital copy on all Print orders

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 Print?

Instant access to your digital copy whilst your Print order is Shipped

Paperback book shipped to your preferred address

Redeem a companion digital copy on all Print orders

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

€27.99

Database Design and Modeling with Google Cloud

€26.99

Data Engineering with Google Cloud Platform

€52.99

Total € 107.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

FAQs

What is the digital copy I get with my Print order?

When you buy any Print edition of our Books, you can redeem (for free) the eBook edition of the Print Book you’ve purchased. This gives you instant access to your book when you make an order via PDF, EPUB or our online Reader experience.

What is the delivery time and cost of print book?

Shipping Details

USA:

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.

Unfortunately, due to several restrictions, we are unable to ship to the following countries:

Afghanistan
American Samoa
Belarus
Brunei Darussalam
Central African Republic
The Democratic Republic of Congo
Eritrea
Guinea-bissau
Iran
Lebanon
Libiya Arab Jamahriya
Somalia
Sudan
Russian Federation
Syrian Arab Republic
Ukraine
Venezuela

What is custom duty/charge?

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order?

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges?

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.

How can I cancel my order?

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact customercare@packt.com with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at customercare@packt.com using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy?

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on customercare@packt.com with the order number and issue details as explained below:

If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on customercare@packt.com within one hour of placing the order and we will replace/refund you the item cost.
Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on customercare@packt.com who will be able to resolve this issue for you.
You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on customercare@packt.com within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged?

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use?

You can pay with the following card types:

Visa Debit
Visa Credit
MasterCard
PayPal

What is the delivery time and cost of print books?

Shipping Details

USA:

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Unfortunately, due to several restrictions, we are unable to ship to the following countries:

Afghanistan
American Samoa
Belarus
Brunei Darussalam
Central African Republic
The Democratic Republic of Congo
Eritrea
Guinea-bissau
Iran
Lebanon
Libiya Arab Jamahriya
Somalia
Sudan
Russian Federation
Syrian Arab Republic
Ukraine
Venezuela

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 Print?