Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Database Design and Modeling with Google Cloud
Database Design and Modeling with Google Cloud

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

eBook
€17.99 €20.99
Paperback
€26.99
Subscription
Free Trial
Renews at €18.99p/m

What do you get with Print?

Product feature icon Instant access to your digital copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Redeem a companion digital copy on all Print orders
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Table of content icon View table of contents Preview book icon Preview Book

Database Design and Modeling with Google Cloud

Left arrow icon Right arrow icon
Download code icon Download Code

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
Estimated delivery fee Deliver to France

Premium delivery 7 - 10 business days

€10.95
(Includes tracking information)

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Dec 29, 2023
Length: 234 pages
Edition : 1st
Language : English
ISBN-13 : 9781804611456
Vendor :
Google
Category :
Concepts :

What do you get with Print?

Product feature icon Instant access to your digital copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Redeem a companion digital copy on all Print orders
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Product feature icon AI Assistant (beta) to help accelerate your learning
OR
Modal Close icon
Payment Processing...
tick Completed

Shipping Address

Billing Address

Shipping Methods
Estimated delivery fee Deliver to France

Premium delivery 7 - 10 business days

€10.95
(Includes tracking information)

Product Details

Publication date : Dec 29, 2023
Length: 234 pages
Edition : 1st
Language : English
ISBN-13 : 9781804611456
Vendor :
Google
Category :
Concepts :

Packt Subscriptions

See our plans and pricing
Modal Close icon
€18.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
€189.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
€264.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total 107.97
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 Stars icon

Table of Contents

17 Chapters
Part 1:Database Model: Business and Technical Design Considerations Chevron down icon Chevron up icon
Chapter 1: Data, Databases, and Design Chevron down icon Chevron up icon
Chapter 2: Handling Data on the Cloud Chevron down icon Chevron up icon
Part 2:Structured Data Chevron down icon Chevron up icon
Chapter 3: Database Modeling for Structured Data Chevron down icon Chevron up icon
Chapter 4: Setting Up a Fully Managed RDBMS Chevron down icon Chevron up icon
Chapter 5: Designing an Analytical Data Warehouse Chevron down icon Chevron up icon
Part 3:Semi-Structured, Unstructured Data, and NoSQL Design Chevron down icon Chevron up icon
Chapter 6: Designing for Semi-Structured Data Chevron down icon Chevron up icon
Chapter 7: Unstructured Data Management Chevron down icon Chevron up icon
Part 4:DevOps and Databases Chevron down icon Chevron up icon
Chapter 8: DevOps and Databases Chevron down icon Chevron up icon
Part 5:Data to AI Chevron down icon Chevron up icon
Chapter 9: Data to AI – Modeling Your Databases for Analytics and ML Chevron down icon Chevron up icon
Chapter 10: Looking Ahead – Designing for LLM Applications Chevron down icon Chevron up icon
Index Chevron down icon Chevron up icon
Other Books You May Enjoy Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.9
(7 Ratings)
5 star 85.7%
4 star 14.3%
3 star 0%
2 star 0%
1 star 0%
Filter icon Filter
Top Reviews

Filter reviews by




Dieter Jan 22, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
"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 Amazon
Puneet Srivastava Mar 21, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
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 Amazon
Richard L. Seroter Mar 25, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
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
Amazon Customer Jan 03, 2024
Full star icon Full star icon Full star icon Full star icon Full star icon 5
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 Amazon
Aisswarya Dec 31, 2023
Full star icon Full star icon Full star icon Full star icon Full star icon 5
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 Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is the digital copy I get with my Print order? Chevron down icon Chevron up icon

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? Chevron down icon Chevron up icon

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:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela
What is custom duty/charge? Chevron down icon Chevron up icon

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? Chevron down icon Chevron up icon

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? Chevron down icon Chevron up icon

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? Chevron down icon Chevron up icon

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? Chevron down icon Chevron up icon

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:

  1. 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.
  2. 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.
  3. You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
  4. Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
  5. If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
  6. 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? Chevron down icon Chevron up icon

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? Chevron down icon Chevron up icon

You can pay with the following card types:

  1. Visa Debit
  2. Visa Credit
  3. MasterCard
  4. PayPal
What is the delivery time and cost of print books? Chevron down icon Chevron up icon

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:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela