🏆SFEIR is the Google Cloud EMEA Training Partner of the Year 2025🤝New partnership: Official GitLab Training🤖New training: AI-Augmented Developer
🏆SFEIR is the Google Cloud EMEA Training Partner of the Year 2025🤝New partnership: Official GitLab Training🤖New training: AI-Augmented Developer
GCPSPARKSALLOYDB

AlloyDB Essentials Training

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).

Google Cloud
✓ Official training Google CloudLevel Intermediate⏱️ 0.5 day (3h)

What you will learn

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

Prerequisites

  • Comfortable working in Google Cloud with Cloud Shell and the Google Cloud Console.
  • Basic knowledge of PostgreSQL management.
  • Basic knowledge of Cloud SQL and database administrative tasks is useful.

Target audience

  • Data Engineers and Database Administrators

Training Program

8 modules to master the fundamentals

Course 1 : AlloyDB Administration Essentials

Objectives
  • Understand the differences between AlloyDB and Cloud SQL.
Topics covered
  • →Traditional PostgreSQL: Monolithic limitations
  • →Cloud SQL: Monolithic scaling
  • →AlloyDB: Cloud-native design
  • →AlloyDB: Performance advantages
  • →AlloyDB: Intelligent storage
Objectives
  • Describe AlloyDB's architecture and its advantages for demanding workloads.
Topics covered
  • →Disaggregated storage
  • →WAL processing
  • →Read pool scaling
  • →Automatic data tiering
  • →Dynamic shard mapping
Objectives
  • Create and manage an AlloyDB instance.
Topics covered
  • →Instance configuration
  • →Network connectivity
  • →Connection methods
  • →Scaling instances
  • →Backup and recovery
  • →Additional Resources
Objectives
  • Understand the differences between AlloyDB and Cloud SQL.
  • Describe AlloyDB's architecture and its advantages for demanding workloads.
  • Create and manage an AlloyDB instance.
Topics covered
  • →Knowledge checks re AlloyDB Administration Essentials

Course 2 : AlloyDB Optimization Essentials

Objectives
  • Leverage Index Advisor recommendations to improve query performance.
Topics covered
  • →DBA tasks
  • →Indexing challenges
  • →Database indexes
  • →Index advisor: Smart recommendations.
  • →Performance gains
Objectives
  • Use Adaptive Autovacuum to free up database resources.
Topics covered
  • →MVCC overview
  • →VACUUM purpose
  • →Adaptive autovacuum: Dynamic resource management.
  • →Performance improvement
Objectives
  • Describe and configure the Columnar Engine to speed up analytical queries.
Topics covered
  • →Row vs. Columnar: Storage differences.
  • →Analytical efficiency
  • →In-memory engine
  • →Metadata optimization
  • →Execution modes
  • →Additional Resources
Objectives
  • Understand the differences between AlloyDB and Cloud SQL.
  • Leverage Index Advisor recommendations to improve query performance.
  • Use Adaptive Autovacuum to free up database resources.
  • Describe and configure the Columnar Engine to speed up analytical queries.
Topics covered
  • →Knowledge checks re AlloyDB Optimization Essentials

Related Trainings

Google Cloud

Introduction to Data Analytics on Google Cloud

This course is an introduction to data analytics on Google Cloud. It is designed for learners who have no prior experience with data analytics or Google Cloud. The course covers the basics of data analysis, including collection, storage, exploration, visualization, and sharing. It also introduces learners to Google Cloud's data analytics tools and services. Through video lectures, demos, quizzes, and hands-on labs, the course demonstrates how to go from raw data to impactful visualizations and dashboards.

1 d
Fundamental
Google Cloud

Analyzing and Visualizing Data in Looker

In this course, you learn how to do the kind of data exploration and analysis in Looker that would formerly be done primarily by SQL developers or analysts. You learn to leverage Looker's modern analytics platform to find and explore relevant content in your organization's Looker instance. You also discover how to ask questions of your data, create new metrics as needed, and build and share visualizations and dashboards to facilitate data-driven decision-making.

1 d
Fundamental
View all trainings →

Upcoming sessions

No date suits you?

We regularly organize new sessions. Contact us to find out about upcoming dates or to schedule a session at a date of your choice.

Register for a custom date

Quality Process

SFEIR Institute's commitment: an excellence approach to ensure the quality and success of all our training programs. Learn more about our quality approach

Teaching Methods Used
  • Lectures / Theoretical Slides — Presentation of concepts using visual aids (PowerPoint, PDF).
  • Technical Demonstration (Demos) — The instructor performs a task or procedure while students observe.
  • Quiz / MCQ — Quick knowledge check (paper-based or digital via tools like Kahoot/Klaxoon).
Evaluation and Monitoring System

The achievement of training objectives is evaluated at multiple levels to ensure quality:

  • Continuous Knowledge Assessment : Verification of knowledge throughout the training via participatory methods (quizzes, practical exercises, case studies) under instructor supervision.
  • Progress Measurement : Comparative self-assessment system including an initial diagnostic to determine the starting level, followed by a final evaluation to validate skills development.
  • Quality Evaluation : End-of-session satisfaction questionnaire to measure the relevance and effectiveness of the training as perceived by participants.

Frequently Asked Questions

This course is for database administrators, data engineers, and developers who work with PostgreSQL and want to deploy, administer, and optimize AlloyDB on Google Cloud.
A working knowledge of relational databases and PostgreSQL is recommended, as this is an intermediate, level-200 course.
You will learn how AlloyDB differs from Cloud SQL, its unique architecture, how to create and manage an instance, and how to tune performance with Index Advisor, Adaptive Autovacuum, and the Columnar Engine.
The AlloyDB Optimization Essentials part covers Index Advisor recommendations to improve queries, Adaptive Autovacuum to free up resources, and the Columnar Engine to speed up analytical queries.
The course lasts 3 hours and is instructor-led, structured into an administration part and an optimization part, each with a quiz.
Yes. This is an official Google Cloud Sparks course delivered by SFEIR Institute, a certified Google Cloud Training Partner.

395€ excl. VAT

per learner

ReserveQuote