Enterprise Database Migration Duration: 4 Days

Course details

Module 1: Migrating Enterprise Databases to the Cloud
• Module Overview
• Solution Overview
• Traditional Database Architectures
• Optimizing Databases for the Cloud
• Architecting Scalable and Highly Available Database
• Module 1 Quiz
• Module Review

Module 2: Google Cloud Data Migration Solutions
• Module Overview
• Leveraging Google Cloud Infrastructure as a Service
• Lab intro: Creating Databases on Compute Engine
• Creating Databases in Compute Engine
• Lab review: Creating Databases on Compute Engine
• Running Databases in a Kubernetes Cluster
• Lab intro: Running Databases in GKE
• Running Databases in GKE
• Lab review: Running Databases in GKE
• Managed Relational Databases
• Lab intro: Creating a Cloud SQL Database
• Creating Cloud SQL Databases
• Lab review: Creating a Cloud SQL Database
• Bare Metal Solution
• Estimating Costs
• Enterprise Database Migration Case Study
• Module 2 Quiz
• Module Review
• Google Implementation Methodology
• Module Overview

Module 3: Google Migration Methodology
• Database Migration Activities
• Database Migration Approaches
• Enterprise Database Migration Case Study
• Activity review: Planning a database migration project
• Module 3 Quiz
• Module Review

Module 4: Migration Strategies
• Module Overview
• Lift and Shift
• Backup and Restore
• Live Database Migration
• Optimize Databases for the Cloud
• Module 4 Quiz
• Module Review

Module 5: Networking for Secure Database Connectivity
• Module Overview
• Building Secure Networks
• Lab intro: Using Terraform to Create Networks and Firewalls
• Using Terraform to Create Networks and Firewalls
• Lab review: Using Terraform to Create Networks and Firewalls
• Connecting Networks
• Lab intro: Use Terraform to Create a Network Peering
• Use Terraform to Create a Network Peering
• Lab review: Use Terraform to Create a Network Peering
• Enabling Communication Across Networks
• Lab intro: Using Terraform to Create Clients and Servers
• Using Terraform to Create Clients and Servers
• Lab review: Using Terraform to Create Clients and Servers
• Network Considerations for Managed Databases
• Module 5 Quiz
• Module Review

Module 6: Migrating SQL Server Databases to Google Cloud
• Module Overview
• SQL Server on Compute Engine
• Lab intro: Creating SQL Server Databases on Compute Engine
• Creating SQL Server Databases on Compute Engine
• Lab review: Creating SQL Server Databases on Compute Engine
• SQL Server on Cloud SQL
• Lab intro: Administering a Highly Available Cloud SQL for SQL Server Database
• Administering a Highly Available Cloud SQL for SQL Server Database
• Lab review: Administering a Highly Available Cloud SQL for SQL Server Database
• SQL Server on GKE
• Lab intro: Running SQL Server on Google Kubernetes Engine
• Running SQL Server on Google Kubernetes Engine
• Lab review: Running SQL Server on Google Kubernetes Engine
• Module 6 Quiz
• Module Review

Module 7: Migrating Oracle Databases to Google Cloud
• Module Overview
• Why Oracle on Google Cloud
• Technical Specs
• Use Cases
• Lab intro: Oracle on Bare Metal Solution
• Deploying the Oracle on Bare Metal Solution
• Lab review: Oracle on Bare Metal Solution
• Module 7 Quiz
• Module Review

Module 8: Testing and Monitoring SQL Server Databases in Google Cloud
• Module Overview
• Testing
• Monitoring
• Module 8 Quiz
• Module Review

Module 9: Google Cloud Data Migration Services
• Module Overview
• Google Cloud Data Migration Services
• Programming Data Processing Pipelines with Data Fusion
• Creating Workflows with Composer
• Third-Party Tools
• Lab intro: Online Data Migration to Cloud Spanner using Striim
• Performing an Online Database Migration
• Lab review: Online Data Migration to Cloud Spanner using Striim
• Module 9 Quiz
• Module Review

Module 10: Making the Business Case for Moving to Google Cloud
• Module Overview
• Writing a Business Case
• Enterprise Database Migration Case Study
• Activity review Writing a Business Case
• Module 10 Quiz
• Module Review
• Course Review