Professional Cloud Database Engineer (PCDE)
Build real cloud skills with guided labs on AWS and Google Cloud. Practice in live environments with instant access to real cloud resources. No cloud account required.
2 labs available
In this lab, you will create a cost-effective and resilient migration setup to transfer a MySQL database from an on-premises environment to a managed Cloud SQL instance. You will use Google's Database Migration Service (DMS) to ensure minimal downtime during the cutover process. Additionally, you'll explore the use of high availability features of Cloud SQL and strategies for managing database scaling needs. The lab will also guide you on setting up a reverse replication channel back to an on-premises MySQL instance, crucial for contingency planning. This real-world use case helps prepare you to address scenarios of database migration with the added complexity of syncing changes, all while operating within budget constraints.
In this lab, you will execute a comprehensive database migration strategy using Cloud SQL and the Database Migration Service (DMS). You'll design downtime-optimized migration plans, implement reverse replication, and evaluate different migration tools. Your focus will be on real-world scenarios where minimal service disruption is paramount.
3 labs available
In this lab, you will design and implement a high availability database architecture using Google Cloud SQL. You will configure read replicas and failover replicas to ensure continuity and high availability across regions. This hands-on experience will provide practical insights into setting up a multi-regional HA architecture, understanding the performance implications, and managing failover processes effectively.
This advanced lab guides you through designing a multi-regional architecture using Cloud SQL and Cloud Spanner to ensure high availability and disaster recovery for a fictitious financial services company. You will configure read replicas, set up backup and recovery procedures, and utilize SQL Insights to monitor and optimize performance. The focus will be on balancing availability, cost, and performance to meet strict SLA requirements.
In this lab, students will design and implement a highly available database architecture using Cloud SQL. They will configure read replicas for load balancing, set up failover replicas for high availability, and implement point-in-time recovery (PITR) to ensure data durability. Participants will learn to evaluate costs and performance trade-offs in their configurations.
2 labs available
In this advanced lab, you will build a secure and scalable database infrastructure using Google Cloud SQL and Cloud Spanner. The lab focuses on integrating these database services to handle a high volume of transactions with low latency while providing robust security configurations such as IAM and CMEK. By completing this lab, you'll gain hands-on experience in setting up databases that balance cost, performance, and security for enterprise environments.
In this advanced lab, you will simulate the database needs of a growing enterprise that requires high availability, scalability, and disaster recovery. You'll deploy and manage a Cloud SQL instance for transactional operations and integrate it with Cloud Spanner for global consistency and high throughput analytics. You will address access management, performance optimization, and cost efficiency while ensuring data safety through comprehensive backup and recovery strategies.
1 lab available
In this lab, you will configure a highly available Cloud SQL instance with read replicas and failover capabilities. You will also automate failover testing and integrate Cloud SQL Insights for robust monitoring. This exercise aims to mimic real-world scenarios where high availability is critical, such as financial services or e-commerce platforms. By the end of this lab, you will have hands-on experience with leveraging Cloud SQL's high availability features to meet stringent uptime SLAs of 99.95%.
