3 hours EN / DE Max 50

AlloyDB Essentials

This course explores the benefits of AlloyDB, especially compared to PostgreSQL on Cloud SQL. It will walk you through AlloyDB’s unique architecture, and explain how to configure deployments on Google Cloud.The course is divided into two parts: AlloyDB Administration Essentials (architecture and configuration) and AlloyDB Optimization Essentials (performance tuning).

€295,00 excl. VAT

Individual scheduling

The courses are held as dedicated group sessions. Once you've booked, we'll coordinate a date that works for your team and send invitations to all participants.

Prerequisites

  • Participants should be comfortable working in Google Cloud with Cloud Shell and the Google Cloud Console.
  • Basic knowledge of PostgreSQL management is required.
  • Preliminary knowledge of Cloud SQL and general database administrative tasks is considered useful.

What you'll learn

  • Understand the differences between AlloyDB and Cloud SQL.
  • Describe AlloyDB's architecture and its specific advantages for demanding enterprise workloads.
  • Create and manage an AlloyDB instance.
  • Leverage Index Advisor recommendations to significantly improve query performance.
  • Use Adaptive Autovacuum to dynamically free up database resources.
  • Describe and configure the Columnar Engine to accelerate analytical queries.

Course modules
Traditional PostgreSQL: Monolithic limitations Cloud SQL: Monolithic scaling AlloyDB: Cloud-native design AlloyDB: Performance advantages AlloyDB: Intelligent storage
Disaggregated storage WAL processing Read pool scaling Automatic data tiering Dynamic shard mapping
Instance configuration Network connectivity Connection methods Scaling instances Backup and recovery Additional Resources
Knowledge checks regarding AlloyDB Administration Essentials
DBA tasks Indexing challenges Database indexes Index advisor: Smart recommendations Performance gains
MVCC (Multi-Version Concurrency Control) overview VACUUM purpose Adaptive autovacuum: Dynamic resource management Performance improvement
Row vs. Columnar: Storage differences Analytical efficiency In-memory engine Metadata optimization Execution modes Additional Resources
Knowledge checks regarding AlloyDB Optimization Essentials
AlloyDB Essentials