Google Cloud Database Engineer Specialization Course Syllabus

Overview: This specialization equips learners with the skills needed to become a proficient Cloud Database Engineer on Google Cloud Platform. Through a series of hands-on labs and practical exercises, you'll learn how to plan, execute, test, and monitor enterprise database migrations. The program includes approximately 25 hours of content, featuring real-world scenarios and guided instruction from Google Cloud experts. Learners progress at their own pace, with a recommended commitment of 10 hours per week to complete the course efficiently.

Module 1: A Tour of Google Cloud Hands-on Labs

Estimated time: 0.5 hours

• Introduction to the Qwiklabs platform
• Navigating the Google Cloud Console
• Accessing lab resources and environments

Module 2: Google Cloud Fundamentals: Core Infrastructure

Estimated time: 5 hours

• Overview of Google Cloud's core services
• Understanding cloud infrastructure components
• Exploring compute, storage, and networking basics
• Introduction to identity and security in Google Cloud

Module 3: Cloud SQL for MySQL and PostgreSQL

Estimated time: 4 hours

• Creating and connecting to a Cloud SQL for MySQL instance
• Migrating MySQL databases from Amazon RDS to Cloud SQL
• Migrating on-premises MySQL databases using Continuous Migration Service
• Migrating PostgreSQL databases to Cloud SQL
• Connecting applications to Cloud SQL for PostgreSQL

Module 4: Securing and Managing Cloud SQL

Estimated time: 1.3 hours

• Implementing security measures for Cloud SQL instances
• Configuring replication for high availability
• Enabling point-in-time recovery for Cloud SQL for PostgreSQL

Module 5: Cloud Spanner: Design and Deployment

Estimated time: 3 hours

• Loading data into Cloud Spanner and performing backups
• Designing schemas for Cloud Spanner
• Analyzing query plans and performance
• Deploying a modern web app connected to a Cloud Spanner instance

Module 6: Enterprise Database Migration

Estimated time: 19 hours

• Planning enterprise database migration strategies
• Executing end-to-end migration workflows
• Testing and monitoring database migrations on Google Cloud

Prerequisites

• Familiarity with SQL and relational database concepts
• Basic understanding of cloud computing fundamentals
• Experience with database administration or backend development

What You'll Be Able to Do After

• Design and implement database solutions on Google Cloud
• Migrate on-premises and third-party databases to Google Cloud
• Secure and optimize Cloud SQL and Cloud Spanner instances
• Prepare for the Google Cloud Professional Cloud Database Engineer certification
• Deploy and manage scalable database-backed applications