Enterprise Database Migration

Master the skills required to help enterprise customers evaluate and manage existing database architectures, as well as design, plan, execute and test database migrations to Google Cloud.

google badge
Book this course
Call our sales team today
4 day course
Partner of the Year
Private
Private
A private training session for your team. Groups can be of any size, at a location of your choice including our training centres.

Through a combination of presentations, demos, and hands-on labs, you’ll gain an understanding of how to move databases to Google Cloud while taking advantage of various 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. You’ll learn how to plan, execute, test, and monitor simple and complex enterprise database migrations to Google Cloud, as well as evaluate on-premises database architectures and plan migrations to cloud-optimised deployments.

You’ll also look at how to test and monitor data migration projects while leveraging the appropriate tools to automate data migration. Finally, we’ll show you how to make the business case for moving databases to Google Cloud.

Our Enterprise Database Migration course is available as a private training session that can be delivered via Virtual Classroom, at our training centre in The Shard, or at a location of your choice in the UK.

Course overview

Who should attend:

This course is suitable for:

  • Engineers planning a data migration to Google Cloud
  • Engineers working on a database migration project
  • Technical managers, IT decision-makers, and others who want to understand the benefits, risks, rewards and processes of migrating databases to the cloud

What you'll learn:

By the end of this course, you will be able to:

  • Plan, execute, test and monitor simple and complex enterprise database migrations to Google Cloud
  • Evaluate on-premises database architectures and plan migrations to cloud-optimised 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
  • Recognise and overcome the real-world challenges of moving data to prevents data loss, preserve data integrity, and minimise downtime
  • Test and monitor data migration projects
  • Leverage tools to automate data migration
  • Make the business case for moving databases to Google Cloud

Prerequisites

To get the most out of this course, participants should have:

  • The Google Cloud Professional Cloud Architect and / or Professional Data Engineer certification
  • An understanding of relational and NoSQL database design
  • Database development experience using SQL
  • Programming experience

Course agenda

Module 1: Migrating Enterprise Experience Databases to the Cloud
  • Get a high-level solution overview of use cases, customers, and competitors
  • Understand traditional database architectures
  • Optimise databases for the cloud
  • Architect cloud databases for high-availability, scalability, and durability
Module 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
Module 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
Module 4: Migration Strategies
  • Lift and shift databases from on-premises to Google Cloud
  • Back-up and restore databases from on-premises to Google Cloud services
  • Migrate databases to the cloud with no downtime
  • Optimise databases for the cloud
Module 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
Module 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
Module 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
Module 8: Testing & Monitoring Databases in Google Cloud
  • Use unit, integration, and regression testing techniques to ensure database migration success
  • Monitor your migration projects with Google tools
Module 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
Module 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
close
Don't miss out
Keep up to date with news, views and offers from Jellyfish Training.
Your data will be handled in accordance with our Privacy Policy