Course Overview
This course explores the benefits of AlloyDB, especially compared to PostgreSQL on Cloud SQL. It will walk yo 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).
Who should attend
- Data Engineers
- 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.
Course Objectives
Part 1:
- Understand the differences between AlloyDB and Cloud SQL.
- Describe Alloy DB's architecture and its advantages for demanding workloads.
- Create and manage an AlloyDB instance.
Part 2:
- Leverage Index Advisor recommendations to improve query performance.
- Use Adaptive Autovacuum to free up database resources.
- Describe and configure he Columnar Engine to speed up analytical queries.