{"course":{"productid":36162,"modality":1,"active":true,"language":"fr","title":"AlloyDB Essentials","productcode":"ADBE","vendorcode":"GO","vendorname":"Google","fullproductcode":"GO-ADBE","courseware":{"has_ekit":false,"has_printkit":true,"language":""},"url":"https:\/\/portal.flane.ch\/course\/google-adbe","objective":"<p><strong>Part 1:<\/strong>\n<\/p>\n<ul>\n<li>Understand the differences between AlloyDB and Cloud SQL.<\/li><li>Describe Alloy DB&#039;s architecture and its advantages for demanding workloads.<\/li><li>Create and manage an AlloyDB instance.<\/li><\/ul><p>\n<strong>Part 2:<\/strong>\n<\/p>\n<ul>\n<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>","essentials":"<ul>\n<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>","audience":"<ul>\n<li>Data Engineers<\/li><li>Database Administrators<\/li><\/ul>","outline":"<h5><strong>Topic 0 - Course Introduction<\/strong><\/h5><p>\n<strong>Topics:<\/strong>\n<\/p>\n<ul>\n<li>Introductions<\/li><li>Course format<\/li><li>Etiquette<\/li><li>Target audience and Prerequisite knowledge<\/li><li>Agenda<\/li><\/ul><p>\n<strong>Learning Objectives:<\/strong>\n<\/p>\n<ul>\n<li>N\/A<\/li><\/ul><h4>Part 1 -  AlloyDB Administration Essentials<\/h4>\n<h5>Topic 1 - The Value of AlloyDB<\/h5><p>\n<strong>Topics:<\/strong>\n<\/p>\n<ul>\n<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>\n<strong>Learning Objectives:<\/strong>\n<\/p>\n<ul>\n<li>Understand the differences between AlloyDB and Cloud SQL<\/li><\/ul><h5>Topic 2 - Architecture Overview<\/h5><p>\n<strong>Topics:<\/strong>\n<\/p>\n<ul>\n<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>\n<strong>Learning Objectives:<\/strong>\n<\/p>\n<ul>\n<li>Describe AlloyDB&rsquo;s architecture and its advantages for demanding workloads.<\/li><\/ul>\n<h5>Topic 3 - Get Started with AlloyDB<\/h5><p>\n<strong>Topics<\/strong>\n<\/p>\n<ul>\n<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>\n<strong>Learning Objectives:<\/strong>\n<\/p>\n<ul>\n<li>Create and manage an AlloyDB instance.<\/li><\/ul><h5>Topic 4 - AlloyDB Administration Essentials Quiz<\/h5><p>\n<strong>Topics<\/strong>\n<\/p>\n<ul>\n<li>Knowledge checks re AlloyDB Administration Essentials<\/li><\/ul><p>\n<strong>Learning Objectives:<\/strong>\n<\/p>\n<ul>\n<li>Understand the differences between AlloyDB and Cloud SQL.<\/li><li>Describe AlloyDB&#039;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>\n<h5>Topic 1 - Index advisor<\/h5><p>\n<strong>Topics<\/strong>\n<\/p>\n<ul>\n<li>DBA tasks<\/li><li>Indexing challenges<\/li><li>Database indexes<\/li><li>Index advisor: Smart recommendations.<\/li><li>Performance gains<\/li><\/ul><p>\n<strong>Learning Objectives:<\/strong>\n<\/p>\n<ul>\n<li>Leverage Index Advisor recommendations to improve query performance.<\/li><\/ul><h5>Topic 2 -Adaptive autovacuum<\/h5><p>\n<strong>Topics<\/strong>\n<\/p>\n<ul>\n<li>MVCC overview<\/li><li>VACUUM purpose<\/li><li>Adaptive autovacuum: Dynamic resource management.<\/li><li>Performance improvement<\/li><\/ul><p>\n<strong>Learning Objectives:<\/strong>\n<\/p>\n<ul>\n<li>Use Adaptive Autovacuum to free up database resources.<\/li><\/ul><h5>Topic 3 - Columnar Engine<\/h5><p>\n<strong>Topics<\/strong>\n<\/p>\n<ul>\n<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>\n<strong>Learning Objectives:<\/strong>\n<\/p>\n<ul>\n<li>Describe and configure the Columnar Engine to speed up analytical queries.<\/li><\/ul>\n<h5>Topic 4 - AlloyDB Optimization Essentials Quiz<\/h5><p>\n<strong>Topics<\/strong>\n<\/p>\n<ul>\n<li>Knowledge checks re AlloyDB Optimization Essentials<\/li><\/ul><p>\n<strong>Learning Objectives:<\/strong>\n<\/p>\n<ul>\n<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>","summary":"<p>This course explores the benefits of AlloyDB, especially compared to PostgreSQL on Cloud SQL. It will walk yo through AlloyDB&#039;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).<\/p>","objective_plain":"Part 1:\n\n\n\n- Understand the differences between AlloyDB and Cloud SQL.\n- Describe Alloy DB's architecture and its advantages for demanding workloads.\n- Create and manage an AlloyDB instance.\n\nPart 2:\n\n\n\n- Leverage Index Advisor recommendations to improve query performance.\n- Use Adaptive Autovacuum to free up database resources.\n- Describe and configure he Columnar Engine to speed up analytical queries.","essentials_plain":"- Comfortable working in Google Cloud with Cloud Shell and the Google Cloud Console.\n- Basic knowledge of PostgreSQL management.\n- Basic knowledge of Cloud SQL and database administrative tasks is useful.","audience_plain":"- Data Engineers\n- Database Administrators","outline_plain":"Topic 0 - Course Introduction\n\n\nTopics:\n\n\n\n- Introductions\n- Course format\n- Etiquette\n- Target audience and Prerequisite knowledge\n- Agenda\n\nLearning Objectives:\n\n\n\n- N\/A\nPart 1 -  AlloyDB Administration Essentials\n\n\nTopic 1 - The Value of AlloyDB\n\n\nTopics:\n\n\n\n- Traditional PostgreSQL: Monolithic limitations\n- Cloud SQL: Monolithic scaling\n- AlloyDB: Cloud-native design\n- AlloyDB: Performance advantages\n- AlloyDB: Intelligent storage\n\nLearning Objectives:\n\n\n\n- Understand the differences between AlloyDB and Cloud SQL\nTopic 2 - Architecture Overview\n\n\nTopics:\n\n\n\n- Disaggregated storage\n- WAL processing\n- Read pool scaling\n- Automatic data tiering\n- Dynamic shard mapping\n\nLearning Objectives:\n\n\n\n- Describe AlloyDB\u2019s architecture and its advantages for demanding workloads.\n\nTopic 3 - Get Started with AlloyDB\n\n\nTopics\n\n\n\n- Instance configuration\n- Network connectivity\n- Connection methods\n- Scaling instances\n- Backup and recovery\n- Additional Resources\n\nLearning Objectives:\n\n\n\n- Create and manage an AlloyDB instance.\nTopic 4 - AlloyDB Administration Essentials Quiz\n\n\nTopics\n\n\n\n- Knowledge checks re AlloyDB Administration Essentials\n\nLearning Objectives:\n\n\n\n- Understand the differences between AlloyDB and Cloud SQL.\n- Describe AlloyDB's architecture and its advantages for demanding workloads\n- Create and manage an Alloy DB instance\nPart 2 - AlloyDB Optimization Essentials\n\n\nTopic 1 - Index advisor\n\n\nTopics\n\n\n\n- DBA tasks\n- Indexing challenges\n- Database indexes\n- Index advisor: Smart recommendations.\n- Performance gains\n\nLearning Objectives:\n\n\n\n- Leverage Index Advisor recommendations to improve query performance.\nTopic 2 -Adaptive autovacuum\n\n\nTopics\n\n\n\n- MVCC overview\n- VACUUM purpose\n- Adaptive autovacuum: Dynamic resource management.\n- Performance improvement\n\nLearning Objectives:\n\n\n\n- Use Adaptive Autovacuum to free up database resources.\nTopic 3 - Columnar Engine\n\n\nTopics\n\n\n\n- Row vs. Columnar: Storage differences.\n- Analytical efficiency\n- In-memory engine\n- Metadata optimization\n- Execution modes\n- Additional Resources\n\nLearning Objectives:\n\n\n\n- Describe and configure the Columnar Engine to speed up analytical queries.\n\nTopic 4 - AlloyDB Optimization Essentials Quiz\n\n\nTopics\n\n\n\n- Knowledge checks re AlloyDB Optimization Essentials\n\nLearning Objectives:\n\n\n\n- Leverage Index Advisor recommendations to improve query performance.\n- Use Adaptive Autovacuum to free up database resources.\n- Describe and configure the Columnar Engine to speed up analytical queries.","summary_plain":"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).","skill_level":"Intermediate","version":"1.0","duration":{"unit":"d","value":0,"formatted":"3 heures"},"pricelist":{"List Price":{"US":{"country":"US","currency":"USD","taxrate":null,"price":350},"CA":{"country":"CA","currency":"CAD","taxrate":null,"price":485},"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":350},"IL":{"country":"IL","currency":"EUR","taxrate":17,"price":350},"AT":{"country":"AT","currency":"EUR","taxrate":20,"price":350},"SE":{"country":"SE","currency":"EUR","taxrate":25,"price":350},"SI":{"country":"SI","currency":"EUR","taxrate":20,"price":350},"GB":{"country":"GB","currency":"GBP","taxrate":20,"price":350},"IT":{"country":"IT","currency":"EUR","taxrate":20,"price":350},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":350}}},"lastchanged":"2025-09-30T16:07:40+02:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-course-schedule\/36162","source_lang":"fr","source":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-course\/google-adbe"}}