Course Description
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.
Course Outline
Module 1: 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 2: 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 3: 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 4: Migration Strategies
· Lift and shift databases from on-premises to Google Cloud
· Back up and restore databases from on-premises to Google Cloud services
· Migrate databases to the cloud with no downtime
· Optimize databases for the cloud
Module 5: 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 6: 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 7: 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 8: 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 9: 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
* Looking for schedules across time zones? Reach out to us!
* Visit or chat with us at www.xploranow.com
*Course delivered by Authorized Partner sources