
Hands On Google Cloud SQL and Cloud Spanner: Deployment, Administration and Use Cases with Python
Navin / Edward Sabharwal
Résumé
The book begins with the basics of working with the Google Cloud Platform along with an introduction to the database technologies available for developers from Google Cloud.
The book begins with the basics of working with the Google Cloud Platform along with an introduction to the database technologies available for developers from Google Cloud. You'll then take an in-depth hands on journey into Google CloudSQL and CloudSpanner, including choosing the right platform for your application needs, planning, provisioning, designing and developing your application.
Sample applications are given that use Python to connect to CloudSQL and CloudSpanner, along with helpful features provided by the engines. You'll also implement practical best practices in the last chapter. Hands On Google Cloud SQL and Cloud Spanner is a great starting point to apply GCP data offerings in your technology stack and the code used allows you to try out the examples and extend them in interesting ways.
What You'll Learn
- Get started with Big Data technologies on the Google Cloud Platform
- Review CloudSQL and Cloud Spanner from basics to administration
- Apply best practices and use Google's CloudSQL and CloudSpanner offering
- Work with code in Python notebooks and scripts
Application architects, database architects, software developers, data engineers, cloud architects.
Chapter 2: Cloud SQLChapter Goal: Introduce the readers to Google's fully managed SQL database service - CloudSQL.Sub - Topics 2.1 Relational data model2.2 Introduction to Cloud SQL2.3 Getting started with CloudSQL 2.4 Provisioning a MySQL instance2.5 Provisioning a PostgreSQL instance
Chapter 3: Working with CloudSQLChapter Goal: Enable users to work with CloudSQL.Sub - Topics 3.1 Getting started with Cloud Shell3.2 Using CloudSQL with Python
Chapter 4: Administering CloudSQL instancesChapter Goal: Cover the administrative aspects of the database service starting from scaling, high availability, backup to security. Everything which is important from the database administration perspective a user need to be aware of. Sub - Topics 4.1 Backups4.2 Replication4.3 Security
Chapter 5: Cloud SpannerChapter Goal: Introduce the readers to the term NewSQL and then Google's very own NewSQL offerings - Cloud Spanner.Sub - Topics 5.1 What's new in NewSQL5.2 Introduction to Google Cloud Spanner5.3 Origin5.4 Spanner and CAP theorem5.5 Best fit
Chapter 6: Cloud Spanner ExplainedChapter Goal: Enable users to understand Cloud Spanner Data Model and all its important aspects such as the architectural components, replica types, read/write methodology etc. Sub - Topics 6.1 Cloud Spanner objects6.2 Architecture overview6.3 Replica types6.4 Operations6.5 Understanding Operations with an example
Chapter 7: Working with Cloud SpannerChapter Goal: Cover the creation of an instance taking a pause in understanding what happens under the hood, good to know pointers from administrative perspective, following that start working with the schema, read and write using the web console and use the instance with Python code. Sub - Topics 7.1 Create Instance7.2 Create database and schema7.3 Reading and writing data using Cloud Shell7.4 Using CloudSpanner with Python7.5 Wrap up
Chapter 8: Best PracticesChapter Goal: Cover crucial pointers which enables the users to work the way out around the drawbacks or limitations of the offerings
Shakuntala Gupta Edward is an accomplished consultant in areas of data and analytics with 16 years of experience. Shakuntala is a Big Data architect and is responsible for database design, database architecture, best practices for big data technologies, product development using database, Big Data, NOSQL, analytics and machine learning technologies.
Caractéristiques techniques
PAPIER | |
Éditeur(s) | Apress |
Auteur(s) | Navin / Edward Sabharwal |
Parution | 28/12/2019 |
Nb. de pages | 330 |
EAN13 | 9781484255360 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse