Ignit Logo

Enterprise Database Migration (EDM)

Virtual Learning: 1,850€ + IVA

REF: EDM Catálogo: Google Cloud Área: Infrastructure Modernization

Duração icon

Duração:

4 dias

Próxima Data icon

Próxima Data:

24 a 27 Jun 2025

Local icon

Local:

Online

Descrição

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 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.

*PVP por participante. A realização do curso nas datas apresentadas está sujeita a um quórum mínimo de inscrições.

Destinatários

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.

  • Área: Google Cloud

Quero inscrever-me.

Programa:

Module 1: Migrating Enterprise Databases to the Cloud

In this module, you learn some theories and motivations behind the course.

Lessons:

  • Traditional Database Architectures
  • Optimizing Databases for the Cloud
  • Architecting Scalable and Highly Available Database

Module 2: Google Cloud Data Migration Solutions

In this module, you learn about the various solutions Google provides for running your databases.

Lessons:

  • Leveraging Google Cloud Infrastructure as a Service
  • Lab: Creating Databases in Compute Engine
  • Running Databases in a Kubernetes Cluster
  • Lab: Running Databases in GKE
  • Managed Relational Databases
  • Lab: Creating Cloud SQL Databases
  • Bare Metal Solution
  • Estimating Costs
  • Enterprise Database Migration Case Study

Module 3: Google Implementation Methodology

In this module, you learn about Google's recommended approach for migrating enterprise applications and databases to the cloud.

Lessons:

  • Google Migration Methodology
  • Database Migration Activities
  • Database Migration Approaches
  • Activity review: Planning a database migration project

Module 4: Migration Strategies

In this module, you learn about different strategies you can take when moving your applications and databases to the cloud.

Lessons:

  • Lift and Shift
  • Backup and Restore
  • Live Database Migration
  • Optimize Databases for the Cloud

Module 5: Networking for Secure Database Connectivity

In this module, you learn how to build a secure network for database connectivity.

Lessons:

  • Building Secure Networks
  • Lab: Using Terraform to Create Networks and Firewalls
  • Connecting Networks
  • Lab: Use Terraform to Create a Network Peering
  • Enabling Communication Across Networks
  • Lab: Using Terraform to Create Clients and Servers
  • Network Considerations for Managed Databases

Module 6: Migrating SQL Server Databases to Google Cloud

In this module, you learn about the options available for migrating a SQL Server database to Google Cloud.

Lessons:

  • SQL Server on Compute Engine
  • Lab: Creating SQL Server Databases on Compute Engine
  • SQL Server on Cloud SQL
  • Lab: Administering a Highly Available Cloud SQL for SQL Server Database
  • SQL Server on GKE
  • Lab: Running SQL Server on Google Kubernetes Engine

Module 7: Migrating Oracle Databases to Google Cloud

In this module, you learn about how to migrate Oracle databases to Google Cloud.

Lessons:

  • Why Oracle on Google Cloud
  • Technical Specs
  • Use Cases
  • Lab: Deploying the Oracle on Bare Metal Solution

Module 8: Testing and Monitoring SQL Server Databases in Google Cloud

In this module, you learn about testing and monitoring options for SQL Server databases deployed on Google Cloud.

Lessons:

  • Testing
  • Monitoring

Module 9: Google Cloud Data Migration Services

In this module, you learn about options and tools available to assist your data migration activties to Google Cloud.

Lessons:

  • Google Cloud Data Migration Services
  • Programming Data Processing Pipelines with Data Fusion
  • Creating Workflows with Composer
  • Third-Party Tools
  • Lab: Performing an Online Database Migration

Module 10: Making the Business Case for Moving to Google Cloud

In this module, you learn how to write a business case for a Google Cloud database migration project.

Lessons:

  • Writing a Business Case
  • Activity review Writing a Business Case

Pré-requisitos:

  • Professional Cloud Architect and/or Professional Data Engineer certification.
  • Understanding of relational and NoSQL database design.
  • Database development experience using SQL.
  • Programming experience.

Quero inscrever-me.

Partilha:

We meet future and then we make it spark slogan

Precisas de ajuda a encontrar o teu futuro?

A background of the Ignit sparks