{"course":{"productid":30574,"modality":1,"active":true,"language":"en","title":"Enterprise Database Migration","productcode":"EDM","vendorcode":"GO","vendorname":"Google","fullproductcode":"GO-EDM","courseware":{"has_ekit":false,"has_printkit":true,"language":""},"url":"https:\/\/portal.flane.ch\/course\/google-edm","objective":"<ul>\n<li>Plan, execute, test, and monitor simple and complex enterprise database migrations to Google Cloud.<\/li><li>Evaluate on-premises database architectures and plan migrations to cloud-optimized deployments.<\/li><li>Choose appropriate Google Cloud database targets based on on-premises data sources.<\/li><li>Migrate SQL Server databases to Cloud SQL and Compute Engine.<\/li><li>Run Oracle databases on Google Cloud bare metal.<\/li><li>Recognize and overcome the real-world challenges of moving data to prevent data loss, preserve data integrity, and minimize downtime.<\/li><li>Test and monitor data migration projects.<\/li><li>Leverage tools to automate data migration.<\/li><li>Make the business case for moving databases to Google Cloud.<\/li><\/ul>","essentials":"<ul>\n<li>GCP Professional Cloud Architect and\/or Professional Data Engineer certification<\/li><li>Understanding of relational and NoSQL database design<\/li><li>Database development experience using SQL<\/li><li>Programming experience<\/li><\/ul>","audience":"<p>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.<\/p>","outline":"<h4>Module 01: Migrating Enterprise Databases to the Cloud<\/h4><ul>\n<li>Get a high-level solution overview of use cases, customers, and competitors.<\/li><li>Understand traditional database architectures.<\/li><li>Optimize databases for the cloud.<\/li><li>Architect cloud databases for high-availability, scalability, and durability.<\/li><\/ul><h4>Module 02: Google Cloud Data Migration Solutions<\/h4><ul>\n<li>Evaluate the database solutions available on Google Cloud.<\/li><li>Run databases on Google Cloud infrastructure using Compute Engine.<\/li><li>Leverage Kubernetes and GKE for deploying databases.<\/li><li>Use Cloud SQL for managed database solutions.<\/li><li>Provision Bare Metal Solution for Oracle databases.<\/li><li>Estimate the cost of database solutions.<\/li><\/ul><h4>Module 03: Google Implementation Methodology<\/h4><ul>\n<li>Migrate to the cloud using Google&rsquo;s implementation methodology<\/li><li>Perform the key database migration activities<\/li><li>Choose the appropriate database migration approach.<\/li><\/ul><h4>Module 04:Migration Strategies<\/h4><ul>\n<li>Lift and shift databases from on-premises to Google Cloud.<\/li><li>Backup and restore databases from on-premises to Google Cloud services.<\/li><li>Migrate databases to the cloud with no downtime.<\/li><li>Optimize databases for the cloud.<\/li><\/ul>\n<h4>Module 05: Networking for Secure Database Connectivity<\/h4><ul>\n<li>Build secure networks to host databases and database client applications.<\/li><li>Allow secure communication across networks using VPC Peering, VPNs, and interconnect.<\/li><li>Control access to databases using firewall rules.<\/li><li>Automate network infrastructure using Terraform.<\/li><\/ul><h4>Module 06: Migrating SQL Server Databases to Google Cloud<\/h4><ul>\n<li>Lift and shift SQL Server databases using Compute Engine.<\/li><li>Employ Cloud SQL for managed SQL Server databases.<\/li><li>Architect SQL Server for security, high availability, and disaster recovery.<\/li><li>Configure SQL Server to run with Kubernetes on GKE.<\/li><\/ul><h4>Module 07: Migrating Oracle Databases to Google Cloud<\/h4><ul>\n<li>Explain why running Oracle on Google Cloud makes sense.<\/li><li>Review the technical specs of Oracle BMS.<\/li><li>Define common use cases for running Oracle on Google Cloud.<\/li><\/ul><h4>Module 08: Testing and Monitoring Databases in Google Cloud<\/h4><ul>\n<li>Use unit, integration, and regression testing techniques to ensure database migration success.<\/li><li>Monitor your migration projects with Google tools.<\/li><\/ul><h4>Module 09: Google Cloud Data Migration Tools<\/h4><ul>\n<li>Move large amounts of data to the cloud using Google transfer services.<\/li><li>Program data processing and ETL pipelines using Cloud Data Fusion.<\/li><li>Create workflows using Composer.<\/li><\/ul><h4>Module 10: Making the Business Case for Moving to Google Cloud<\/h4><ul>\n<li>Write a business case to justify a database migration.<\/li><li>Perform risk and cost\/benefit analysis on a cloud migration project.<\/li><li>Estimate the costs associated with database migration.<\/li><\/ul>","summary":"<p>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\nparticipants move databases to GCP while taking advantage of various GCP services.<\/p>\n<p>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.<\/p>","objective_plain":"- Plan, execute, test, and monitor simple and complex enterprise database migrations to Google Cloud.\n- Evaluate on-premises database architectures and plan migrations to cloud-optimized deployments.\n- Choose appropriate Google Cloud database targets based on on-premises data sources.\n- Migrate SQL Server databases to Cloud SQL and Compute Engine.\n- Run Oracle databases on Google Cloud bare metal.\n- Recognize and overcome the real-world challenges of moving data to prevent data loss, preserve data integrity, and minimize downtime.\n- Test and monitor data migration projects.\n- Leverage tools to automate data migration.\n- Make the business case for moving databases to Google Cloud.","essentials_plain":"- GCP Professional Cloud Architect and\/or Professional Data Engineer certification\n- Understanding of relational and NoSQL database design\n- Database development experience using SQL\n- Programming experience","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.","outline_plain":"Module 01: Migrating Enterprise Databases to the Cloud\n\n\n- Get a high-level solution overview of use cases, customers, and competitors.\n- Understand traditional database architectures.\n- Optimize databases for the cloud.\n- Architect cloud databases for high-availability, scalability, and durability.\nModule 02: Google Cloud Data Migration Solutions\n\n\n- Evaluate the database solutions available on Google Cloud.\n- Run databases on Google Cloud infrastructure using Compute Engine.\n- Leverage Kubernetes and GKE for deploying databases.\n- Use Cloud SQL for managed database solutions.\n- Provision Bare Metal Solution for Oracle databases.\n- Estimate the cost of database solutions.\nModule 03: Google Implementation Methodology\n\n\n- Migrate to the cloud using Google\u2019s implementation methodology\n- Perform the key database migration activities\n- Choose the appropriate database migration approach.\nModule 04:Migration Strategies\n\n\n- Lift and shift databases from on-premises to Google Cloud.\n- Backup and restore databases from on-premises to Google Cloud services.\n- Migrate databases to the cloud with no downtime.\n- Optimize databases for the cloud.\n\nModule 05: Networking for Secure Database Connectivity\n\n\n- Build secure networks to host databases and database client applications.\n- Allow secure communication across networks using VPC Peering, VPNs, and interconnect.\n- Control access to databases using firewall rules.\n- Automate network infrastructure using Terraform.\nModule 06: Migrating SQL Server Databases to Google Cloud\n\n\n- Lift and shift SQL Server databases using Compute Engine.\n- Employ Cloud SQL for managed SQL Server databases.\n- Architect SQL Server for security, high availability, and disaster recovery.\n- Configure SQL Server to run with Kubernetes on GKE.\nModule 07: Migrating Oracle Databases to Google Cloud\n\n\n- Explain why running Oracle on Google Cloud makes sense.\n- Review the technical specs of Oracle BMS.\n- Define common use cases for running Oracle on Google Cloud.\nModule 08: Testing and Monitoring Databases in Google Cloud\n\n\n- Use unit, integration, and regression testing techniques to ensure database migration success.\n- Monitor your migration projects with Google tools.\nModule 09: Google Cloud Data Migration Tools\n\n\n- Move large amounts of data to the cloud using Google transfer services.\n- Program data processing and ETL pipelines using Cloud Data Fusion.\n- Create workflows using Composer.\nModule 10: Making the Business Case for Moving to Google Cloud\n\n\n- Write a business case to justify a database migration.\n- Perform risk and cost\/benefit analysis on a cloud migration project.\n- Estimate the costs associated with database migration.","summary_plain":"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\nparticipants move databases to GCP while taking advantage of various GCP services.\n\nThis 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.","skill_level":"Intermediate","version":"1.0","duration":{"unit":"d","value":4,"formatted":"4 days"},"pricelist":{"List Price":{"US":{"country":"US","currency":"USD","taxrate":null,"price":2495},"IT":{"country":"IT","currency":"EUR","taxrate":20,"price":2600},"SI":{"country":"SI","currency":"EUR","taxrate":20,"price":2600},"GB":{"country":"GB","currency":"GBP","taxrate":20,"price":2640},"CA":{"country":"CA","currency":"CAD","taxrate":null,"price":3445},"FR":{"country":"FR","currency":"EUR","taxrate":19.6,"price":3170}}},"lastchanged":"2025-09-30T15:17:10+02:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/en\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course-schedule\/30574","source_lang":"en","source":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course\/google-edm"}}