We may earn an affiliate commission when you visit our partners.
Google Cloud

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.

Read more

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.

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.

Enroll now

Here's a deal for you

We found an offer that may be relevant to this course.
Save money when you learn. All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

What's inside

Syllabus

Introduction
Migrating Enterprise Databases to the Cloud
Google Cloud Data Migration Solutions
Google Implementation Methodology
Read more
Migration Strategies
Networking for Secure Database Connectivity
Migrating SQL Server Databases to Google Cloud
Migrating Oracle Databases to Google Cloud
Testing and Monitoring SQL Server Databases in Google Cloud
Google Cloud Data Migration Services
Making the Business Case for Moving to Google Cloud
Course Resources

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Taught by Google Cloud, who are recognized for their work in database management
Explores database migration strategies relevant to enterprise contexts
Covers practical implementation methodologies for database migrations
Develops skills in migrating popular enterprise databases like SQL Server and Oracle to Google Cloud
Provides hands-on labs to reinforce learning and demonstrate real-world applications
Examines the business value and impact of database migration

Save this course

Save Enterprise Database Migration to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Enterprise Database Migration with these activities:
Review Networking Concepts
Refresh your memory on the fundamental networking concepts and terminologies that will be used throughout the course.
Show steps
  • Review the OSI model
  • Review IP addressing
  • Review DNS
Read High-Performance MySQL
Delve deeper into the fundamentals of MySQL performance and gain practical insights from this comprehensive reference book.
Show steps
  • Read Chapter 1: Understanding MySQL Performance
  • Read Chapter 2: Monitoring MySQL Performance
  • Read Chapter 3: Tuning MySQL Configuration
Practice SQL Server Query Optimization
Sharpen your SQL Server query optimization skills through hands-on practice and improve the performance of your database queries.
Browse courses on Query Optimization
Show steps
  • Use EXPLAIN PLAN to analyze query execution plans
  • Optimize queries using indexes
  • Refactor queries to improve performance
Four other activities
Expand to see all activities and additional details
Show all seven activities
Attend a Cloud SQL Workshop
Gain hands-on experience with Cloud SQL and its migration tools by attending a workshop.
Browse courses on Cloud SQL
Show steps
  • Register for a workshop
  • Attend the workshop
Design a Database Migration Plan
Put your understanding of database migration strategies into action by creating a comprehensive plan for migrating a database to Google Cloud.
Browse courses on Database Migration
Show steps
  • Identify the source and target databases
  • Assess the data and schema compatibility
  • Choose a migration strategy
  • Develop a migration timeline
Answer Questions in the Course Discussion Forum
Contribute to the learning community by actively answering questions and sharing your knowledge in the course discussion forum.
Show steps
  • Log in to the discussion forum
  • Read through the posted questions
  • Identify questions that you can provide insightful answers to
Contribute to an Open-Source Database Project
Deepen your understanding of database technologies by contributing to the development of an open-source database project.
Browse courses on Database
Show steps
  • Identify an open-source database project to contribute to
  • Join the project's community
  • Find an issue or feature to work on

Career center

Learners who complete Enterprise Database Migration will develop knowledge and skills that may be useful to these careers:
Database Administrator
Database Administrators work to make sure the systems that store critical business data are up and running. These systems may run on on-premises hardware or in the cloud. Training in on-premises and cloud database administration, such as this course provides, will help you step into the field of Database Administration.
Systems Administrator
Systems Administrators work to make sure that business processes and IT work together smoothly, which can include ensuring that the organization's databases are up and running securely and efficiently. The networking, security, database migration, and implementation methodology that you will learn about in this course will all play a role in the daily life of a Systems Administrator.
Solution Architect
Solution Architects work to design the technology infrastructure that supports a client or business. Database migration is a common part of a Solution Architect's role. The hands-on training in migration that this course provides will help a future Solution Architect become comfortable proposing and executing these sorts of changes.
Database Architect
Database Architects work to design the databases that support a business's IT infrastructure. Receiving training in both on-premises and cloud database technologies will help a future Database Architect make more informed choices about database implementation. This course covers many of the implementation decisions a Database Architect should know how to make.
Data Architect
Data Architects design and implement data storage solutions to meet the needs of a business. In this role, it would be important to be aware of design and implementation tradeoffs between migrating data on-premises and in the cloud. This course covers many of the considerations that a Data Architect must keep in mind, including networking, security, and implementation strategy.
Software Architect
Software Architects design and implement technology solutions to meet the needs of a business. In this role, it would be important to understand the implications of migrating an organization's database from on-premises hardware to the cloud. This course covers database migration at a comprehensive level, from design to implementation.
Cloud Engineer
Cloud Engineers work to make sure that an organization is using cloud resources effectively and efficiently. Efficient database migration is a key component of cloud engineering. The hands-on training that this course provides will help you prepare for a career as a Cloud Engineer.
Cloud Architect
Cloud Architects work to design and implement cloud solutions for organizations. The ability to migrate on-premises databases to the cloud is a key component of a Cloud Architect's role. This course covers the end-to-end process of database migration, providing you with the tools for success as a Cloud Architect.
Network Architect
Network Architects design and implement network solutions for organizations. The training in network design and implementation that this course provides will prepare you for a role as a Network Architect.
Database Developer
Database Developers design and implement the code required to interact with an organization's databases. The training offered in this course in both on-premises and cloud-based databases will be valuable to an aspiring Database Developer.
IT Manager
IT Managers are responsible for the IT operations of an organization. Training in database migration, data security, and data networking, like this course provides, will help you prepare for a career as an IT Manager.
Information Security Analyst
Information Security Analysts work to protect an organization's data and systems from cyberattacks. The training that this course provides in data security and data networking may be of great value to Information Security Analysts.
Business Analyst
Business Analysts work to understand the business needs of an organization and translate them into technical requirements. The training in database migration and data security that this course provides may be of some value to a Business Analyst.
Data Scientist
Data Scientists work to gather and analyze data in order to help businesses make better decisions. The training in data migration that this course provides may be of some help to a Data Scientist.
Software Developer
Software Developers work to design, implement, and test software applications. The training in data migration that this course provides may be of some value to a Software Developer.

Reading list

We've selected six books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Enterprise Database Migration.
A practical guide to migrating Oracle Database 12c to Google Cloud. Provides step-by-step instructions, troubleshooting tips, and best practices specific to this migration scenario.
Offers a classic text on database design principles and techniques. Provides a foundational understanding of data modeling, normalization, and query optimization.
Focuses on data migration best practices and techniques. Provides a broader perspective on data migration beyond database migration, offering valuable insights for practitioners.
Is considered a classic in data warehouse design and architecture, but may not be directly relevant to the course content.
Provides a foundational understanding of cloud computing concepts and architecture. Useful as background reading for those new to the field of cloud computing.
A comprehensive textbook on database systems. Provides a solid foundation in database concepts and technologies, which is beneficial for understanding the fundamentals of database migration.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Enterprise Database Migration.
Enterprise Database Migration
Most relevant
AWS Database Specialty Certification
Most relevant
Exam Prep DP-300: Azure Database Administrator Associate
Most relevant
Introduction to the Azure Data Migration Service
Most relevant
Storage, Databases, and Migration for Associate AWS...
Most relevant
Migrating Databases with AWS Database Migration Service
Most relevant
Microsoft Azure Solutions Architect: Design Migrations
Most relevant
Migrating On-premises MySQL Using a Continuous Database...
Most relevant
Migrating to AWS: a high level introduction
Most relevant
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser