<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE FL_Course SYSTEM "https://www.flane.de/dtd/fl_course095.dtd"><?xml-stylesheet type="text/xsl" href="https://portal.flane.ch/css/xml-course.xsl"?><course productid="30574" language="fr" source="https://portal.flane.ch/swisscom/fr/xml-course/google-edm" lastchanged="2025-09-30T15:17:10+02:00" parent="https://portal.flane.ch/swisscom/fr/xml-courses"><title>Enterprise Database Migration</title><productcode>EDM</productcode><vendorcode>GO</vendorcode><vendorname>Google</vendorname><fullproductcode>GO-EDM</fullproductcode><version>1.0</version><objective>&lt;ul&gt;
&lt;li&gt;Plan, execute, test, and monitor simple and complex enterprise database migrations to Google Cloud.&lt;/li&gt;&lt;li&gt;Evaluate on-premises database architectures and plan migrations to cloud-optimized deployments.&lt;/li&gt;&lt;li&gt;Choose appropriate Google Cloud database targets based on on-premises data sources.&lt;/li&gt;&lt;li&gt;Migrate SQL Server databases to Cloud SQL and Compute Engine.&lt;/li&gt;&lt;li&gt;Run Oracle databases on Google Cloud bare metal.&lt;/li&gt;&lt;li&gt;Recognize and overcome the real-world challenges of moving data to prevent data loss, preserve data integrity, and minimize downtime.&lt;/li&gt;&lt;li&gt;Test and monitor data migration projects.&lt;/li&gt;&lt;li&gt;Leverage tools to automate data migration.&lt;/li&gt;&lt;li&gt;Make the business case for moving databases to Google Cloud.&lt;/li&gt;&lt;/ul&gt;</objective><essentials>&lt;ul&gt;
&lt;li&gt;GCP Professional Cloud Architect and/or Professional Data Engineer certification&lt;/li&gt;&lt;li&gt;Understanding of relational and NoSQL database design&lt;/li&gt;&lt;li&gt;Database development experience using SQL&lt;/li&gt;&lt;li&gt;Programming experience&lt;/li&gt;&lt;/ul&gt;</essentials><audience>&lt;p&gt;Engineers planning a data migration to GCP; Engineers working on a database migration project; and Technical managers, IT decision-makers, and others who want to understand the benefits, risks, rewards, and processes of migrating databases to the cloud.&lt;/p&gt;</audience><outline>&lt;h4&gt;Module 01: Migrating Enterprise Databases to the Cloud&lt;/h4&gt;&lt;ul&gt;
&lt;li&gt;Get a high-level solution overview of use cases, customers, and competitors.&lt;/li&gt;&lt;li&gt;Understand traditional database architectures.&lt;/li&gt;&lt;li&gt;Optimize databases for the cloud.&lt;/li&gt;&lt;li&gt;Architect cloud databases for high-availability, scalability, and durability.&lt;/li&gt;&lt;/ul&gt;&lt;h4&gt;Module 02: Google Cloud Data Migration Solutions&lt;/h4&gt;&lt;ul&gt;
&lt;li&gt;Evaluate the database solutions available on Google Cloud.&lt;/li&gt;&lt;li&gt;Run databases on Google Cloud infrastructure using Compute Engine.&lt;/li&gt;&lt;li&gt;Leverage Kubernetes and GKE for deploying databases.&lt;/li&gt;&lt;li&gt;Use Cloud SQL for managed database solutions.&lt;/li&gt;&lt;li&gt;Provision Bare Metal Solution for Oracle databases.&lt;/li&gt;&lt;li&gt;Estimate the cost of database solutions.&lt;/li&gt;&lt;/ul&gt;&lt;h4&gt;Module 03: Google Implementation Methodology&lt;/h4&gt;&lt;ul&gt;
&lt;li&gt;Migrate to the cloud using Google&amp;rsquo;s implementation methodology&lt;/li&gt;&lt;li&gt;Perform the key database migration activities&lt;/li&gt;&lt;li&gt;Choose the appropriate database migration approach.&lt;/li&gt;&lt;/ul&gt;&lt;h4&gt;Module 04:Migration Strategies&lt;/h4&gt;&lt;ul&gt;
&lt;li&gt;Lift and shift databases from on-premises to Google Cloud.&lt;/li&gt;&lt;li&gt;Backup and restore databases from on-premises to Google Cloud services.&lt;/li&gt;&lt;li&gt;Migrate databases to the cloud with no downtime.&lt;/li&gt;&lt;li&gt;Optimize databases for the cloud.&lt;/li&gt;&lt;/ul&gt;
&lt;h4&gt;Module 05: Networking for Secure Database Connectivity&lt;/h4&gt;&lt;ul&gt;
&lt;li&gt;Build secure networks to host databases and database client applications.&lt;/li&gt;&lt;li&gt;Allow secure communication across networks using VPC Peering, VPNs, and interconnect.&lt;/li&gt;&lt;li&gt;Control access to databases using firewall rules.&lt;/li&gt;&lt;li&gt;Automate network infrastructure using Terraform.&lt;/li&gt;&lt;/ul&gt;&lt;h4&gt;Module 06: Migrating SQL Server Databases to Google Cloud&lt;/h4&gt;&lt;ul&gt;
&lt;li&gt;Lift and shift SQL Server databases using Compute Engine.&lt;/li&gt;&lt;li&gt;Employ Cloud SQL for managed SQL Server databases.&lt;/li&gt;&lt;li&gt;Architect SQL Server for security, high availability, and disaster recovery.&lt;/li&gt;&lt;li&gt;Configure SQL Server to run with Kubernetes on GKE.&lt;/li&gt;&lt;/ul&gt;&lt;h4&gt;Module 07: Migrating Oracle Databases to Google Cloud&lt;/h4&gt;&lt;ul&gt;
&lt;li&gt;Explain why running Oracle on Google Cloud makes sense.&lt;/li&gt;&lt;li&gt;Review the technical specs of Oracle BMS.&lt;/li&gt;&lt;li&gt;Define common use cases for running Oracle on Google Cloud.&lt;/li&gt;&lt;/ul&gt;&lt;h4&gt;Module 08: Testing and Monitoring Databases in Google Cloud&lt;/h4&gt;&lt;ul&gt;
&lt;li&gt;Use unit, integration, and regression testing techniques to ensure database migration success.&lt;/li&gt;&lt;li&gt;Monitor your migration projects with Google tools.&lt;/li&gt;&lt;/ul&gt;&lt;h4&gt;Module 09: Google Cloud Data Migration Tools&lt;/h4&gt;&lt;ul&gt;
&lt;li&gt;Move large amounts of data to the cloud using Google transfer services.&lt;/li&gt;&lt;li&gt;Program data processing and ETL pipelines using Cloud Data Fusion.&lt;/li&gt;&lt;li&gt;Create workflows using Composer.&lt;/li&gt;&lt;/ul&gt;&lt;h4&gt;Module 10: Making the Business Case for Moving to Google Cloud&lt;/h4&gt;&lt;ul&gt;
&lt;li&gt;Write a business case to justify a database migration.&lt;/li&gt;&lt;li&gt;Perform risk and cost/benefit analysis on a cloud migration project.&lt;/li&gt;&lt;li&gt;Estimate the costs associated with database migration.&lt;/li&gt;&lt;/ul&gt;</outline><objective_plain>- 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.</objective_plain><essentials_plain>- GCP Professional Cloud Architect and/or Professional Data Engineer certification
- Understanding of relational and NoSQL database design
- Database development experience using SQL
- Programming experience</essentials_plain><audience_plain>Engineers planning a data migration to GCP; Engineers working on a database migration project; and Technical managers, IT decision-makers, and others who want to understand the benefits, risks, rewards, and processes of migrating databases to the cloud.</audience_plain><outline_plain>Module 01: Migrating Enterprise Databases to the Cloud


- 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.
Module 02: Google Cloud Data Migration Solutions


- 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.
Module 03: Google Implementation Methodology


- Migrate to the cloud using Google’s implementation methodology
- Perform the key database migration activities
- Choose the appropriate database migration approach.
Module 04:Migration Strategies


- 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.

Module 05: Networking for Secure Database Connectivity


- 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.
Module 06: Migrating SQL Server Databases to Google Cloud


- 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.
Module 07: Migrating Oracle Databases to Google Cloud


- 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.
Module 08: Testing and Monitoring Databases in Google Cloud


- Use unit, integration, and regression testing techniques to ensure database migration success.
- Monitor your migration projects with Google tools.
Module 09: Google Cloud Data Migration Tools


- 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.
Module 10: Making the Business Case for Moving to Google Cloud


- 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.</outline_plain><duration unit="d" days="4">4 jours</duration><pricelist><price country="US" currency="USD">2495.00</price><price country="IT" currency="EUR">2600.00</price><price country="SI" currency="EUR">2600.00</price><price country="GB" currency="GBP">2640.00</price><price country="CA" currency="CAD">3445.00</price><price country="FR" currency="EUR">3170.00</price></pricelist><miles/></course>