GC Partner no outline H
8373  Reviews star_rate star_rate star_rate star_rate star_half

Enterprise Database Migration

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

Read More
By Request
$3,600 USD
Duration 4 days
Course Code GCP-EDM
Available Formats Classroom

Overview

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 GCP while taking advantage of various GCP 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.

Skills Gained

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

Course Details

Outline

Module 01: Migrating Enterprise Databases to the Cloud

  • Get a high-level solution overview of use cases, customers, and competitors.
  • Understand traditional database architectures.
  • Optimize databases for the cloud.
  • Architect cloud databases for high availability, scalability, and durability.

Module 02: 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 03: 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 04: Migration Strategies

  • Lift and shift databases from on-premises to Google Cloud.
  • Backup and restore databases from on-premises to Google Cloud services.
  • Migrate databases to the cloud with no downtime.
  • Optimize databases for the cloud.

Module 05: 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 06: 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 07: 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 08: Testing and 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 09: 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.
Read Less

Schedule

Upcoming Course Dates

There are currently no scheduled dates for this course. If you are interested in this course, contact us with the form below.

Contact Information

FAQ

Does the course schedule include a Lunchbreak?

Classes typically include a 1-hour lunch break around midday. However, the exact break times and duration can vary depending on the specific class. Your instructor will provide detailed information at the start of the course.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does Ascendient Learning deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

What does vendor-authorized training mean?

As a vendor-authorized training partner, we offer a curriculum that our partners have vetted. We use the same course materials and facilitate the same labs as our vendor-delivered training. These courses are considered the gold standard and, as such, are priced accordingly.

Is the training too basic, or will you go deep into technology?

It depends on your requirements, your role in your company, and your depth of knowledge. The good news about many of our learning paths, you can start from the fundamentals to highly specialized training.

How up-to-date are your courses and support materials?

We continuously work with our vendors to evaluate and refresh course material to reflect the latest training courses and best practices.

Are your instructors seasoned trainers who have deep knowledge of the training topic?

Ascendient Learning instructors have an average of 27 years of practical IT experience and have also served as consultants for an average of 15 years. To stay current, instructors spend at least 25 percent of their time learning new, emerging technologies and courses.

Do you provide hands-on training and exercises in an actual lab environment?

Lab access is dependent on the vendor and the type of training you sign up for. However, many of our top vendors will provide lab access to students to test and practice. The course description will specify lab access.

Will you customize the training for our company’s specific needs and goals?

We will work with you to identify training needs and areas of growth.  We offer a variety of training methods, such as private group training, on-site of your choice, and virtually. We provide courses and certifications that are aligned with your business goals.

How do I get started with certification?

Getting started on a certification pathway depends on your goals and the vendor you choose to get certified in. Many vendors offer entry-level IT certification to advanced IT certification that can boost your career. To get access to certification vouchers and discounts, please contact info@ascendientlearning.com.

Will I get access to content after I complete a course?

You will get access to the PDF of course books and guides, but access to the recording and slides will depend on the vendor and type of training you receive.

How do I request a W9 for Ascendient Learning?

View our filing status and how to request a W9.

Reviews

ExitCertified provided a very organized way to learn and provided materials to follow along.

my experince was great from the day i regetered to the actuall day of the class.

Good course. I appreciate the time the instructor put into teaching this class.

this class was informative, made me think about certifying for the suse manager cert.

Course was great and the instructor had an answer for anything that was asked during the course.