Course
Digicomp Code ALLDBE
AlloyDB Essentials («ALLDBE»)
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.
Duration
0.5 days
Price
450.–
Course documents
Official Google Cloud courseware
Course facts
Part 1:
- Understanding the differences between AlloyDB and Cloud SQL
- Describing AlloyDB’s architecture and its advantages for demanding workloads
- Creating and managing an AlloyDB instance
Part 2:
- Leveraging Index Advisor recommendations to improve query performance
- Using Adaptive Autovacuum to free up database resources
- Describing and configuring the Columnar Engine to speed up analytical queries
The course is divided into two parts: AlloyDB Administration Essentials (architecture and configuration) and AlloyDB Optimization Essentials (performance tuning).
Part 1: AlloyDB Administration Essentials
1 The Value of AlloyDB
- Traditional PostgreSQL: Monolithic limitations
- Cloud SQL: Monolithic scaling
- AlloyDB: Cloud-native design
- AlloyDB: Performance advantages
- AlloyDB: Intelligent storage
- Understanding the differences between AlloyDB and Cloud SQL
2 Architecture Overview
- Disaggregated storage
- WAL processing
- Read pool scaling
- Automatic data tiering
- Dynamic shard mapping
- Describing AlloyDB’s architecture and its advantages for demanding workloads
3 Get Started with AlloyDB
- Instance configuration
- Network connectivity
- Connection methods
- Scaling instances
- Backup and recovery
- Additional Resources
- Creating and managing an AlloyDB instance
4 AlloyDB Administration Essentials Quiz
- Knowledge checks re AlloyDB Administration Essentials
- Understanding the differences between AlloyDB and Cloud SQL
- Describing AlloyDB’s architecture and its advantages for demanding workloads
- Creating and managing an AlloyDB instance
Part 2: AlloyDB Optimization Essentials
1 Index advisor
- DBA tasks
- Indexing challenges
- Database indexes
- Index advisor: Smart recommendations
- Performance gains
- Leveraging Index Advisor recommendations to improve query performance
2 Adaptive autovacuum
- MVCC overview
- VACUUM purpose
- Adaptive autovacuum: Dynamic resource management.
- Performance improvement
- Using Adaptive Autovacuum to free up database resources
3 Columnar Engine
- Row vs. Columnar: Storage differences
- Analytical efficiency
- In-memory engine
- Metadata optimization
- Execution modes
- Additional Resources
- Describing and configuring the Columnar Engine to speed up analytical queries
4 AlloyDB Optimization Essentials Quiz
- Knowledge checks re: AlloyDB Optimization Essentials
- Understanding the differences between AlloyDB and Cloud SQL
- Leveraging Index Advisor recommendations to improve query performance
- Using Adaptive Autovacuum to free up database resources
- Describing and configuring the Columnar Engine to speed up analytical queries
Data Engineers and Database Administrators
- 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