PTI-PWEDBM-AOfficial Google Curriculum
Enterprise Database Migration
4 daysILTIntermediateLoading...
Overview
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.
What You'll Learn
- Plan, execute, test, and monitor simple and complex enterprise database migrations to Google Cloud
- Evaluate on-premises database architectures and plan migrations to cloud-optimized deployments
- Choose appropriate Google Cloud database targets based on on-premises data sources
- Migrate SQL Server databases to Cloud SQL and Compute Engine
- Run Oracle databases on Google Cloud bare metal
- Recognize and overcome the real-world challenges of moving data to prevent data loss, preserve data integrity, and minimize downtime
- Test and monitor data migration projects
- Leverage tools to automate data migration
- Make the business case for moving databases to Google Cloud
Who Should Attend
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.
Prerequisites
GCP Professional Cloud Architect and/or Professional Data Engineer certification; Understanding of relational and NoSQL database design; Database development experience using SQL; Programming experience.
Products Covered
Compute EngineCloud SQLGKEBare Metal SolutionCloud Data FusionCloud ComposerTerraform
Course Modules
1
Migrating Enterprise Databases to the Cloud
Topics
- 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
Learning Outcomes
- 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
Activities
Lecture
2
Google Cloud Data Migration Solutions
Topics
- 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
Learning Outcomes
- 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
Activities
LectureLabsActivity
3
Google Implementation Methodology
Topics
- Migrate to the cloud using Google's implementation methodology
- Perform the key database migration activities
- Choose the appropriate database migration approach
Learning Outcomes
- Migrate to the cloud using Google's implementation methodology
- Perform the key database migration activities
- Choose the appropriate database migration approach
Activities
LectureActivity
4
Migration Strategies
Topics
- 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
Learning Outcomes
- 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
Activities
Lecture
5
Networking for Secure Database Connectivity
Topics
- 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
Learning Outcomes
- 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
Activities
LectureLabs
6
Migrating SQL Server Databases to Google Cloud
Topics
- 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
Learning Outcomes
- 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
Activities
LectureLabs
7
Migrating Oracle Databases to Google Cloud
Topics
- 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
Learning Outcomes
- 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
Activities
LectureLab
8
Testing and Monitoring Databases in Google Cloud
Topics
- Use unit, integration, and regression testing techniques to ensure database migration success
- Monitor your migration projects with Google tools
Learning Outcomes
- Use unit, integration, and regression testing techniques to ensure database migration success
- Monitor your migration projects with Google tools
Activities
LectureLabs
9
Google Cloud Data Migration Tools
Topics
- 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
Learning Outcomes
- 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
Activities
LectureLab
10
Making the Business Case for Moving to Google Cloud
Topics
- 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
Learning Outcomes
- 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
Activities
LectureActivity
What's Not Covered
- Database Administration tasks
Get This Training
No public classes currently scheduled. Express interest below or request private training.
Course Details
- Course Code
- PTI-PWEDBM-A
- Duration
- 4 days
- Format
- ILT
- Level
- Intermediate
- Modules
- 10
- Activities
- 14
- Price
- Loading...
Questions About This Course?
Contact us for custom scheduling, group discounts, or curriculum customization.
Contact UsStarting fromLoading...