Storing Data on Google Cloud for Data Engineers

Selecting and designing storage for analytics and operational data: BigQuery, Bigtable, Spanner, Cloud SQL, AlloyDB, Firestore and Cloud Storage data lakes.

GCP-312 12 lessons planned ▶ Video lessons coming soon

Offered by HSM University · Google Cloud Certification Prep

Course content

  1. 1Choosing storage by access patternComing
  2. 2BigQuery storage designComing
  3. 3Partitioning and clustering strategiesComing
  4. 4BigLake and open table formatsComing
  5. 5Cloud Storage as a data lakeComing
  6. 6Bigtable schema designComing
  7. 7Spanner schema and interleavingComing
  8. 8Cloud SQL and AlloyDB for operational dataComing
  9. 9Firestore data modellingComing
  10. 10Data warehouse modellingComing
  11. 11Lifecycle, retention and archivingComing
  12. 12Lab walkthrough: storage for a ride-sharing serviceComing

Requirements

Recommended background. You can start any course at any time.

Description

Selecting and designing storage for analytics and operational data: BigQuery, Bigtable, Spanner, Cloud SQL, AlloyDB, Firestore and Cloud Storage data lakes.