|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/google-cloud-professional-database-engineer-exam-prep/
课程评论：没有评论
**课程名称：** Google Cloud 专业数据库工程师考试准备 **课程概述：** 本课程（2023年1月更新）旨在帮助学员准备 Google Cloud 专业数据库工程师考试，涵盖了设计、部署、安全、维护和迁移高度可扩展、高可用性数据库的必备技能和实用经验。 **主要学习内容：** * **数据库选型：** 详细介绍 Cloud SQL, Cloud Spanner, Cloud Firestore, Bigtable, BigQuery, 以及 AlloyDB 的适用场景。 * **数据库管理：** 学习创建托管数据库实例、用户管理、高可用性计划、数据库安全最佳实践、数据库创建与克隆、安全连接。 * **监控与运维：** 掌握数据库监控、日志记录、告警设置，以及导入、导出和备份的最佳实践。 * **数据迁移：** 深入理解数据迁移流程，学习如何执行数据库迁移，包括使用 Datastream, Database Migration Service 和 Oracle Bare Metal 等专用服务。 * **性能调优：** 学习估算数据库大小、配置 IOPS 以满足性能要求。 * **特定数据库深入：** * **Cloud SQL:** 学习其特性、管理和维护。 * **AlloyDB:** 了解其作为 PostgreSQL 增强版本，支持 OLTP 和分析工作负载。 * **Cloud Spanner:** 掌握其全球可扩展的托管关系型数据库特性。 * **BigQuery:** 学习作为数据仓库的服务，包括数据集导航、分区、聚类和数据访问控制。 * **Bigtable:** 学习创建实例、添加集群、设计高性能的多维模式。 * **Cloud Firestore:** 了解其作为文档数据库的灵活模式、索引和查询语言。 * **数据库维护与故障排除：** 学习估算数据库大小、监控数据库、配置安全与网络。 * **变更数据捕获 (CDC) 与迁移：** 学习使用 Datastream 进行 CDC，并深入理解数据库迁移的关键环节，包括数据一致性、差量查询、切换操作和回滚计划。 **课程目标：** 通过本课程，学员将能够自信地应对 Google Cloud 专业数据库工程师考试，并掌握在 Google Cloud 环境中管理高性能数据库所需的关键技能，从而提升职业发展。
Jan 2023: Newly updated with additional material on database migration, meeting performance requirements, Oracle migrations, and more.Databases are the foundation of many of the applications and services that we use every day. Keeping them up and running is the responsibility of database engineers. In this course, you will learn essential skills and hear hard-learned lessons about designing, deploying, securing, maintaining and migrating highly scalable and highly available databases. By the end of the course, you'll be ready to take the Google Cloud Professional Database Engineer Exam and take on the responsibilities of a database engineer working in Google Cloud.The course begins with an introduction to relational databases and working with Cloud SQL, a regional, managed database service provided by Google Cloud. You will learn:When to use Cloud SQL, Cloud Spanner, Cloud Firestore, Bigtable, BigQuery, and AlloyDBHow to create database instance in managed database servicesManaging usersPlanning for high availability and reliabilityDatabase security best practicesCreating, managing, and cloning databasesConnecting securely to your databasesMonitoring, logging, and alertingBest practices for importing, exporting, and backing up your databasesUnderstanding data migration processes and how to execute database migrationsUsing specialized services, like Datastream, Database Migration Service and Oracle Bare MetalUnderstanding how to estimate database sizes and configure IOPS to meet performance requirementsWe'll also cover database maintenance and how to migrate a self-managed database to Cloud SQL. But we don't stop with Cloud SQL. Google Cloud offers AlloyDB, a scalable PostreSQL implementation that is designed to support both online transaction processing and analytical workloads. You will also learn about Cloud Spanner, the managed, globally scalable relational database offered by Google Cloud.In addition to relational databases, we dig into the details of BigQuery, a petabyte scale data warehouse, and analytics service. You'll learn how to use BigQuery's console to navigate datasets, organize data using partitioning and clustering, and control access to data in BigQuery. Bigtable and Cloud Firestore are two managed NoSQL databases available in Google Cloud. In this course, you'll see how to create Bigtable databases, add clusters to a Bigtable instance, and design multidimensional schemas that are highly performant in Bigtable. You'll also learn about Cloud Firestore, a document database, that provides flexible schemas while also offering indexing and a query language that makes it an ideal choice for a database backend for many services.In addition to knowing about different kinds of databases and when to use them, database engineers have to maintain and troubleshoot databases. This course will help you learn how to estimate the size of databases, monitor databases as well as configure security and networking for databases. You'll also learn about essential data management practices including change data capture (CDC) using Datastream and database migration using Database Migration Service.Database migrations are an essential step to deploying applications and services in the cloud and they are some of the most challenging operations to plan and execute. This course includes in-depth lectures on the characteristics of database migrations, database migration processes, executing database migrations, ensuring data consistency between source and target databases, using change data capture and differential querying, draining and switchover, as well as fallback planning.Database engineers are in demand because they understand how to build, deploy, and manage critical information infrastructure. Google Cloud has developed the Professional Cloud Database Engineer certification to distinguish database engineers with the necessary skills to operate high-performance databases in production environments in Google Cloud. Join us in this course to advance your career as a certified Professional Database Engineer.
