Data Engineering
Enterprise Database Migration
Develop the expertise needed to guide enterprise customers through evaluating and managing existing database architectures. This course equips you with the skills to design, plan, execute, and test seamless database migrations to Google Cloud
Duration
4 Days
What you'll learn
Plan and Migrate:
Execute and monitor database migrations, including SQL Server and Oracle, while ensuring data integrity and minimal downtime.
Optimize and Automate:
Design cloud-ready architectures, select suitable databases, and automate migration workflows.
Test and Monitor:
Ensure successful migrations with robust testing, monitoring, and a strong business case.
COURSE AGENDA
Migrating Enterprise Databases to the Cloud
- Gain an overview of cloud migration use cases, customer scenarios, and market competitors.
- Understand traditional database architectures and their limitations.
- Optimize databases for cloud environments.
- Design cloud architectures for high availability, scalability, and durability.
Google Cloud Data Migration Solutions
- Explore database solutions available on Google Cloud.
- Deploy databases on Compute Engine for full infrastructure control.
- Utilize Kubernetes and GKE for containerized database deployment.
- Leverage Cloud SQL for fully managed database solutions.
- Provision Bare Metal Solution for Oracle databases.
- Estimate costs for different Google Cloud database solutions.
Google Implementation Methodology
- Follow Google’s proven methodology for cloud migrations.
- Perform key database migration activities with precision.
- Choose the appropriate migration approach for various scenarios.
Migration Strategies
- Execute lift-and-shift migrations from on-premises to Google Cloud.
- Perform backup and restore processes for database transitions.
- Migrate databases to the cloud with minimal downtime.
- Optimize migrated databases for cloud-native performance.
Networking for Secure Database Connectivity
- Build secure networks to host databases and client applications.
- Enable secure communication using VPC Peering, VPNs, and interconnect solutions.
- Control database access through robust firewall rules.
- Automate network infrastructure using Terraform.
Networking for Secure Database Connectivity
- Build secure networks to host databases and client applications.
- Enable secure communication using VPC Peering, VPNs, and interconnect solutions.
- Control database access through robust firewall rules.
- Automate network infrastructure using Terraform.
Migrating SQL Server Databases to Google Cloud
- Perform lift-and-shift migrations of SQL Server databases using Compute Engine.
- Use Cloud SQL for a managed SQL Server experience.
- Architect SQL Server deployments for security, high availability, and disaster recovery.
- Configure SQL Server to run on Kubernetes with GKE.
Migrating Oracle Databases to Google Cloud
- Understand the advantages of running Oracle on Google Cloud.
- Review the technical specifications of Oracle Bare Metal Solution.
- Identify common use cases for Oracle databases on Google Cloud.
Testing & Monitoring Databases in Google Cloud
- Apply unit, integration, and regression testing techniques to ensure migration success.
- Monitor migration projects using Google Cloud’s monitoring tools.
Google Cloud Data Migration Tools
- Move large volumes of data to the cloud using Google Transfer Services.
- Program ETL pipelines and data processing workflows with Cloud Data Fusion.
- Create and manage workflows using Cloud Composer.
Making the Business Case for Moving to Google Cloud
- Develop a compelling business case for database migration.
- Conduct risk assessments and cost/benefit analyses for migration projects.
- Estimate the financial impact of database migration to Google Cloud.