AlloyDB EssentialsADBEGOGoogleGO-ADBE1.0<p><strong>Part 1:</strong>
</p>
<ul>
<li>Understand the differences between AlloyDB and Cloud SQL.</li><li>Describe Alloy DB's architecture and its advantages for demanding workloads.</li><li>Create and manage an AlloyDB instance.</li></ul><p>
<strong>Part 2:</strong>
</p>
<ul>
<li>Leverage Index Advisor recommendations to improve query performance.</li><li>Use Adaptive Autovacuum to free up database resources.</li><li>Describe and configure he Columnar Engine to speed up analytical queries.</li></ul><ul>
<li>Comfortable working in Google Cloud with Cloud Shell and the Google Cloud Console.</li><li>Basic knowledge of PostgreSQL management.</li><li>Basic knowledge of Cloud SQL and database administrative tasks is useful.</li></ul><ul>
<li>Data Engineers</li><li>Database Administrators</li></ul><h5><strong>Topic 0 - Course Introduction</strong></h5><p>
<strong>Topics:</strong>
</p>
<ul>
<li>Introductions</li><li>Course format</li><li>Etiquette</li><li>Target audience and Prerequisite knowledge</li><li>Agenda</li></ul><p>
<strong>Learning Objectives:</strong>
</p>
<ul>
<li>N/A</li></ul><h4>Part 1 - AlloyDB Administration Essentials</h4>
<h5>Topic 1 - The Value of AlloyDB</h5><p>
<strong>Topics:</strong>
</p>
<ul>
<li>Traditional PostgreSQL: Monolithic limitations</li><li>Cloud SQL: Monolithic scaling</li><li>AlloyDB: Cloud-native design</li><li>AlloyDB: Performance advantages</li><li>AlloyDB: Intelligent storage</li></ul><p>
<strong>Learning Objectives:</strong>
</p>
<ul>
<li>Understand the differences between AlloyDB and Cloud SQL</li></ul><h5>Topic 2 - Architecture Overview</h5><p>
<strong>Topics:</strong>
</p>
<ul>
<li>Disaggregated storage</li><li>WAL processing</li><li>Read pool scaling</li><li>Automatic data tiering</li><li>Dynamic shard mapping</li></ul><p>
<strong>Learning Objectives:</strong>
</p>
<ul>
<li>Describe AlloyDB’s architecture and its advantages for demanding workloads.</li></ul>
<h5>Topic 3 - Get Started with AlloyDB</h5><p>
<strong>Topics</strong>
</p>
<ul>
<li>Instance configuration</li><li>Network connectivity</li><li>Connection methods</li><li>Scaling instances</li><li>Backup and recovery</li><li>Additional Resources</li></ul><p>
<strong>Learning Objectives:</strong>
</p>
<ul>
<li>Create and manage an AlloyDB instance.</li></ul><h5>Topic 4 - AlloyDB Administration Essentials Quiz</h5><p>
<strong>Topics</strong>
</p>
<ul>
<li>Knowledge checks re AlloyDB Administration Essentials</li></ul><p>
<strong>Learning Objectives:</strong>
</p>
<ul>
<li>Understand the differences between AlloyDB and Cloud SQL.</li><li>Describe AlloyDB's architecture and its advantages for demanding workloads</li><li>Create and manage an Alloy DB instance</li></ul><h4>Part 2 - AlloyDB Optimization Essentials</h4>
<h5>Topic 1 - Index advisor</h5><p>
<strong>Topics</strong>
</p>
<ul>
<li>DBA tasks</li><li>Indexing challenges</li><li>Database indexes</li><li>Index advisor: Smart recommendations.</li><li>Performance gains</li></ul><p>
<strong>Learning Objectives:</strong>
</p>
<ul>
<li>Leverage Index Advisor recommendations to improve query performance.</li></ul><h5>Topic 2 -Adaptive autovacuum</h5><p>
<strong>Topics</strong>
</p>
<ul>
<li>MVCC overview</li><li>VACUUM purpose</li><li>Adaptive autovacuum: Dynamic resource management.</li><li>Performance improvement</li></ul><p>
<strong>Learning Objectives:</strong>
</p>
<ul>
<li>Use Adaptive Autovacuum to free up database resources.</li></ul><h5>Topic 3 - Columnar Engine</h5><p>
<strong>Topics</strong>
</p>
<ul>
<li>Row vs. Columnar: Storage differences.</li><li>Analytical efficiency</li><li>In-memory engine</li><li>Metadata optimization</li><li>Execution modes</li><li>Additional Resources</li></ul><p>
<strong>Learning Objectives:</strong>
</p>
<ul>
<li>Describe and configure the Columnar Engine to speed up analytical queries.</li></ul>
<h5>Topic 4 - AlloyDB Optimization Essentials Quiz</h5><p>
<strong>Topics</strong>
</p>
<ul>
<li>Knowledge checks re AlloyDB Optimization Essentials</li></ul><p>
<strong>Learning Objectives:</strong>
</p>
<ul>
<li>Leverage Index Advisor recommendations to improve query performance.</li><li>Use Adaptive Autovacuum to free up database resources.</li><li>Describe and configure the Columnar Engine to speed up analytical queries.</li></ul>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.- 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.- Data Engineers
- Database AdministratorsTopic 0 - Course Introduction
Topics:
- Introductions
- Course format
- Etiquette
- Target audience and Prerequisite knowledge
- Agenda
Learning Objectives:
- N/A
Part 1 - AlloyDB Administration Essentials
Topic 1 - The Value of AlloyDB
Topics:
- Traditional PostgreSQL: Monolithic limitations
- Cloud SQL: Monolithic scaling
- AlloyDB: Cloud-native design
- AlloyDB: Performance advantages
- AlloyDB: Intelligent storage
Learning Objectives:
- Understand the differences between AlloyDB and Cloud SQL
Topic 2 - Architecture Overview
Topics:
- Disaggregated storage
- WAL processing
- Read pool scaling
- Automatic data tiering
- Dynamic shard mapping
Learning Objectives:
- Describe AlloyDB’s architecture and its advantages for demanding workloads.
Topic 3 - Get Started with AlloyDB
Topics
- Instance configuration
- Network connectivity
- Connection methods
- Scaling instances
- Backup and recovery
- Additional Resources
Learning Objectives:
- Create and manage an AlloyDB instance.
Topic 4 - AlloyDB Administration Essentials Quiz
Topics
- Knowledge checks re AlloyDB Administration Essentials
Learning Objectives:
- Understand the differences between AlloyDB and Cloud SQL.
- Describe AlloyDB's architecture and its advantages for demanding workloads
- Create and manage an Alloy DB instance
Part 2 - AlloyDB Optimization Essentials
Topic 1 - Index advisor
Topics
- DBA tasks
- Indexing challenges
- Database indexes
- Index advisor: Smart recommendations.
- Performance gains
Learning Objectives:
- Leverage Index Advisor recommendations to improve query performance.
Topic 2 -Adaptive autovacuum
Topics
- MVCC overview
- VACUUM purpose
- Adaptive autovacuum: Dynamic resource management.
- Performance improvement
Learning Objectives:
- Use Adaptive Autovacuum to free up database resources.
Topic 3 - Columnar Engine
Topics
- Row vs. Columnar: Storage differences.
- Analytical efficiency
- In-memory engine
- Metadata optimization
- Execution modes
- Additional Resources
Learning Objectives:
- Describe and configure the Columnar Engine to speed up analytical queries.
Topic 4 - AlloyDB Optimization Essentials Quiz
Topics
- Knowledge checks re AlloyDB Optimization Essentials
Learning Objectives:
- 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.3 hours350.00485.00350.00350.00350.00350.00350.00350.00350.00350.00