Google Cloud Data and Storage Foundations
1h 44mBeginner2024-06-11
Authors
Mark Johnson
Google Cloud Solutions Architect and Google Developer Expert
Course details
Google Cloud remains one of the most popular cloud platforms, and in this course, instructor Mark Johnson covers the fundamentals of storage on GCP. Mark begins with an overview of object storage on GCP and then dives into both relational and non-relational databases. GCP services like Firestore, Bigtable, and Cloud Spanner are covered. He wraps up with an introduction to data warehousing and analytics.
Skills covered
Data Resource ManagementCloud StorageGoogle Cloud PlatformDatabase ManagementGoogleSoftware Development ToolsCloud PlatformsLearningCloud ComputingSoftware Development
Concepts
Introduction
- Google Cloud storage and databases
Object Storage on GCP
- Understanding your storage and database options
- What does object storage look like
- Popular Google Cloud storage features
- Optimizing Cloud Storage Costs with Autoclass
- Demo - Migrating data in Cloud Storage
Relational Databases
- Understanding relational database options on GCP
- Enterprise PostgreSQL with AlloyDB
- Relational databases - When to use Cloud SQL or Cloud Spanner
- The benefits of using Cloud SQL and Cloud Spanner
- Demo - Connecting to GCP from a WordPress app
Non-Relational Databases
- Understanding non-relational database options on GCP
- Non-relational databases - When to use Cloud Firestore or Cloud Bigtable
- Demo - Setting up a Firestore and Bigtable database
Data Warehouse and Analytics
- Using BigQuery as a data warehouse
- Why use BigQuery instead of Cloud SQL or Cloud Spanner
- Demo - Creating an interactive report in Data Studio
Conclusion
- Next steps