Detailed Course Outline
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.