Enterprise Database Migration

Name: Enterprise Database Migration
Price: 1000.00 GBP

Master the skills required to help enterprise customers architect, plan, execute, and test database migration projects on this four-day course.

4 day course

Supporting material

Google Cloud Partner of the Year

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

Book this course

Call our sales team today

020 7993 4556