🏆SFEIR is the Google Cloud EMEA Training Partner of the Year 2025🤝New partnership: Official GitLab Training🤖New training: AI-Augmented Developer
🏆SFEIR is the Google Cloud EMEA Training Partner of the Year 2025🤝New partnership: Official GitLab Training🤖New training: AI-Augmented Developer
GCP200EDBM

Enterprise Database Migration

This course is intended to give architects, engineers, and developers the skills required to help enterprise customers architect, plan, execute, and test database migration projects. Through a combination of presentations, demos, and hands-on labs participants move databases to GCP while taking advantage of various GCP services. This course covers how to move on-premises, enterprise databases like SQL Server to Google Cloud (Compute Engine and Cloud SQL) and Oracle to Google Cloud bare metal.

Google Cloud
✓ Official training Google CloudLevel Intermediate⏱️ 4 days (28h)

What you will learn

  • Plan, execute, test, and monitor simple and complex enterprise database migrations to Google Cloud.
  • Evaluate on-premises database architectures and plan migrations to cloud-optimized deployments.
  • Choose appropriate Google Cloud database targets based on on-premises data sources.
  • Migrate SQL Server databases to Cloud SQL and Compute Engine.
  • Run Oracle databases on Google Cloud bare metal.
  • Recognize and overcome the real-world challenges of moving data to prevent data loss, preserve data integrity, and minimize downtime.
  • Test and monitor data migration projects.
  • Leverage tools to automate data migration.
  • Make the business case for moving databases to Google Cloud.

Prerequisites

  • GCP Professional Cloud Architect and/or Professional Data Engineer certification
  • Understanding of relational and NoSQL database design
  • Database development experience using SQL
  • Programming experience.

Target audience

  • Engineers planning a data migration to GCP, Engineers working on a database migration project, Technical managers, IT decision-makers, and others who want to understand the benefits, risks, rewards, and processes of migrating databases to the cloud.

Training Program

10 modules to master the fundamentals

Objectives
  • Get a high-level solution overview of use cases, customers, and competitors.
  • Understand traditional database architectures.
  • Optimize databases for the cloud.
  • Architect cloud databases for high-availability, scalability, and durability.
Activities

Lecture

Objectives
  • Evaluate the database solutions available on Google Cloud.
  • Run databases on Google Cloud infrastructure using Compute Engine.
  • Leverage Kubernetes and GKE for deploying databases.
  • Use Cloud SQL for managed database solutions.
  • Provision Bare Metal Solution for Oracle databases.
  • Estimate the cost of database solutions.
Activities

Lecture, labs, and activity

Objectives
  • Migrate to the cloud using Google's implementation methodology
  • Perform the key database migration activities
  • Choose the appropriate database migration approach.
Activities

Lecture and activity

Objectives
  • Lift and shift databases from on-premises to Google Cloud.
  • Backup and restore databases from on-premises to Google Cloud services.
  • Migrate databases to the cloud with no downtime.
  • Optimize databases for the cloud.
Activities

Lecture

Objectives
  • Build secure networks to host databases and database client applications.
  • Allow secure communication across networks using VPC Peering, VPNs, and interconnect.
  • Control access to databases using firewall rules.
  • Automate network infrastructure using Terraform.
Activities

Lecture and labs

Objectives
  • Lift and shift SQL Server databases using Compute Engine.
  • Employ Cloud SQL for managed SQL Server databases.
  • Architect SQL Server for security, high availability, and disaster recovery.
  • Configure SQL Server to run with Kubernetes on GKE.
Activities

Lecture and labs

Objectives
  • Explain why running Oracle on Google Cloud makes sense.
  • Review the technical specs of Oracle BMS.
  • Define common use cases for running Oracle on Google Cloud.
Activities

Lecture and lab

Objectives
  • Use unit, integration, and regression testing techniques to ensure database migration success.
  • Monitor your migration projects with Google tools.
Activities

Lecture and labs

Objectives
  • Move large amounts of data to the cloud using Google transfer services
  • Program data processing and ETL pipelines using Cloud Data Fusion
  • Create workflows using Composer
Activities

Lecture and lab

Objectives
  • Write a business case to justify a database migration.
  • Perform risk and cost/benefit analysis on a cloud migration project.
  • Estimate the costs associated with database migration.
Activities

Lecture and activity

Related Trainings

AWS

Advanced Architecting on AWS

In this course, each module presents a scenario with an architectural challenge to be solved. You will examine available AWS services and features as solutions to the problem. You will gain insights by participating in problem-based discussions and learning about the AWS services that you could apply to meet the challenges. Over 3 days, the course goes beyond the basics of a cloud infrastructure and covers topics to meet a variety of needs for AWS customers. Course modules focus on managing multiple AWS accounts, hybrid connectivity and devices, networking with a focus on AWS Transit Gateway connectivity, container services, automation tools for continuous integration/continuous delivery (CI/CD), security and distributed denial of service (DDoS) protection, data lakes and data stores, edge services, migration options, and managing costs. The course concludes by presenting you with scenarios and challenging you to identify the best solutions.

3 d
Advanced
AWS
Best

Architecting on AWS

Architecting on AWS is for solutions architects, solution-design engineers, and developers seeking an understanding of AWS architecting. In this course, you will learn to identify services and features to build resilient, secure, and highly available IT solutions on the AWS Cloud. Architectural solutions differ depending on industry, types of applications, and business size. AWS Authorized Instructors emphasize best practices using the AWS Well-Architected Framework, and guide you through the process of designing optimal IT solutions based on real-life scenarios. The modules focus on account security, networking, compute, storage, databases, monitoring, automation, containers, serverless architecture, edge services, and backup and recovery. At the end of the course, you will practice building a solution and apply what you have learned.

3 d
Intermediate
View all trainings →

Upcoming sessions

March 2, 2026
Distanciel • Français
Register
March 23, 2026
Distanciel • Français
Register
November 16, 2026
Distanciel • Français
Register

Quality Process

SFEIR Institute's commitment: an excellence approach to ensure the quality and success of all our training programs. Learn more about our quality approach

Teaching Methods Used
  • Lectures / Theoretical Slides — Presentation of concepts using visual aids (PowerPoint, PDF).
  • Technical Demonstration (Demos) — The instructor performs a task or procedure while students observe.
  • Guided Labs — Guided practical exercises on software, hardware, or technical environments.
  • Quiz / MCQ — Quick knowledge check (paper-based or digital via tools like Kahoot/Klaxoon).
Evaluation and Monitoring System

The achievement of training objectives is evaluated at multiple levels to ensure quality:

  • Continuous Knowledge Assessment : Verification of knowledge throughout the training via participatory methods (quizzes, practical exercises, case studies) under instructor supervision.
  • Progress Measurement : Comparative self-assessment system including an initial diagnostic to determine the starting level, followed by a final evaluation to validate skills development.
  • Quality Evaluation : End-of-session satisfaction questionnaire to measure the relevance and effectiveness of the training as perceived by participants.

3,160€ excl. VAT

per learner

ReserveQuote