Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Google Cloud Platform for Architects

You're reading from   Google Cloud Platform for Architects Design and manage powerful cloud solutions

Arrow left icon
Product type Paperback
Published in Jun 2018
Publisher Packt
ISBN-13 9781788834308
Length 372 pages
Edition 1st Edition
Arrow right icon
Authors (3):
Arrow left icon
Loonycorn Ravi Loonycorn Ravi
Author Profile Icon Loonycorn Ravi
Loonycorn Ravi
Judy Raj Judy Raj
Author Profile Icon Judy Raj
Judy Raj
Vitthal Srinivasan Vitthal Srinivasan
Author Profile Icon Vitthal Srinivasan
Vitthal Srinivasan
Arrow right icon
View More author details
Toc

Table of Contents (19) Chapters Close

Preface 1. The Case for Cloud Computing FREE CHAPTER 2. Introduction to Google Cloud Platform 3. Compute Choices – VMs and the Google Compute Engine 4. GKE, App Engine, and Cloud Functions 5. Google Cloud Storage – Fishing in a Bucket 6. Relational Databases 7. NoSQL Databases 8. BigQuery 9. Identity and Access Management 10. Managing Hadoop with Dataproc 11. Load Balancing 12. Networking in GCP 13. Logging and Monitoring 14. Infrastructure Automation 15. Security on the GCP 16. Pricing Considerations 17. Effective Use of the GCP 18. Other Books You May Enjoy

Relational databases, SQL, and schemas

The heart of the RDBMS is the relational data model; data is expressed in rows and columns within tables. The names and types of the columns are defined up-front and are collectively called the schema. The rows represent the data stored in the RDBMS and can be accessed using a very popular language called SQL.

In the preceding tables, each account holder has two accounts, one savings account and one current account, and each has different balances. This can be expressed in RDBMS like in the example given below. Here you can see that each account holder is given a unique key (Customer_ID), which makes querying for savings or current account balance a lot easier and faster:

In these tables, the column definitions are the schemas: for instance, the schemas of both relations Current Accounts and Savings Accounts have three columns named Acc_ID...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime