GCP Data Engineer Pro: Google Cloud OLTP Structured Data Storage

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. Google Cloud online transaction processing (OLTP) structured data storage is essential for high availability, scalability, real-time processing, and data integrity, enabling businesses to handle large volumes of data efficiently and securely. In this course, you will explore the architecture and uses of Google Cloud SQL as an OLTP database platform. Discover how business goals like Recovery Point Objective (RPO) and Recovery Time Objective (RTO) influence the selection of Cloud SQL editions. Learn the core tasks involved in managing a Google Cloud SQL database instance, execute database-level management tasks, examine strategies to ensure data availability and access, and implement failback procedures. You will use Google Database Migration Service to migrate existing databases to the Google Cloud Platform (GCP), delve into the functionality of and use cases for Google Cloud Spanner, set up a Spanner instance, and manage it at a high level. Finally, you will establish a database on a Spanner instance and carry out database-level management tasks. This course is one of a collection that prepares learners for the Google Cloud Certified - Professional Data Engineer exam.