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).
- Duration: 3 hours
- Languages: English, German
- Level: Intermediate
- Group size: Up to 50
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.
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.
Course outline
The Value of AlloyDB
- Traditional PostgreSQL: Monolithic limitations
- Cloud SQL: Monolithic scaling
- AlloyDB: Cloud-native design
- AlloyDB: Performance advantages
- AlloyDB: Intelligent storage
Architecture Overview
- Disaggregated storage
- WAL processing
- Read pool scaling
- Automatic data tiering
- Dynamic shard mapping
Get Started with AlloyDB
- Instance configuration
- Network connectivity
- Connection methods
- Scaling instances
- Backup and recovery
- Additional Resources
AlloyDB Administration Essentials Quiz
- Knowledge checks regarding AlloyDB Administration Essentials
Index Advisor
- DBA tasks
- Indexing challenges
- Database indexes
- Index advisor: Smart recommendations
- Performance gains
Adaptive Autovacuum
- MVCC (Multi-Version Concurrency Control) overview
- VACUUM purpose
- Adaptive autovacuum: Dynamic resource management
- Performance improvement
Columnar Engine
- Row vs. Columnar: Storage differences
- Analytical efficiency
- In-memory engine
- Metadata optimization
- Execution modes
- Additional Resources
AlloyDB Optimization Essentials Quiz
- Knowledge checks regarding AlloyDB Optimization Essentials
Related courses
BigQuery for Data Analysts
This course is designed for data analysts who want to learn about using BigQuery for their data analysis needs. Through a combination of videos, labs, and demos, we cover various topics that discuss how to ingest, transform, and query your data in BigQuery to derive insights that can help in business decision-making.
Data Engineering on Google Cloud
Get hands-on experience with designing and building data processing systems on Google Cloud. This course uses lectures, demos, and hands-on labs to show you how to design data processing systems, build end-to-end data pipelines, analyze data, and implement machine learning. This course covers structured, unstructured, and streaming data.
Data Integration with Cloud Data Fusion
This 2-day course introduces learners to Google Cloud’s data integration capability using Cloud Data Fusion. In this course, we discuss challenges with data integration and the need for a data integration platform (middleware). We then discuss how Cloud Data Fusion can help to effectively integrate data from a variety of sources and formats and generate insights. We take a look at Cloud Data Fusion’s main components and how they work, how to process batch data and real time streaming data with visual pipeline design, rich tracking of metadata and data lineage, and how to deploy data pipelines on various execution engines.
Not sure which course fits?
Book a 30-minute call. We'll look at where your team is, what they need to be able to do, and put together either a specific course date or a tailored learning plan.