Course

Enterprise Database Migration

Google Cloud

This comprehensive course equips architects, engineers, and developers with the skills needed for successful enterprise database migrations to Google Cloud. From planning and execution to testing and monitoring, participants will learn how to architect, plan, execute, and test database migration projects. Through a combination of presentations, demos, and hands-on labs, this course covers the migration of on-premises, enterprise databases like SQL Server to Google Cloud (Compute Engine and Cloud SQL) and Oracle to Google Cloud bare metal.

Participants will explore how to choose the appropriate Google Cloud database, migrate SQL Server databases, and run Oracle databases on Google Cloud bare metal. They will also learn to recognize and overcome challenges in moving data, prevent data loss, preserve data integrity, minimize downtime, evaluate on-premises database architectures, and make a compelling business case for migrating databases to Google Cloud.

  • Plan, execute, test, and monitor simple and complex enterprise database migrations to Google Cloud.
  • Choose an appropriate Google Cloud database, migrate SQL Server databases, and run Oracle databases on Google Cloud bare metal.
  • Recognize and overcome challenges in moving data to prevent data loss, preserve data integrity, and minimize downtime.
  • Evaluate on-premises database architectures and plan migrations. Make the business case for moving databases to Google Cloud.

Certificate Available ✔

Get Started / More Info
Enterprise Database Migration
Course Modules

This comprehensive course covers planning, executing, and monitoring database migrations to Google Cloud. Gain skills in choosing the appropriate Google Cloud database, migrating SQL Server databases, running Oracle databases on Google Cloud bare metal, and making a compelling business case for migration.

Introduction

This module provides a comprehensive introduction to the course, including a brief overview and guidance on how to send feedback.

  • Introduction and overview of the course.
  • Guidance on providing feedback and interacting with the course content.

Migrating Enterprise Databases to the Cloud

This module focuses on migrating enterprise databases to the cloud, covering traditional database architectures, optimizing databases for the cloud, and architecting scalable and highly available databases. Participants will also learn about the challenges and solutions in migrating enterprise databases to Google Cloud.

  • Overview of migrating enterprise databases to the cloud.
  • Understanding traditional database architectures and optimization for the cloud.
  • Architecting scalable and highly available databases.
  • Challenges and solutions in migrating enterprise databases to Google Cloud.

Google Cloud Data Migration Solutions

This module delves into Google Cloud data migration solutions, including leveraging Google Cloud Infrastructure as a Service, running databases in a Kubernetes cluster, managed relational databases, and the bare metal solution. Participants will also learn about estimating costs and explore a case study on enterprise database migration.

  • Leveraging Google Cloud Infrastructure as a Service for data migration.
  • Running databases in a Kubernetes cluster and managed relational databases.
  • Exploring the bare metal solution and estimating costs.
  • Case study on enterprise database migration.

Google Implementation Methodology

This module provides an overview of Google's implementation methodology for database migration, covering the methodology, migration activities, and approaches. Participants will also engage in an enterprise database migration case study and gain insights into Google's implementation methodology.

  • Overview of Google's implementation methodology for database migration.
  • Understanding migration activities and approaches.
  • Engaging in an enterprise database migration case study.
  • Insights into Google's implementation methodology.

Migration Strategies

This module explores various migration strategies, including lift and shift, backup and restore, live database migration, and optimizing databases for the cloud. Participants will gain insights into different migration strategies and their applications in database migration projects.

  • Understanding lift and shift, backup and restore, and live database migration strategies.
  • Optimizing databases for the cloud and their applications in migration projects.

Networking for Secure Database Connectivity

This module focuses on networking for secure database connectivity, covering building secure networks, connecting networks, enabling communication across networks, and network considerations for managed databases. Participants will engage in labs using Terraform to create networks, firewalls, and network peering for secure database connectivity.

  • Building secure networks and connecting networks for secure database connectivity.
  • Enabling communication across networks and network considerations for managed databases.
  • Engaging in labs using Terraform for secure database connectivity.

Migrating SQL Server Databases to Google Cloud

This module covers migrating SQL Server databases to Google Cloud, including deploying SQL Server on Compute Engine, Cloud SQL, and GKE. Participants will engage in labs to create and administer SQL Server databases on Compute Engine, Cloud SQL, and GKE.

  • Deploying SQL Server databases on Compute Engine, Cloud SQL, and GKE.
  • Engaging in labs to create and administer SQL Server databases on Google Cloud platforms.

Migrating Oracle Databases to Google Cloud

This module focuses on migrating Oracle databases to Google Cloud, including exploring the technical specs, use cases, and deploying Oracle on the bare metal solution. Participants will engage in a comprehensive lab to deploy Oracle on the bare metal solution in Google Cloud.

  • Exploring the technical specs and use cases for migrating Oracle databases to Google Cloud.
  • Engaging in a comprehensive lab to deploy Oracle on the bare metal solution.

Testing and Monitoring SQL Server Databases in Google Cloud

This module provides insights into testing and monitoring SQL Server databases in Google Cloud, covering testing, monitoring, and ensuring database functionality and performance in the cloud environment. Participants will gain skills in testing and monitoring SQL Server databases to ensure their successful migration to Google Cloud.

  • Understanding testing and monitoring of SQL Server databases in Google Cloud.
  • Ensuring database functionality and performance in the cloud environment.

Google Cloud Data Migration Services

This module explores Google Cloud data migration services, including programming data processing pipelines with Data Fusion, creating workflows with Composer, and leveraging third-party tools for data migration. Participants will engage in a lab to perform an online database migration to Cloud Spanner using Striim.

  • Programming data processing pipelines and creating workflows with Google Cloud services.
  • Leveraging third-party tools for data migration and engaging in a lab for online database migration.

Making the Business Case for Moving to Google Cloud

This module focuses on making the business case for moving to Google Cloud, covering the process of writing a compelling business case for database migration. Participants will engage in an enterprise database migration case study and gain insights into making a compelling business case for moving to Google Cloud.

  • Understanding the process of writing a compelling business case for database migration to Google Cloud.
  • Engaging in an enterprise database migration case study and gaining insights into making a compelling business case for migration.
More Cloud Computing Courses

Customer Experiences with Contact Center AI - Dialogflow ES

Google Cloud

Customer Experiences with Contact Center AI - Dialogflow ES equips learners with the skills to design and implement virtual agents using Dialogflow ES, integrating...

Bigtable: Qwik Start - Command Line

Google Cloud

Learn to use the cbt command line to connect to Cloud Bigtable, perform administrative tasks, and read and write data in a table.

Manage Azure Blob Storage Lifecycle

Coursera Project Network

Manage Azure Blob Storage Lifecycle is a beginner-level guided project that teaches you how to set up a storage account, transfer blobs to different tiers, and automate...

VPC Network Peering

Google Cloud

Learn to establish private connectivity across two Google Cloud Platform (GCP) Virtual Private Cloud (VPC) networks using VPC Network Peering.