AlloyDB Essentials
Overview
This course explores the benefits of AlloyDB, especially compared to PostgreSQL on Cloud SQL. It walks you through AlloyDB unique architecture and explains 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).
What You'll Learn
- Understand the differences between AlloyDB and Cloud SQL
- Describe AlloyDB 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
Who Should Attend
Data Engineers and Database Administrators
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.
Products Covered
Course Modules
The Value of AlloyDB
Topics
- Traditional PostgreSQL: Monolithic limitations
- Cloud SQL: Monolithic scaling
- AlloyDB: Cloud-native design
- AlloyDB: Performance advantages
- AlloyDB: Intelligent storage
Learning Outcomes
- Understand the differences between AlloyDB and Cloud SQL
Architecture Overview
Topics
- Disaggregated storage
- WAL processing
- Read pool scaling
- Automatic data tiering
- Dynamic shard mapping
Learning Outcomes
- Describe AlloyDB architecture and its advantages for demanding workloads
Get Started with AlloyDB
Topics
- Instance configuration
- Network connectivity
- Connection methods
- Scaling instances
- Backup and recovery
- Additional Resources
Learning Outcomes
- Create and manage an AlloyDB instance
AlloyDB Administration Essentials Quiz
Topics
- Knowledge checks re AlloyDB Administration Essentials
Learning Outcomes
- Understand the differences between AlloyDB and Cloud SQL
- Describe AlloyDB architecture and its advantages for demanding workloads
- Create and manage an AlloyDB instance
Index advisor
Topics
- DBA tasks
- Indexing challenges
- Database indexes
- Index advisor: Smart recommendations
- Performance gains
Learning Outcomes
- Leverage Index Advisor recommendations to improve query performance
Adaptive autovacuum
Topics
- MVCC overview
- VACUUM purpose
- Adaptive autovacuum: Dynamic resource management
- Performance improvement
Learning Outcomes
- Use Adaptive Autovacuum to free up database resources
Columnar Engine
Topics
- Row vs. Columnar: Storage differences
- Analytical efficiency
- In-memory engine
- Metadata optimization
- Execution modes
- Additional Resources
Learning Outcomes
- Describe and configure the Columnar Engine to speed up analytical queries
AlloyDB Optimization Essentials Quiz
Topics
- Knowledge checks re AlloyDB Optimization Essentials
Learning Outcomes
- 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
What's Not Covered
- SQL and RDBMS basics
Get This Training
No public classes currently scheduled. Express interest below or request private training.
Course Details
- Course Code
- CS-ALLESS
- Duration
- 1 day
- Format
- ILT
- Level
- Intermediate
- Modules
- 8
- Price
- Loading...
Questions About This Course?
Contact us for custom scheduling, group discounts, or curriculum customization.
Contact Us