Course
Digicomp Code PWEDBM
Enterprise Database Migration («PWEDBM»)
Course facts
- Planning, executing, testing, and monitoring simple and complex enterprise database migrations to Google Cloud
- Evaluating on-premises database architectures and planning migrations to cloud-optimized deployments
- Choosing appropriate Google Cloud database targets based on on-premises data sources
- Migrating SQL Server databases to Cloud SQL and Compute Engine
- Running Oracle databases on Google Cloud bare metal
- Recognizing and overcoming the real-world challenges of moving data to prevent data loss, preserve data integrity, and minimize downtime
- Testing and monitoring data migration projects
- Leveraging tools to automate data migration
- Making the business case for moving databases to Google Cloud
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.
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
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
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
4 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
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
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
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
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
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
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
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.
GCP Professional Cloud Architect and/or Professional Data Engineer certification; Understanding of relational and NoSQL database design; Database development experience using SQL; Programming experience.